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. 

 

Topics Covered

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

Duration:

0.3 hours

Code/regulation:

Best Practices

Frequency:

As Needed

Who Should Attend:

Excel 2016 Users