MICROSOFT EXCEL EXAM PREPARATION (MICROSOFT 365 APPS AND OFFICE 2019)
This online short course in Microsoft Excel (Microsoft 365 Apps and Office 2019) will give you competency at an industry associate-level and ensure you are ready to enter into the job market. It will also test your ability to apply your knowledge and skills prior to entering the testing environment. Its aim is to adequately prepare you for taking the certification exam.
The purpose of this course is to introduce you to the correct application of the principal features of Excel and covers the following topics:
- Manage Worksheets and Workbooks
- Manage Data Cells and Ranges
- Manage Tables and Table Data
- Perform Operations by using Formulas and Functions
- Manage Charts
As you work through your course material in your own free time, you can pace your studies and determine how quickly you want to progress. As a standard measure, you will have access to the online student portal for a period of 12 months from your date of registration.
COURSE START DATES:
You can start studying this course at any time of the year — there are no specific registration dates! Once you have completed your registration, you will receive your login credentials with 3-5 business days and can start your studies.
This online short course consists of five modules. The course objectives are:
Manage Worksheets and Workbooks
- Import data into workbooks
- Navigate within workbooks
- Format worksheets and workbooks
- Customise options and views
- Configure content for collaboration
Manage Data Cells and Ranges
- Manipulate data in worksheets
- Format cells and ranges
- Define and reference named ranges
- Summarise data visually
Manage Tables and Table Data
- Create and format tables
- Modify Tables
- Filter and sort table data
Perform Operations aby using Formulas and Functions
- Insert references
- Calculate and transform data
- Format and modify text
- Create charts
- Modify charts
- Format charts
Your knowledge and skills will be tested by means of online performance-based assessments and practice questions. These tools will help prepare you for the certification exam by testing your ability to apply your knowledge.
COURSE EXIT OUTCOMES:
Once you have completed this online short course you should be adequately prepared to take the Microsoft Excel (Microsoft 365 Apps and Office 2019) certification exam via Certiport.
This certification forms part of the Microsoft Office Specialist Program.