The goal of this Microsoft Office 2016 Excel Intermediate is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates. You’ll also discover how to use Goal Seek and Solver and apply them to real-world problems. The course provides you the guidance of how to create a proper database, organizing your data such that it can be used to work with multiple worksheets.

Learning Outcomes:

• Calculate with advanced formulas
• Audit formulas using the auditing tools
• Work with Excel tables
• Organise worksheet data so that data can be sorted and filtered
• Create and modify Charts
• Create Excel templates

Method of Assessment:

Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).

Certification:

Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.