Assessment: Excel Advanced
When the need to use Excel within an organization is increased, the evaluation of candidates’ skills is imperative to ensure the existence of these necessary skills.
Candidates who successfully complete this assessment have the ability to create and handle spreadsheets of high requirements and specifications.
In practice, successful candidates should be able to take advantage of Excel’s advanced capabilities to complete the analysis they desire.
To successfully complete the evaluation, candidates must demonstrate the necessary skills for data analysis as well as for their presentation.
- Manage Worksheets and Workbooks
(Sheet headers, sheet movement, manage rows and columns, manage sheet views and printings) - Manage Data Cells and Ranges
(Formatting and conditional formatting, cell naming, find and replace) - Tables – Sorting and Filtering
- Formulas and Functions
(SUM, AVERAGE, COUNT, MIN, MAX, IF, AVERAGEIFS, VLOOKUP) - Charts and Pivot Tables
(Pivot tables and charts, Create, delete, and modify 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.