Assessment: Excel Basic
Excel is used by a wide range of professions for the analysis of numerical data, making the professionals who use it invaluable in today’s job market.
By successful completion of this assessment, the candidates demonstrate that they are competent in organizing and analyzing data using Excel.
In practice the successful candidates should be able to create professional looking financial statements and budgets with charts and enter and manipulate data in a workbook.
To pass this assessment, candidates need to have the skills required to create, format and manage workbooks, worksheets, cells, cells ranges and tables.
The assessment syllabus also covers standard formulas and functions and data visualization with the use of graphical elements and charts.
- 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, PROPER, UPPER, LOWER) - 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.