Start analyzing data with Excel’s Pivot Tables, the most powerful data analysis tool.
Pivot Tables, This is an introductory course and gives the information you’ll need to start using Pivot Tables. By Pivot Tables You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.
If you’re somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.
You don’t have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course. This would be considered an intermediate Excel course and students should understand basic mathematical calculations.
What you’ll learn
- Use basic Pivot Tables in Excel.
- Create a Pivot Table.
- Analyze large sets of information.
- Summarize information in different ways using Pivot Tables.
- Use Excel more efficiently.
- Structure information more effectively.
Course main points
- Preparing Your Data
- Introduction to Preparing Your Data
- Formulas vs Pivot Tables.
- How to Fix Your Data
- Creating Pivot Tables
- Introduction to Creating Pivot Tables
- Creating a Pivot Tables with our Sample Data
- Using Multiple Fields to Analyze Your Data
- Formatting Values
- Losing Your Field List
- Summarizing Your Data
- Lock in Your Knowledge
- Section Introduction
- Pivot Table Basics Challenge
- Challenge Answers
- Practice Workbook
Who this course is for
- Students should be relatively comfortable using Excel
- Who understand basic mathematical calculations
- That work with lists of information will definitely benefit from this course
Requirements
- How to navigate the Excel ribbon (the menu options in Excel)
- Create basic formulas in Excel
- How to copy and paste information in Excel
rating:
4.5 ( 10,830 ratings) 104,682 students enrolled
| Author | Matt Jackman |
| Categories | Digital Analytics and SEO Professional |
| Instructor Rating | 4.5 |
| Reviews | 11,142 |
| Students | 105,384 |
| Courses | 2 |
