Excel

Course Type: Experiential

This lab-driven course begins with Excel fundamentals focused on formatting, sorting, and data types. Participants work with sample raw data to be transformed into a desired summary report. Pivot Tables and Charts from basic to advanced are covered through a series of custom exercises. In addition, participants work with output from a query, determining best approaches to parse the file in Excel, incorporating various techniques, and culminating in a summary report.

Objectives

  • To gain or strengthen a fundamental skill set in Excel

  • To work with various data types in Excel to perform efficient calculations

  • To gain experience creating reports that incorporate calculations

Content

  • Data Entry and Management (Sorting and Filtering)

  • Formulas and Functions (SUM, AVG, COUNT)

  • Data Analysis (VLOOKUP and HLOOKUP)

  • Charts and Graphs (Bar and Pie)

  • Pivot Tables