Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 32 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students, Office Newb
Rating
Course Overview
Quickly calculate, summarize and analyze large data sets with Microsoft Excel Pivot Tables
WHY EXCEL PIVOT TABLES
Mastering Microsoft Excel PivotTables will change the way you approach reporting. Through a few clicks of the mouse Excel PivotTables allow you to quickly and efficiently summarize large data sets.
COURSE DESIGNED TO HELP YOU SUCCEED
This Microsoft Excel PivotTables - Beginner to Advanced course will take your skills from absolute PivotTable beginner to Advanced PivotTable user. Each section of the course has been designed to focus on a specific skill set. Once that skill set is mastered, then you will move to the next section that builds upon the previous skill set. After completing the first few sections of the course you will feel like you can conquer the world with the reports you can create, but there's more.
Each section contains instructor lead lectures with step-by-step instruction and encouragement to try the various topics for yourself, using the course provided exercise files. Each section also contains mini challenges where you can practice the skill you are mastering with additional exercises and quizzes on the topics.
WHAT YOU'LL LEARN
Create dynamic reports that will help with making intelligent business decisions
Capture data from a single source or from multiple related sources
Apply proper list design techniques to make reporting a breeze
Summarize data with built in Excel functions and custom calculations
Format your report for clear presentation
JOIN ME
Enroll now and learn to harness the power of Microsoft Excel PivotTables.
Course Content
- 10 section(s)
- 59 lecture(s)
- Section 1 Microsoft Excel PivotTables - Beginner to Advanced Course Introduction
- Section 2 Introduction to Excel PivotTables
- Section 3 Preparing Microsoft Excel Worksheet Data
- Section 4 Microsoft Excel PivotTables Summary Values and Calculations
- Section 5 Grouping Excel PivotTable Data
- Section 6 Sorting and Filtering Excel PivotTable Data
- Section 7 Formatting Excel PivotTables
- Section 8 Excel Pivot Charts
- Section 9 Introduction to Microsoft Excel Power Query
- Section 10 Congratulations
What You’ll Learn
- Prepare Microsoft Excel data for PivotTable reporting
- Connect PivotTables to various data sources
- Create and manage PivotTable calculations
- Format PivotTables for presentations
- Update PivotTable source data
- Create and manage Excel Data Models to pull in data from multiple sources
- Create and manage data relationships
- Create Dashboard elements in a PivotTable
Skills covered in this course
Reviews
-
YYana Epstein
I'm already taking Kyle's third course. It's a wonderful, practical course, the material is presented beautifully, and the English is very clear, which is important if English isn't your native language.
-
SSarvesh Singh
I like all small details are being covered in this course, as they seem easy to fix but in reality they cause headache if you don't know at first place. The course is really good if you want to master the Pivot Tables.
-
AAngeline Huang
Trainer could give more details behind the WHY rather than just showing the functions of what it does.
-
TTomi Wessel
So far, I like his teaching style. He talks slow and encourages questions or reminds you to rewind and watch it over. He has a bubbly personality and is very likeable. I really enjoy this instructor.
