Skip to main content

Excel Advanced E-Learning Course

This course provides advanced knowledge on using Microsoft Excel for Office 2016 and Office 2019. Learners will become familiar with the fundamentals of how to work with various types of visual representation. This includes pictures and SmartArt as well as 3D maps for mapping data. They will also learn about analyzing data with PivotTables and PivotCharts, and gain knowledge on using some advanced formulas and functions in Excel.

Course Features
Content Version
Application Group
Level
Advanced
Learning Time
2 hours and 20 minutes
Number of Learning Videos
49
Languages Available
English
German
French
Spanish
Portuguese
Japanese
Chinese
Russian
Course Design
  • Videos with Audio Narration and Closed-Captions
  • Practice Interactive Exercises
  • Tips and Printable PDF's
  • Chapter Tests
  • Personalized Learning Recommendations
  • Comprehensive Final Test with Certificate
  • Compatible with Desktop and Mobile Devices
  • SCORM and xAPI Support for LMS Deployement
Course Topics

Inserting pictures

  • Inserting a picture
  • Inserting a SmartArt graphic
  • Inserting online pictures
  • Visualizing data with a 3D map
  • Inserting a screenshot
  • Visualizing data with People Graph
  • Changing the aspect ratio of a picture

Data exchange with other Office applications

  • Importing data
  • Exporting data
  • Importing data from Access
  • Sending a document by email

Excel files on Web storage locations

  • Brief Overview of the Excel Web App
  • Checking in and out via the Excel desktop app
  • Discard check out
  • Version management

Above is a sample of learning videos included in this topic.
A detailed list of all learning videos included in this course is available upon request.

Creating and modifying a PivotTable

Creating and editing a PivotChart

Pivot: Analysis and settings

References

New functions

This Course is Included in our Course Packages