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
Section 1 - Dive into Excel Pivot Tables Straight away
Section 2 - Pivot Table Formatting & Advance Conditional Formatting
-
2What is Pivot Table & Why we use Pivot Tables?
-
3Pivot Interface tour - Know Your Pivot Table Better
-
4Creating your First Pivot Table, a Quick Shortcut to Pivot & Name your Pivot
-
5Navigating the Pivot Table Field List
-
6Explore Analyze and Design Tab
-
7Quick way to Update & Refreshing the Pivot Tables
-
8Selecting, Clearing, Moving & Copying Pivot Tables
Section 3 - Untold Sorting, Filtering & Grouping Techniques in Pivot Data
Section 4 - Value Field Settings & Calculated Fields
-
14Amazing Sorting Techniques to SORT Data in Pivot Tables
-
15Filtering Pivot Data using Manual & Label Filters
-
16Filtering Pivot Data using Value Filters
-
17Filtering Pivot Data using Date Filters
-
18Filtering Data with Pivot Table Slicers & Timelines
-
19Grouping by Weeks, Months, Quarters and Years
-
20Knowledge Hunt- Lets Know How Much You have Learned.
We will test your sorting, filtering and Grouping Skills that you have learnt during this section.
Section 5 - The Power of Pivot Table Options
-
21Summarizing Data By: Using in Pivot Tables
-
22Show Value As: Calculations Options with Pivot Tables
-
23Summarize Value as: Difference From and %Difference From
-
24Summarize Value as: Running Total and % Running Total
-
25Calculating Pivot Table Values: Rank & Index
-
26Creating Powerful Calculated Fields in Pivot Tables
-
27Inserting Pivot Table Calculated Items
-
28Generating Solve Order & List Formulas Reports
Section 6 - Know the Power of Report Filter Pages (No Overtime Now)
Section 7- Application of GETPIVOTDATA Function
Pivot Charts and Dashboards
Section 9- Pivot Tables Hacks and Tricks
Section 10- Case Studies
-
43Trick 1 & 2 - No More Cell Ranges - Create Pivot Table from Normal Table
-
44Trick 3 - Delete Source Data
-
45Trick 4 - Show values with no data - field setting on cell
-
46Trick 5 - Multiple Filters in Pivot Table
-
47Trick 6 - Turn Off Generate GETPIVOTDATA
-
48Trick 7 - Multiple Subtotals
-
49Trick 8 - Refresh Data and When opening a new file
-
50Trick 9 - Losing your Field List
-
51Trick 10 - Changing the default locations