Microsoft Office Excel 2016

30 Hours / 12 Months / Self-Paced

Course Overview:

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels.  

Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

This course includes:
  • Visual Demonstrations & Multimedia Presentations
  • Quizzes & Exam Simulators
  • Social Learning & Networking
  • Flash Cards & Educational Games
  • Enhanced Navigation and Controls

Course Outline:

Excel Beginner
  • 1.1 Tabs And Ribbons Part 1
  • 1.2 Tabs And Ribbons Part 2
  • 1.3 Cells Part 1
  • 1.4 Cells Part 2
  • 1.5 Cells Part 3
  • 1.6 Cells Part 4
  • 1.7 Calculations Part 1
  • 1.8 Calculations Part 2
  • 1.9 Calculations Part 3
  • 1.10 Printing Part 1
  • 1.11 Printing Part 2
Excel Intermediate
  • 1.1 Menus And Keyboard Shortcuts Part 1
  • 1.2 Menus And Keyboard Shortcuts Part 2
  • 1.3 Menus And Keyboard Shortcuts Part 3
  • 1.4 Tabs Part 1
  • 1.5 Tabs Part 2
  • 1.6 Formulas And Calculations Part 1
  • 1.7 Formulas And Calculations Part 2
  • 1.8 Formulas And Calculations Part 3
  • 1.9 Formulas And Calculations Part 4
  • 1.10 Importing Data Part 1
  • 1.11 Importing Data Part 2
  • 1.12 Invoices
Excel Advanced
  • 1.1 Advanced Invoice Part 1
  • 1.2 Advanced Invoice Part 2
  • 1.3 Advanced Invoice Part 3
  • 1.4 Advanced Invoice Part 4
  • 1.5 Number Crunching
  • 1.6 Creating A Pivot Table From Scratch
  • 1.7 Smaller Excel Components Part 1
  • 1.8 Smaller Excel Components Part 2
  • 1.9 Smaller Excel Components Part 3

All necessary materials are included.


System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.


**Outlines are subject to change, as courses and materials are updated.**