Complete Introduction To Excel Pivot Tables [2022 Edition]

Learn to analyze & summarize data in seconds using Excel's most powerful data feature - Pivot Tables & Pivot Charts!

What you'll learn
Enjoy CLEAR, CONCISE and LOGICAL step by step instructions from a best selling Excel and Power BI Udemy Instructor
LIFETIME access to course materials and practice activities with a 100% MONEY-BACK guarantee
Learn to use the most POWERFUL tool in Microsoft Excel to easily summarize and create reports from your data
In SECONDS create aggregated and summarized tables of data from VAST quantities of spreadsheet data
At the click of a mouse, create percentages, running totals, difference from and ranking calculations with no formulas!
Learn to use filters and slicers to display INTERACTIVE views of data with no complex coding or VBA
Get COMPREHENSIVE understanding of trends within data with a few clicks of the mouse
Learn to ANALYZE Human Resource data using grouping and frequency analysis
Requirements
Excel 2016 or above
You should be able to work with data in Excel and do basic reporting
Description
Looking for a course that will get you up and running with Excel Pivot Tables without wasting your time?  Looking for a course that makes sense and builds your knowledge up in a logical fashion?  That's exactly what this course delivers.  Get the crucial foundation you need to become a Pivot Table expert.  This course has been updated for 2022 in full HD video quality, so you will learn on the latest Excel interface. WHAT STUDENTS ARE SAYING:"Excellent course, goes over all the options available for working with big sets of data. Being familiar with pivot tables is a must in order to really grasp the formulas required to make this powerful feature a tool .""Great course, great teacher…It was above expectations. I really like those little notes how we can do same thing on different ways. Recommend it strongly.""I just passed my Excel 70-779 test to complete my BI Solutions MCSA . Thank you Ian…watched all your videos on here for both tests.""Super great course! Gave me all the basics to get started using Power Pivot right away!"**** Life time access to course materials and practice activities. ****ABOUT THE TRAINERIan Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.Ian has over 150,000 students and with an average course rating of over 4.5. He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time.ABOUT THE COURSESkills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.In this course you will learn the INCREDIBLE power of Pivot Tables to analyze and summarize data in seconds.  Pivot Tables are without doubt the most powerful feature in Microsoft Excel.  In this class you will cover:Introduction and Course ContentCreating Pivot TablesMethods of Aggregation and GroupingTrend AnalysisFiltering and Slicing Pivot TablesShow Value As CalculationsFrequency AnalysisConditional FormattingInteractive DashboardsExcel and Power BIWe look forward to having you on our course as we learn and explore the incredible power of Excel Pivot Tables and Pivot Charts.Please note that this course is the third course in a series of three courses for the Excel Master Class series.  Search for my instructor profile to purchase these other courses.Course 1 - Power Query - Prepare and Transform DataCourse 2 - Power Pivot - Data Modeling and DAX FormulasCourse 3 - Pivot Tables and Pivot Charts

Overview

Section 1: Introduction

Lecture 1 Introduction to the Course

Lecture 2 About the Course

Lecture 3 Download the course data files

Lecture 4 Correctly Setup Data

Section 2: Create Pivot Tables

Lecture 5 Introduction to Pivot Tables

Lecture 6 Creating Pivot Tables

Lecture 7 Working with Multiple Dimensions

Lecture 8 Working with Multiple Measures

Lecture 9 Practical Activity - Pivot Tables

Lecture 10 Complete Practical Activities - Pivot Tables

Section 3: Methods of Aggregation and Grouping

Lecture 11 Introduction to Methods of Aggregation and Grouping

Lecture 12 Methods of Aggregation

Lecture 13 Combining Methods of Aggregation

Lecture 14 Grouping Data

Lecture 15 Formatting Pivot Tables

Lecture 16 Comparison Graphs

Lecture 17 Practical Activity - Methods of Aggregation

Lecture 18 Practical Activity Completed - Methods of Aggregation

Section 4: Trend and Date Analysis

Lecture 19 Introduction to Trend Analysis

Lecture 20 Grouping Date Fields for Trend Analysis

Lecture 21 Creating Fields for Trend Analysis

Lecture 22 Creating Fields for Trend Analysis Part 2

Lecture 23 Trend Charts

Lecture 24 Practical Activity - Trend Analysis

Lecture 25 Completed Practical Activity - Trend Analysis

Section 5: Filtering and Top 10 Analysis

Lecture 26 Introduction to Filtering and Top 10 Analysis

Lecture 27 Filtering Pivot Tables

Lecture 28 Top 10 Analysis

Lecture 29 Report Filters

Lecture 30 Using Slicers to Filter Data

Lecture 31 Using Slicers to Filter Multiple Pivot Tables

Lecture 32 Practical Activity Filtering

Lecture 33 Completed Activity Filtering

Section 6: Analyzing Data and Calculations

Lecture 34 Introduction to Analyzing Data and Calculations

Lecture 35 Contribution Analysis

Lecture 36 Contribution Analysis Part 2

Lecture 37 Pie Charts and Contribution Analysis

Lecture 38 Difference From and Running Total Calculations

Lecture 39 Practical Activity - Contribution Analysis

Lecture 40 Completed Practical Activity - Analyzing Data

Section 7: Frequency Analysis

Lecture 41 Introduction to Frequency Analysis

Lecture 42 Download the Training Data File

Lecture 43 Frequency Analysis

Lecture 44 Frequency Analysis and Charts

Lecture 45 Practical Activity - Frequency Analysis

Lecture 46 Practical Activity Completed - Frequency Analysis

Section 8: Conditional Fomatting

Lecture 47 Introduction to Conditional Formatting

Lecture 48 Conditional Formatting using Rules

Lecture 49 Conditional Formatting using Top 10 Analysis

Lecture 50 Conditional Formatting using Icons, Data Bars and Colour Scales

Lecture 51 Practical Activity - Conditional Formatting

Lecture 52 Completed Practical Activity - Conditional Formatting

Section 9: Interactive Dashboards

Lecture 53 Introduction to Interactive Dashboards

Lecture 54 Practical Activity - Human Resource Dashboard

Lecture 55 Interactive Human Resource Dashboard Part 1

Lecture 56 Interactive Human Resource Dashboard Part 2

Lecture 57 Practical Activity Finance Dashboard

Lecture 58 Interactive Finance Dashboard

Lecture 59 Interactive Finance Dashboard Part 2

Section 10: Course Conclusion

Lecture 60 Course Conclusion

Excel users who want to learn how to create professional reports,Excel users who want to summarize and aggregate data,Excel users who want to learn new methods and techniques to analyze data