Advanced Certificate in Microsoft Excel

Suggested Price: AUD $395.00

Go beyond the basics and become Microsoft Excel expert!

Master Microsoft Excel with our online training course developed by a Microsoft expert. Go beyond the basics and learn the advanced features and functions of Microsoft Excel including manipulating data, advanced chart features, macros and protecting your spreadsheet.

SKU: CITSC1003 Categories: , ,

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

Be the first to review “Advanced Certificate in Microsoft Excel”

Your email address will not be published.

Scroll to Top