Learn Excel Pivot Tables in 2 Hours with Dr. John Miko

Genre: eLearning | Language: English + Sub
Creating Excel Pivot Tables: It's not splitting the atom
What you'll learn
Excel Pivot Table Basics
Filtering, Sorting, Grouping, and Pivoting
Using Slicers and Timelines
Working with Date fields
Building a Data Dashboard
Requirements
Familiarity with basic Excel and computer skills
No experience with Pivot Tables needed.
Description
Excel Pivot Tables are an incredibly powerful feature of Excel that allows users to glean insights and understanding quickly from massive data files. While Pivot Tables are often thought of as an advanced feature of Excel because of the "Wow Factor", they are really not that difficult at all when broken down into their features and functions as done in this course. In 19 lectures, in under 2 hours, this course steps student through the most useful and powerful aspects of Excel Pivot Tables.
Course Sections
Section 1: INTRODUCTION AND WELCOME TO THE COURSE
Section 2: EXCEL PIVOT TABLE BASICS and MAKING YOUR FIRST PIVOT TABLE
Section 3: OVERALL TABLE DESIGN
Section 4: FIELD SETTINGS AND DESCRIPTIVE MEASURES
Section 5: SORTING, FILTERING, AND REFRESHING
Section 6: GROUPING ITEMS, DATE FIELDS, AND CALCULATED FIELDS
Section 7: PIVOT CHARTS AND BUILDING A DASHBOARD
Who this course is for:
Beginner Excel users hoping to leverage the power of Pivot Tables