Advanced Certificate in Microsoft Excel

[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]