Excel 2016 Basic

What does this course offer you?

This course provides basic knowledge on using Microsoft Excel 2016. Individual functions are explained on the basis of Video Nuggets and usage reinforced through exercises. Prerequisite for the course is basic knowledge in using Microsoft Office.

The primary subject matter of this course:


  • Creating and managing new workbooks
  • Creating and editing worksheets
  • Edit cells
  • Editing columns and rows


  • Creating tables
  • Working with tables
  • Sorting tables
  • Filtering tables 1
  • Filtering tables 2


  • Styles and templates
  • Formatting numbers
  • Formatting cells
  • Conditional formatting
  • Formatting pages

Formulas and functions

  • Formula basics 1
  • Formula basics 2
  • Simple formulas
  • Simple functions


  • Create a chart
  • Editing a chart
  • Editing chart elements
  • Sparklines

Finishing touches

  • Reviewing and corrections
  • Preparing for printing
  • Printing
What does this course include?

In addition to the instructional content, practice exercises and test questions are also included.
Sections: 25
Number of Nuggets: 129
Learning Time: 5.5 Hours