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)



