Complete Introduction To Excel Pivot Tables [2022 Edition]
Last updated 7/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.79 GB | Duration: 4h 11m
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
Download linkrapidgator.net:
https://rapidgator.net/file/7e77b451ab24993f819cef242e72114c/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part1.rar.html
https://rapidgator.net/file/87c0328cb58c736d974b800deb921417/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part2.rar.html
uploadgig.com:
https://uploadgig.com/file/download/2dad1cC95201F879/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part1.rar
https://uploadgig.com/file/download/81419bBfa4475c73/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part2.rar
nitroflare.com:
https://nitroflare.com/view/06C699D708BE1AD/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part1.rar
https://nitroflare.com/view/7391AD51D65565E/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part2.rar
1dl.net:
https://1dl.net/l8f5iinrg00b/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part1.rar.html
https://1dl.net/l6htrn7zo3dt/ometn.Complete.Introduction.To.Excel.Pivot.Tables.2022.Edition.part2.rar.html
Cantinho Satkeys
