MS Excel 2019 - Data Analysis With Pivot Tables and Charts
4.2 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
136 students enrolled

MS Excel 2019 - Data Analysis With Pivot Tables and Charts

Mastering in Excel Pivot Tables & Data Analysis with Real time Scenarios by Microsoft Certified Trainer (Excel 2019)
4.2 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
136 students enrolled
Last updated 5/2020
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5 hours on-demand video
  • 3 articles
  • 4 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Complete Analysis with Pivot Tables
  • Excel 2019 Pivot tables and Pivot Charts
  • How to Write formulas in Pivot Tables
  • Data Analysis With Excel Pivot Chart
  • Introduction of VLOOKUP and HLOOKUP Functions
  • Create Pivot Table With Multiple Sheets
Requirements
  • Basic Knowledge of Excel
  • Access to Microsoft Excel version 2010 or newer
Description

In the Udemy this is the Best Excel Course for Pivot Tables & Pivot Charts Created by Microsoft Certified Trainer.


FULL COURSE DESCRIPTION:

Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends. In other words, they give you answers. Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates. Excel Pivot Tables provide fast, accurate and intuitive solutions to even the most complicated analytics questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering, & grouping tools

  • Calculated fields, items & values

  • Pivot Charts, slicers & timelines

  • Interactive Excel dashboards

  • Writing formulas in Excel

NOTE: Full course includes downloadable resources and Excel project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365.


What you’ll learn in this Course?

  • Take your data analysis skills from ZERO to PRO with Excel Pivot Tables

  • Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel

  • Master unique Pivot Table tips, tools and case studies that you won't find in ANY other course, guaranteed

  • Best Pivot table Course by Certified Trainer

  • Get LIFETIME access to project files, quizzes, homework exercises

  • Test your skills with multiple Examples

Are there any course requirements or prerequisites?

  • Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365

  • Basic experience with Excel functionality (charts & formulas a plus!)

Who this course is for:

  • ANYONE who works with Excel on a regular basis (even if you've never used a Pivot Table!)

  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis

  • Students looking for a comprehensive, engaging, and highly interactive approach to training

  • Anyone looking to pursue a career in data analysis or business intelligence

Who this course is for:
  • Data analysis and reporting professionals who work with Excel
  • Students who want to improve their skill set for MNC's
  • Excel knowledge workers looking to advance their skillset
  • Excel spreadsheet creators, maintainers, or users.
  • Anyone looking to pursue a career in data analysis or business intelligence
Course content
Expand all 67 lectures 05:12:14
+ Starting with MS Excel Pivot Table
10 lectures 41:24
How to Structure Source data for Analysis in Excel
02:08
Creating Your First Excel Pivot Table
04:52
Navigating the Pivot Table Field List
04:11
Exploring Analyze & Design Tabs Options
02:02
Selecting, Clearing, Moving & Copying Pivot Tables
05:07
Refreshing & Updating Excel Pivot Tables
06:00
Dealing with Dynamic Source Data in Pivots
05:00
Removing & Reviving Data from Pivot Table Cache
03:32
How Excel Pivot Tables Actually Works?
03:22
Excel Pivot Table
5 questions
+ Formatting Data with Excel Pivot Tables
10 lectures 32:41
Changing the Excel Pivot Table Number Formats
02:43
Formatting Empty Pivot Table Cells
02:11
Configuring Excel Pivot Table Layouts & Styles
04:39
Excel Pivot Table Tabular Form
01:35
How to Create Custom Pivot Table Styles
03:42
Customizing Pivot table Headers and Labels
01:44
Applying Conditional formatting to Pivot Tables
05:20
Adding Data Bars with Invisible Text in Pivot tables
02:13
Applying Advanced Conditional Formatting to Pivot Tables
06:05
Creating Pivot Table Using External Data Source
02:29
+ Sorting, Filtering & Grouping Data With Pivot Tables
9 lectures 37:56
Sorting Data With Excel Pivot Tables
04:14
Fixing Incorrect Alphabetical Sorting in Pivot Tables
02:06
Filtering data with pivot tables Labels and Values
03:18
Excel Pivot table Label filter with WILDCARDS
04:23
Enabling Multiple Pivot table Filters
03:26
Grouping Data in the Pivot Tables
02:56
Enabling & Disabling Automatic Date Grouping
02:46
Filtering Data With PIVOT TABLE Slicers and Timelines
11:46
Pivot table Report Filter Pages
03:01

In this section we are asking Questions about Filter and sorting and Grouping also.

Pivot Table Quiz on Sorting, Filtering & Grouping
5 questions
+ Summarize Data with Pivot table Values
9 lectures 30:05
Aggregating & Summarizing Data with Pivot Tables
04:37
Avoiding Pivot table 'Count of' Trap
02:58
Defining Value Calculations with Pivot Table
02:36
Calculating Pivot table Values: % of Column or Row
03:32
Calculating Pivot Table Values : % of Parent
03:03
Calculating Pivot Table Values: Difference from
04:23
Calculating Pivot Table Values: Running Total in
02:27
Calculating Pivot Table Values: Rank
02:31
Calculating Pivot table Values: Index
03:58
+ Pivot Table Summarize Data With Calculated Fields
6 lectures 29:43
Recommended Pivot Tables and Sub Totals
02:40
Calculated Fields with Pivot Tables
03:38
Pivot table Calculations with Count Columns
07:36
Pivot Table Calculations using Count Columns - Part 2
04:30
Inserting Pivot Tables calculated Items
05:48
Generating Solve Order & List Formulas Reports
05:31
+ Microsoft Excel Analysis With Complete Pivot Tables
4 lectures 44:54
Complete Pivot Tables in Excel
25:06
Pivot Table Consolidation in Excel
04:35
Slicers and Timeline in Excel Pivot Tables
10:53
How to Write Formulas in Excel Pivot Tables
04:20
+ Visualizing & Analyzing Data with Excel Pivot Charts
11 lectures 01:00:45
Introduction to Excel Pivot Charts
04:03
Designing Column Charts in Pivot Table
05:21
Pie & Doughnut Charts in Pivot Table
07:16
Clustered Bar Charts in Pivot Table
03:30
Preventing Charts from Resizing with Cells
05:11
Changing Pivot Chart Types & Swapping
03:53
Stacked Area Chart in Pivot Table
05:04
Customizing Pivot Chart Layouts & Styles
04:46
Move Pivot Charts to New Excel worksheets & Other Places
02:35
Applying Slicers and Timelines to Multiple Pivot Charts
06:29
Building Dynamic Dashboards With Pivot Tables & Charts
12:37
+ MS-Excel 2019 VLOOKUP & HLOOKUP Functions
3 lectures 18:58
Excel 2019 Complete VLOOKUP Function
12:03
Excel 2019 Complete HLOOKUP Function
05:00
MS Excel 2019 Complete Shortcut Keys
01:55
+ Course Wrapping Up
2 lectures 01:58
Conclusion of the Course
01:36
More About the Author
00:22