Microsoft Excel Intermediate 2-Day Camp: Pivot Tables

This two-day course will teach learners how to create Microsoft Excel pivot tables in order to summarize and analyze larger amounts of data in different ways. We will use scientific and financial data set examples. 

I will share my screen so that students can see what I am doing in Excel. Students should use Excel on their laptop or computer in order to follow along and get hands-on experience during class. In order to benefit from this course, students only need a basic understand of Excel, like how to type in cells and select/highlight cells with their cursor/mouse.

Day 1: I will upload an Excel file to the classroom that can be downloaded. The file contains mock sales data for a food truck. We will use the file to subtotal and categorize the food truck's sales.  The file also contains average temperature data for cities throughout the world. The data will be shown in Fahrenheit and Celsius and inches and centimeters.  We will examine the data and create formulas/functions with Excel. We will then create a pivot table to easily summarize the data.

Day 2: I will upload another downloadable Excel file to the classroom. The file contains average salary information by industry.  We will examine the data, which will be on two separate work sheets. We will use functions to combine the data into one worksheet. We will use the combined worksheet to create a pivot sheet. We will use the pivot table to summarize and analyze the data.

Topics covered will include:
•	Pivot Tables
•	Conditional Formatting
•	Functions (SUM, AVERAGE, REPLACE, VLOOKUP)

In order to maximize class time for all students, please ensure your learner is signed into Excel before class begins. 
Students do not need much experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program. They should be able to type in an Excel cell and select it with their mouse or cursor.

This class can be, but does not have to be, taken after any of my "Microsoft for Beginner" one-time, multi-day, or Flex classes.

Troubleshooting during class:
Occasionally, learners may need additional help in completing a task in Excel. I am able to give students the ability to share their screen so that I can see exactly what they are looking at. This works very well, and I am able to talk learners through the task. (I will not be able to see a learner's screen if they are using Excel on a separate device than their Outschool class.) If the learner is still not able to complete the task, they are able to grant me remote access so that I can complete the task for them in Excel. This allows us to cover all material in the class. At the end of class, I will revisit the skipped step and further practice with the learner.