Summarize and organize raw data in a way that can be meaningfully presented to others. Gain a solid understanding of Pivot Tables to maximize effectiveness when analyzing data. Use Power Pivot along with Excel to analyze data from a variety of sources. To ensure success in this course, you should have experience working with Excel and PivotTables, understand spreadsheet concepts, and be comfortable creating basic PivotTables.
- Lesson 1: Preparing Data and Creating PivotTables
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Source
- Lesson 2: Analyzing Data by Using PivotTables
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
- Lesson 3: Working with PivotCharts
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
- Prepare data for PivotTable reporting and create PivotTables from various data sources.
- Analyze data by using PivotTables.
- Work with PivotCharts.
Applies Towards the Following Digital Badges
- Microsoft Excel 2019 Digital Badge : Microsoft Excel 2019
Make every day count. Discover your passions. Advance your career. Play and learn.
I started a new job as a graphic and web designer and the digital badge I got was part of the reason they chose to hire me. I couldn't have done it without you!
David is a truly amazing teacher who makes learning the harmonica lots of fun. His enthusiasm is contagious and he has a heart of gold.
The Writing Salon was so much more than a writing class. The experience was energetic, enthusiastic and supportive. I highly recommend this class for anyone who wants to develop their skills as a writer!
As always, your Spanish classes are packed with new information about the language. You make it easy to learn Spanish and keep it very interesting. Thank you!
I have participated in many LLI classes over the past two years. Gary is a terrific discussion facilitator and brings excellent background knowledge to our classes. I'm learning so much about Foreign Policy.
Just want to let you know how much I enjoyed your class. Hope you will have more classes since I am a novice in the wine area and am anxious to learn.