Microsoft Excel Expert

You can start studying this course at any time of the year as there are no specific registration dates!
Once you have completed your registration, you will receive your login credentials within 3-5 business days and can start your studies.

This online short course consists of four modules. The course objectives are:

• Manage Workbook Options and Settings
  • Manage workbooks
  • Prepare workbooks for collaboration
  • Use and configure language options
• Manage and Format Data
  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering
• Create Advanced Formulas and Macros
  • Perform logical operations in formulas
  • Look up data by using functions
  • Use advanced date and time functions
  • Perform data analysis
  • Troubleshoot formulas
  • Create and modify simple macros
• Manage Advanced Charts and Tables
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts

For each module you will be required to complete both a pre-assessment and a post-assessment to test your knowledge and competency.

Once you have completed this online short course you should be able to create, manage, and distribute professional spreadsheets for a variety of specialised purposes and situations.

You will receive a Certificate of Competence from Oxbridge Academy Online.