Microsoft Excel Intermediate (2016)

Course overview

Excel is one of the most widely used data processing and spreadsheet applications and a staple in many businesses. The Excel Intermediate course focuses on more advanced formulas and application, and is designed for intermediate users who would like to expand on their basic knowledge of Excel.

Outcomes

• Sort data using single- and multi-level sorting.
• Apply built-in functions to perform calculations and return information about data lists.
• Apply data validation and create validation lists.
• Import and export data from and to text files.
• Apply PivotTables to Excel worksheets.
• Apply the Power Query tool to model and shape data.
• Apply various tools to work with large sets of data.

Lessons

• 

  Working with lists

• 

  List functions

• 

  Data Validation

• 

  Importing and exporting data

• 

  PivotTables

• 

  Power Query

• 

  Working with large sets of data