Assessment: Excel Expert
Analyzing data and making decisions based on data is gaining ground in the industrial world, making professionals who know how to process data and extract information using Excel a perfect addition for any company in today’s job market.
By successful completion of this assessment, the candidates demonstrate that they are competent to create, manage and distribute professional spreadsheets.
In practice the successful candidates should be able to use the advanced features and capabilities of Excel in data handling.
To pass this assessment candidates need to have the skills required to perform both statistical and mathematical analyses of data, as well as validate and present their results.
The assessment syllabus also covers multi-axis charts, custom data formats and advanced formulas.
- Custom Data Formats and Layouts
(Formatting and conditional formatting, cell styles) - Advanced Formulas
(SUM, AVERAGE, MIN, MAX, COUNT, AND, IF, OR, VALUE, IFERROR, OFFSET, WORKDAY.INTL, DAYS, DATEDIF, NETWORKDAYS) - Statistical Analysis and Business Modelling
(Settings, scenarios, VLOOKUP, AVERAGEIFS, SLN, INDEX, MATCH, DAY MONTH, DATE) - Advanced Charts and Tables
(Pivot tables and charts, advanced filters, import data, advanced charts)
The assessment uses Microsoft Office 2019
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office:
Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.