Excel 2016 Basic

What does this course offer you?

In this training course, you will learn Excel from the ground up. You will first become familiar with the structure of Excel, in other words workbooks (i.e. files), worksheets, tables, columns, rows and cells. You will see how to fill these elements with data and how to edit and format them. Next, you will learn about formulas and functions that you can use to perform calculations in individual cells and about charts with which you can visualize your content. Finally, you will learn how Excel supports you in performing quality checks and when printing your tables.

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?
  • learning videos
  • audio narration with closed-captioning
  • practice exercises
  • tips and printable PDF's
  • tests and a personalized learning path

Sections: 25
Number of Nuggets: 129
Learning Time: 425 Minutes