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)
TEST4U Desktop version
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 Office 2024, Microsoft 365.
TEST4U Cloud version
This assessment can also be taken online, in the browser, with nothing to install. The TEST4U Cloud version tests the same skills. Online assessments are available in English and Greek.





