×
×

Excel 2016 Advanced

What does this course offer you?

This course provides advanced 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:

More functions of Excel

  • Inserting pictures
  • Data exchange with other Office applications
  • Excel files on Web storage locations

PivotTable and PivotChart

  • Creating and modifying a PivotTable
  • Creating and editing a PivotChart
  • Pivot: Analysis and settings

Advanced formulas and functions

  • References
  • New functions
What does this course include?

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