Microsoft Excel Advanced

Current Status
Not Enrolled
Get Started
This course is currently closed

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:

  1. Creating more complex formulas                                                      
  2. Relative and absolute cell references                       
  3. Functions                                                                                
  4. Freeze panes and view options                      
  5. Sorting data                                                   
  6. Filtering data                                                  
  7. Groups and subtotals                         
  8. Tables                                                 
  9. Charts                                                             
  10. Conditional formatting                      
  11. Comments and co-authoring                         
  12. Inspecting and protecting workbooks                       
  13. Intro to pivot tables                                       
  14. Doing more with pivot tables                                    
  15. 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.

Course Content

Expand All
Lesson Content
0% Complete 0/1 Steps
Lesson Content
0% Complete 0/1 Steps