[vc_row css=”.vc_custom_1622599710658{padding-top: 40px !important;}”][vc_column][woocommerce_template_single_title][woocommerce_template_single_excerpt][vc_row_inner css=”.vc_custom_1622599950355{padding-top: 20px !important;padding-bottom: 20px !important;}”][vc_column_inner width=”1/5″][/vc_column_inner][vc_column_inner width=”1/5″][/vc_column_inner][vc_column_inner width=”1/5″][/vc_column_inner][vc_column_inner width=”1/5″][/vc_column_inner][vc_column_inner width=”1/5″][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/4″][vc_btn title=”Enrol Now” style=”classic” color=”warning” align=”center” link=”url:%2Fcheckout%2F%3Fadd-to-cart%3D5559|||”][/vc_column_inner][vc_column_inner width=”1/4″][vc_btn title=”Find Out More” style=”classic” color=”info” align=”center” link=”url:%2Ffind-out-more%2F|||”][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][vc_column_inner width=”1/4″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column][templatera id=”13689″][/vc_column][/vc_row][vc_row css=”.vc_custom_1622597033875{padding-top: 40px !important;padding-bottom: 40px !important;}”][vc_column width=”1/2″][vc_column_text css=”.vc_custom_1596262113348{margin-bottom: 0px !important;padding-right: 15px !important;padding-bottom: 0px !important;padding-left: 15px !important;}”]
Key Benefits
- Learn advanced Microsoft Excel Skills
- Increase your job prospects and gain an industry and employer recognised certificate – with an Advanced Certificate in Microsoft Excel on your CV, your career will get the boost it needs!
- Flexible online study – work at your own pace in your own time with unlimited tutor support. We can work around you!
[/vc_column_text][/vc_column][vc_column width=”1/2″ css=”.vc_custom_1624237844167{background-color: #e9f7f8 !important;}”][vc_geotwp_country country=”new-zealand, australia” region=”new-zealand,australia” exclude_country=”ireland” exclude_region=”ireland”][vc_column_text css=”.vc_custom_1633329898185{margin-bottom: 0px !important;padding-right: 15px !important;padding-bottom: 0px !important;padding-left: 15px !important;}”]
Course Summary
Investment: Only $395
Assessments: Case studies, quizzes, written assessments and practical exercises
Duration: 8-10 hours
Access time: You will have access to this course for up to 6 months until you complete.
Delivery: Online with unlimited tutor support
Our quality promise: This course comes with a 14-day money back guarantee.[/vc_column_text][/vc_geotwp_country][vc_geotwp_country country=”ireland” region=”ireland” exclude_country=”new-zealand, australia” exclude_region=”new-zealand,australia”][vc_column_text css=”.vc_custom_1633329903798{margin-bottom: 0px !important;padding-right: 15px !important;padding-bottom: 0px !important;padding-left: 15px !important;}”]
Course Summary
Investment: Only €240
Assessments: Case studies, quizzes, written assessments and practical exercises
Duration: 8-10 hours
Access time: You will have access to this course for up to 6 months until you complete.
Delivery: Online with unlimited tutor support
Our quality promise: This course comes with a 14-day money back guarantee.[/vc_column_text][/vc_geotwp_country][vc_row_inner css=”.vc_custom_1624237930760{padding-top: 30px !important;}”][vc_column_inner width=”1/2″][vc_btn title=”Enrol Now” style=”classic” color=”warning” align=”center” link=”url:%2Fcheckout%2F%3Fadd-to-cart%3D5559|||”][/vc_column_inner][vc_column_inner width=”1/2″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/2″][vc_column_text css=”.vc_custom_1596262159251{margin-bottom: 0px !important;padding-right: 15px !important;padding-bottom: 0px !important;padding-left: 15px !important;}”]
Covering the following modules
Advanced Functions
- Absolute referencing
- Range names
- Using the IF function
- Using the VLookup function
- Nesting functions
Advanced Chart Features
- Formatting chart objects
- Trendlines
- Creating pivot charts
- Manipulating pivot charts
Securing Spreadsheets
- Protecting your worksheet
- Protecting your workbook, including using passwords
Using Excel Macros
- Creating macros with the macro recorder
- Running a macro
Excel Data Tools
- Removing duplicates
- Text to columns
- Goal seek
- Scenario manager
[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_column_text css=”.vc_custom_1624080191577{margin-bottom: 0px !important;padding-right: 15px !important;padding-bottom: 0px !important;padding-left: 15px !important;}”]
You will learn how to
- Apply advanced functions to access multiple sheets and manipulate data
- Apply advanced chart features to visually represent your data
- Protect your spreadsheet from accidental or intentional harm
- Automate activities within your spreadsheet using macros
- Gain a deeper understanding of your data using the data tools
[/vc_column_text][vc_row_inner][vc_column_inner width=”1/3″][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][vc_column_text css=”.vc_custom_1624237956028{padding-top: 30px !important;}”]
What our students say about this course
[/vc_column_text][vc_column_text]
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text][/vc_column_text][/vc_column][/vc_row][vc_row disable_element=”yes”][vc_column][templatera id=”13680″][/vc_column][/vc_row]
Reviews
There are no reviews yet.