Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Data Analysis using Excel Pivot Tables & Charts

Name: Microsoft Data Analysis using Excel Pivot Tables & Charts
Rating: 3.9 (12 reviews)

A Complete Guide to Microsoft Excel Pivot Tables & Charts in just 5 Hours. Most Powerful, Compact& Useful course.

Created byTrulabz Technologies

Last updated 11/2022

English

English [Auto],

What you'll learn

Learn data analysis skills from ZERO to HERO using Excel Pivot Tables and charts.
How to streamline your data analysis workflow in Excel
How to create amazing looking dashboards using Pivot Tables
Advanced Sorting and Filtering in PivotTables
Quick Pivot Table Tricks
Data based CASE STUDIES using Pivot Table

Course content

11 sections • 54 lectures • 5h 21m total length

Introduction2:43

What is Pivot Table & Why we use Pivot Tables?4:38
Pivot Interface tour - Know Your Pivot Table Better5:34
Explore the Excel pivot table interface, understanding fields, filters, rows, columns, and values. Learn how to customize layouts and use product category and age group filters to analyze sales data.
Creating your First Pivot Table, a Quick Shortcut to Pivot & Name your Pivot4:59
Navigating the Pivot Table Field List7:51
Explore Analyze and Design Tab3:40
Quick way to Update & Refreshing the Pivot Tables3:30
Selecting, Clearing, Moving & Copying Pivot Tables5:54

Changing Number Formats in Pivot Tables4:43
Explore how to apply and compare number formats in pivot tables, switching between currency, accounting, and date formats using format cells and value field settings.
Configuring Pivot Tables Layout and Styles Options7:40
Configure pivot tables by adjusting layout options—subtotals, grand totals, report layout, and blank rows—and apply style settings for row headers, column headers, banded rows and columns, and color themes.
Customizing Pivot Table Headers & Labels7:56
Applying Basic Conditional Formats to Pivot Tables6:49
Applying Advanced Conditional Formats to Pivot Tables & Formula Based Formatting6:16
Explore advanced conditional formatting in pivot tables, using rule-based and formula-based techniques to highlight values, manage grand totals, and apply dynamic formatting with new rules.

Summarizing Data By: Using in Pivot Tables6:00
Explore calculated value fields in pivot tables, using the summarize by value option to compute count, average, maximum, and more, with practical steps on setting revenue fields.
Show Value As: Calculations Options with Pivot Tables3:48
Explore how the summarize value as option in pivot tables recalculates data as percentage of parent row total, revealing the parent-child relationship and how child contributions differ from grand totals.
Summarize Value as: Difference From and %Difference From4:12
Summarize Value as: Running Total and % Running Total3:58
Calculating Pivot Table Values: Rank & Index7:34
Creating Powerful Calculated Fields in Pivot Tables6:14
Create custom calculated fields in pivot tables to derive a profit percentage from revenue and cost without altering raw data.
Inserting Pivot Table Calculated Items6:27
Generating Solve Order & List Formulas Reports9:21
Explore the solver in pivot tables by creating calculated fields and items, adjusting the solve order (including salt water), and generating a comprehensive list of formulas to document all calculations.

What are Report Filter pages - An Overview2:18
Discover how report filter pages save time by generating multiple monthly reports from a single pivot table in seconds, using the analyze tab and show report filter pages.
Using Report Filters to narrow down results in a PivotTable.2:24
Place month in the report filter pages to generate twelve month-specific pivot tables and worksheets from January to December, saving time.

Trick 1 & 2 - No More Cell Ranges - Create Pivot Table from Normal Table4:15
Trick 3 - Delete Source Data3:21
Trick 4 - Show values with no data - field setting on cell4:15
Trick 5 - Multiple Filters in Pivot Table3:24
Trick 6 - Turn Off Generate GETPIVOTDATA1:29
Trick 7 - Multiple Subtotals4:01
Learn to apply multiple subtotals in a pivot table by using design options to display sum, count, average, max, and min for product category and subcategory, enabling detailed subtotal analysis.
Trick 8 - Refresh Data and When opening a new file2:20
Trick 9 - Losing your Field List1:55
Learn to recover a hidden pivot table field list in Excel by using the Analyze ribbon, Show options, and toggling fields to restore fields in your pivot table.
Trick 10 - Changing the default locations2:01

Requirements

Basic Excel knowledge
Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)

Description

In this Microsoft Excel - Data Analysis using PivotTables & Charts Course, we teach you how to make the most of this raw data and convert it back to powerful reports and dynamic excel dashboards.

PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel.

Pivot Tables allow you to quickly explore and analyze your raw data in Excel depicting powerful information help you and your company to scale your business taking wise business decisions.

With the use of pivot tables in Excel (one of my personal favourites) you can skilfully summarize data from a worksheet into an illustrative chart.

This Business Data Analysis using Pivot Table Excel course will provide you with an in-depth understanding of:

Excel functions and pivot tables, pivot charting, and pivot reporting, to group, slice, calculate and summarize large syndicated datasets in order to answer specific questions
Sorting, filtering and grouping tools in Excel.
Pivot Table Grouping (text, number, dates).
Charting, graphing, and illustrating data trends in Excel, amongst others!
We will also take you to the Excel Pivot Table Tricks and Latest Excel Pivot Hacks used now a days.
Pivot Table Options – A way to make your pivot table more powerful.
Conditional Formatting in Pivot Table – a good way to visualize strong datasets.
GETPIVOTTABLE Formula adds flexibility to your pivots.
Exploring power of "Report Filter Pages".

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
Creating your very First Pivot Table.
Pivot Table layouts & styles
Design & formatting options
Sorting, filtering, & Grouping tools
Calculated fields, items & values
Exploring power of "Report Filter Pages"
Pivot Charts, Slicers & Timelines
Interactive Dynamic Excel dashboards

**********************************************

<<<<Real Time Excel Data which is used in the industry.>>>

Practice Files, Assignments and Case- Studies
E-Book guide to assist while watching the videos

Who this course is for:

ANYONE & EVERYONE who works with Microsoft Excel on a regular basis (even if you've never used a Pivot Table!)
People work with Lots of Data and use pivot as their prime tool for analysis.
Aspiring Data Analysts, Managers, or employees that anticipate using MORE data in the future
ANYONE who wants to learn how to cut hours off of their weekly reporting tasks
ANYONE who is looking to pursue a career in Data Analysis

Microsoft Data Analysis using Excel Pivot Tables & Charts

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Section 1 - Dive into Excel Pivot Tables Straight away7 lectures • 36min

Section 2 - Pivot Table Formatting & Advance Conditional Formatting5 lectures • 33min

Section 3 - Untold Sorting, Filtering & Grouping Techniques in Pivot Data6 lectures • 41min

Section 4 - Value Field Settings & Calculated Fields8 lectures • 48min

Section 5 - The Power of Pivot Table Options3 lectures • 22min

Section 6 - Know the Power of Report Filter Pages (No Overtime Now)2 lectures • 5min

Section 7- Application of GETPIVOTDATA Function3 lectures • 21min

Pivot Charts and Dashboards5 lectures • 34min

Section 9- Pivot Tables Hacks and Tricks9 lectures • 27min

Requirements

Description

Who this course is for: