Learn Excel Pivot Tables in 2 Hours with Dr. John Miko
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
- Familiarity with basic Excel and computer skills
- No experience with Pivot Tables needed.
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.
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
John S. Miko holds degrees in Mathematics, Computer Science, and Business Administration and earned a doctoral degree in Organizational Leadership with an IT specialization from Nova Southeastern University. John has taught at a 4-year private university since 2002 where he has offered courses in Analytics and MIS. He has has won several teaching awards and was named a Sam Walton Free Enterprise Fellow. Prior to his teaching career, John was employed for 10 years in the field of Information Technology primarily in the arena of Financial Services. His previous position prior to his faculty appointment was Vice-President, Information Technology at M&T Bank. He is married with five children and in his leisure time enjoys reading, surfing the Internet, and playing, coaching, and watching sports of any kind.