Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Microsoft Excel
Questions?
...a Pivot Table / Pivot Chart?
...the goal of today's training?
Pivot Table
Pivot Chart
Create a Pivot Table
Format a Pivot Table
Analyze a Pivot Table
Create a Pivot Chart
What ingredients are needed?
Gathering/Entering Data in Excel to make data useful is priority!
Example for Today
WG - Direct Billing Team
WG - Direct Bill - Bank Drafts - September
ZNON8A1
1
WG - Direct Billing Team
WG - Direct Bill - Bank Drafts - September
YCXS44L
1
WG - Direct Billing Team
WG - Direct Bill - Bank Drafts - February
ZKEG7N6
1
Data must be structured with categories for the Pivot Table to know how to analyzed your data
Popular Data Categories
Once you have gathered and structured your data in Excel, now you can easily create your Pivot Table!
Buckle Up! It's Time To Learn!
https://scribehow.com/shared/How_To_Create_A_PivotTable__D2FTOxe9TKCAJK0c8rwSYg
How to select PivotTable Fields to pull-in relevant data
How to sort columns/rows/values within the PivotTable to make the data consumable
By selecting specific data points, your can focus on what is important to you within the larger data set.
Get Ready
To Create!
https://scribehow.com/shared/How_To_Create_A_PivotChart__jsGq2F5MSdyVSukoJndwQw