MICROSOFT EXCEL (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.
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 Lists
- Create 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
For each module you will be required to complete both a pre-assessment and a post-assessment to test your knowledge and competency.
COURSE EXIT OUTCOMES:
Once you have completed this online short course you should be able to create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, and create charts and objects.
You will receive a Certificate of Competence from Oxbridge Academy Online.