Master Business Reporting with Pivot Tables & Charts - Excel

Master Excel Pivot Tables with your highly experienced trainer. Excel 2010, Excel 2013, Excel 2016,

Whether you are a Freelancer, a StartUp, an Established Business, or even if still working on a new Business Idea, Pivot Tables can do brilliant magic for you! Decision making will become so much easier and faster!

In this course, learn how to use Pivot Tables & Charts Super Effectively and create meaningful, actionable Reports for your Business, in a flash!

Why should you invest your time in learning pivot tables in-depth? 

Pivot Tables in Excel is one tool that will give you the power to analyze data in an unbelievable and quick manner! Instead of using tons of formulas and spending time in creating error-free formaulas, using Pivot Tables, your report will be ready in no time! ;-)

Case Scenarios we will use to learn everything

  • T-shirt Sales dataset
  • Facebook posts analysis
  • Warehouse inventory analysis 

What all will you learn (completely hands-on) in this course?

  • Good versus Bad Data data structures (what works, what doesn’t)
  • Create single & multilayer pivot tables
  • Display options
  • Custom Sorting & Filtering
  • Copying, Moving & Deleting quickly
  • Drilldown
  • Summarizing values in various ways
  • Showing values differently to make more sense out of data
  • Applying Pareto's 80/20 principle
  • Ranking
  • Grouping
  • Report filter & pages
  • Calculated Fields
  • Securing your Pivot Tables
  • GETPIVOTDATA function's awesome applications
  • Pivot Charts
  • Connecting slicers & timelines
  • Build your 1st DASHBOARD! No programming required!
  • 2 awesome real-life data Projects
  • SURPRISE BONUS!

_________________________________

This is what our Participants have to say:

“The training provided by Rushabh Shah was excellent. His understanding of the subject is very deep and his methodical approach to train his participants ensures that the learning imparted will never be forgotten.”
- CA Mihir Sheth, Managing Director - Vision 3K Technologies (I) Pvt. Ltd.

“Rushabh is an excellent trainer. Not only is he knowledgeable in his skill, his presentation is flawless and extremely interactive. He makes sure that no one in the class is left behind in understanding of the concepts. This course has been of great help to me to make a sound beginning in the world of data analytics.”
- Abhijit Audhya, Head - Global Data Infrastructure Services at Société Générale

“Rushabh Shah explained so well, even a 6th grade student would have excelled in Excel.
- Praveen Udayakumar, Executive - Production (Tier Manufacturing) at MRF Tyres

“You want to learn Microsoft Excel Rushabh Shah is the man! Trust me i just finished with a workshop and it was amazing, the way he teaches step by step. He forces you to think logically which i think is amazing and they way he drills you, you can remember it for the rest of your life. I absolutely loved it and i am hoping he does more courses.
- Dimpy Bhalotia, Fashion designer at Dimpy Bhalotia

“Rushabh Shah is one of the finest instructor I have ever come across. It was fun learning excel from him. Suddenly Excel seems so exciting !!”
- Abhimanyu Dass

“Excel Trainer Rushabh has thorough knowledge of Excel and he is very good at delivering it in class. He makes sure that he carries the entire class with him. Extremely happy with his Training. Thanks a ton Rushabh !!!”
- Yashodhan Watve, Assistant Project Manager - Cyient Ltd.

___________________________________________________

  • radio_button_checked
    Self paced
  • check
    enrollments2
  • font_download
    LanguagesEnglish
  • event
    Published DateJun 10, 2018
  • radio_button_checked
    Documents: 11
  • play_circle_filled
    Video: 73

Course Highlights

  • check_circle
    Build standard & custom reports in Excel very quickly and efficiently
  • check_circle
    Create Dashboards in Excel without any kind of programming
  • check_circle
    Analyze your data much better
  • check_circle
    Create Business Reports in a flash
  • check_circle
    Make informed decisions based on data, not intuition and gut feeling

Schedule

Section 1 - Welcome to the Course!
  • subject
    Welcome to the Course
Section 2 - Good versus Bad Data Structures
  • class
    See me talk to you
  • class
    What is Good vs Bad Data? Rules to follow
  • subject
    How to Identify quickly whether your data structure is correct or not
  • class
    Unpivot Data quickly using Power Query / Power BI
Section 3 - Create your First Pivot Table - Fundamentals
  • class
    See me talk to you
  • class
    Create pivot table with Shortcut and without Shortcut
  • class
    Points to remember while creating a pivot table
  • class
    Rows, Columns, Values
  • class
    Multilayer pivot table
  • subject
    Download this dataset to learn hands-on
  • class
    Formatting your pivot table
  • class
    Formatting data in your pivot table
  • class
    Handling Empty cells and Cells with Errors
  • class
    Preserving the Formatting you did on the Pivot Table
Section 4 - Sort and Filter
  • class
    See me talk to you
  • class
    Basic & Custom Sorting - Rows and Columns
  • class
    Filtering - Label & Value - Begins With, Greater Than
Section 5 - Copying, Moving, Deleting your pivot tables
  • class
    See me talk to you
  • class
    Make an exact copy
  • class
    Move your pivot table to another sheet
  • class
    Quickly clear your pivot table
Section 6 - Drill-down reports
  • class
    See me talk to you
  • class
    Create a drill-down report
  • class
    When does drill-down not work properly?
Section 7 - Summarizing Values
  • class
    See me talk to you
  • class
    Functions in Excel - Summing, Counting, Averaging
  • class
    Summarize by Sum, Average, Count
  • class
    Summarize by Max, Min
  • class
    Multiple Subtotals
Section 8 - Show Values As ....
  • class
    See me talk to you
  • class
    % of Grand Total
  • class
    % of Row Total, Column Total
  • class
    Running Totals
  • class
    Applying Pareto's 80/20 Principle using Pivot table
  • class
    Difference
  • class
    Rank
Section 9 - Grouping your inputs
  • class
    See me talk to you
  • class
    Text inputs
  • class
    Date inputs
  • class
    Logic Behind Grouping with Dates
  • class
    When does Date grouping not work?
  • class
    Number inputs
Section 10 - Report Filter
  • class
    See me talk to you
  • class
    What is Report Filter? How does it work?
  • class
    Multilayer filter
  • class
    Addition of 2 or more items
  • class
    Automate Filtering to create tens or hundreds or reports in 1 shot
Section 11 - Calculated Fields
  • class
    See me talk to you
  • class
    Calculated fields
Section 12 - When underlying original data set is updated
  • class
    See me talk to you
  • class
    Refreshing it
  • class
    Adding new data from the source
  • class
    How to avoid manually adding new data from the source
  • class
    Issues you face when you automate it and how to solve these issues
Section 13 - Pivot Cache
  • class
    See me talk to you
  • class
    What is pivot cache?
  • class
    How to send a Secured Pivot table to someone else by email?
  • class
    Issue faced in grouping by Dates. How to resolve it?
Section 14 - GETPIVOTDATA function, yes it's extremely useful
  • class
    See me talk to you
  • class
    What is this function used for?
  • class
    Example 1 - real-life use of this function
  • class
    Example 2 - real-life use of this function
Section 15 - Pivot Charts
  • class
    See me talk to you
  • class
    Column & Bar charts
  • class
    Area chart
  • class
    Pie and Pie-of-Pie charts
  • class
    Line Chart
  • class
    Combo Chart
Section 16 - Slicers and Dashboards
  • class
    See me talk to you
  • class
    What are Slicers? How are they used?
  • class
    What is a timeline? How is it used?
  • class
    Create your first dashboard
  • subject
    Create a 2nd dashboard yourself now
Section 17 - Creating Pivot Tables from Data in Multiple Sheets
  • class
    Getting all data together into 1 single sheet
  • class
    Using Data Model to generate your Pivot Tables
  • subject
    Data Model - for Formula
  • subject
    Data Model - for Data Model
Section 18 - Project Time! Real life scenarios
  • class
    See me talk to you
  • subject
    Inventory dataset - Points for Analysis
  • subject
    Inventory - Dataset
  • subject
    Facebook Insights Dataset Analysis Points
  • subject
    Facebook Insights - Dataset
Section 19 - Surprise Bonus!
  • subject
    18 Most Useful Excel and Google sheets Shortcuts

Instructor

Rushabh ShahIndiaContact Instructor

Rushabh is the founder and CEO of dltc.co, a company that specializes in Excel and Microsoft Office training for corporate professionals. Rushabh has helped organizations such as NABARD, Bliss GVS, and TCPL Packaging train their professionals and improve productivity. Rushabh is also an avid blogger and runs a very successful YouTube channel on topics related to Excel.