Excel 2016 / 2019 Advanced

This course provides advanced knowledge on using Microsoft Excel 2019 and 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
  • Chapter test

PivotTable and PivotChart

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

Advanced formulas and functions

  • References
  • New functions
  • Chapter test

Final Test

  • 15 Questions
Excel Advanced E-Learning Course Features:
  • for Excel 2019 and Excel 2016
  • structured video tutorials
  • audio narration with closed-captioning
  • practice interactive exercises
  • tips and printable PDF's
  • pretest with personalized learning path
  • chapter tests
  • comprehensive final test with certificate
  • SCORM package delivery for LMS hosting
  • accessible online
  • Tin Can/xAPI compatible
  • available in different languages
This Excel Course Includes:

Sections: 8
Number of Nuggets: 45
Learning Time: 145 Minutes