About this course
Course duration approximately 2.5 hours
This course teaches candidates the advanced subjects of Microsoft Excel.
Completion of the videos and quizzes and the issuance of a certificate will demonstrate to your current or potential employer that you have a solid understanding of advanced topics of Microsoft Excel.
The course consists of viewing short videos followed by a short quiz on the following subjects:
- Creating more complex formulas
- Relative and absolute cell references
- Functions
- Freeze panes and view options
- Sorting data
- Filtering data
- Groups and subtotals
- Tables
- Charts
- Conditional formatting
- Comments and co-authoring
- Inspecting and protecting workbooks
- Intro to pivot tables
- Doing more with pivot tables
- What if analysis
Upon completion, a certificate and summary of the topics covered will be issued in your name.
Course instructions
You are required to view each video twice before attempting the quiz. You can only move on to the next video upon successful completion of the accompanying quiz. The pass mark is 100% – don’t worry, questions are designed to ensure you understood the video content, we are not trying to catch you out! In case you do not pass the quiz the first time, you can re-watch the video and take the quiz again. Once its passed, you can move on to the next module.
While watching each video, pay close attention and concentrate on the content. Do not let any distractions reduce your concentration level. Quiz questions will be relatively easy to answer if you have paid complete attention but difficult if you have not.
You can complete this course in sections by logging out when you need a break. You can continue where you left off by logging in again. There is no time limit for completion.
Once completed a copy of the certificate will automatically be sent to the email address you used to register. Alternatively, you can download a copy immediately at the end of the course.
