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 course 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.
Excel 2016 users
Create and Modify Tables
Use Summary Functions in Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting
Occupational Skills: Computer Skills