top of page

SPECIAL EDITIONS

  • Anyone Who is Little Familiar with Excel

  • Ideal for Reporting Analysts / Data Analysts

  • MIS Specialists / Dashboard Developers

  • Aspring Big Data Analysts

  • Employees working with Small / Medium size Data

1. Pivot Table  - Before a Pivot

​

  • Data Cleansing Techniques

  • Pivot Rules

  • Preparing Data For Pivot

  • Differentiate Structured And Unstrutured Data

  • Data Inspection Techniques

  • List Of Major Do'S And Don'Ts

 

 

2. Pivot Table Fundamentals

​

  • Pivot Table Anatomy & Configuration

  • Famous 5 Areas

  • - Values Area

  • - Row Area

  • - Column Area

  • - Filters Area

  • - Fields Area

  • Understand Behind The Scene

​

​

3. My First Pivot Table

​

  • Use Recommended Pivot Tables

  • Selection Of Data

  • Working With Tables

  • Adding Fields

  • Using Different Areas Of Pivot

  • Modifying Data Selection

  • Moving A Pivot Table

 

 

4. Exploring Design Tab

​

  • Understand Standard Vs Contextual Tabs

  • Playing With Layout Areas

  • Different View Of Totals / Sub Totals

  • Use Different Type Of Layout

  • Apply Different Styles To A Pivot

 

 

5. Exploring Analyze Tab

​

  • Naming A Pivot Table

  • Auto Refresh A Pivot

  • Changing Data Source

  • Insert A Slicer

  • Insert A Timeline

 

 

6. Pivot Perfect - Part I

​

  • Exploring Value Settings

  • Learn To Use 11 Types Of Arithmetic Settings

  •       - % Of Total

  •       - Rank

  •       - Running Total

  • Slice And Dice Pivot Data

  •       - Understanding Excel Grouping Logic

  •       - Grouping Data - Standard And Custom

  •       - Customizing Slicers

  • Using Pivot Filter Effectively

​

 

7. Pivot Perfect - Part II

​

  • Working With Pivot Table Components

  • Creating And Using A Calculated Field

  • Creating And Using A Calculated Item

  • Working With Calculated Items

  • Show And Hide Details

  •   View Detail For Value Items

  •   View Detail For Field Items

  • Working With Dates Inside Pivot

  • Applying Conditional Formatting On Pivots

  • Decode Getpivotdata

 

 

8. Pivot Perfect - Part III ( Pivot Chart )

​

  • Understanding Pivot Charts

  • Creating Pivot Charts

  •              - Create Chart From Existing Table

  •              - Create Chart From Scratch

  • Understanding Pivot Chart Layout And Elements

  • Changing Pivot Chart Types

  • Maniupulate Pivot Filter Pane

 

 

10. Wrap Up Session

​

  • Best Practices

  • Importatnt Tips And Tricks

  • Extremely Useful Keystrokes

  • Review Of Topics Discussed

  • Planning For Free Future Follow Up Session

bottom of page