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)




