Microsoft Excel 2016 Level 2.3 Analyzing Data

  • E-Learning

The course examines the various facets of data organization using Excel, specifically formatting tables in a data set. The course demonstrates how to create and modify tables either from existing ranges or populating your own. The class also models how to use summary functions in tables and intermediate and advanced conditional formatting.

Use this course to gain a firmer grasp on some of the more advanced, yet highly applicable, Excel tasks and skills. The techniques demonstrated in this course make it easier to analyze your data. 

It is best to complete this course in one sitting, if you do need to stop the training midway, please enable cookies for our website and allow popups (turn off your popup blocker) so that you don't lose progress for the course.


Topics Covered

  • Create and Modify Tables
  • Use Summary Functions in Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting


0.3 hours


Best Practices


As Needed

Who Should Attend:

Excel 2016 Users