Learn to use Pivot Tables to produce Business Insights and semi automate the reports.
Free tutorial
Created by Kunaal Naik
English
What you’ll learn
- Generate insights using Pivot Tables
- Semi Automate Reports
- Improve Accuracy while reporting
- Build quick Dashboards using Pivot Tables
Requirements
- Basics of Excel
- Enthusiastic about bringing insights to business users
Description
As a Business user, you might often feel overwhelmed by the number of requests you can handle at a time. Sometimes you wished there were more hours in a day to work them out correctly and at the same time provide insights.
In this Pivot Table series for Power Business users, you will learn smart tips and tricks to get to a solution quickly using Excel Pivot tables and semi-automate your reporting to answer same questions faster in the future repeatedly. Also, we will learn how to build Dashboards which are easy to make and simple to use.
Who this course is for:
- Beginner users who want to learn to generate insights using data
- Build quick dashboards using Pivot Tables
Show less
Course content
6 sections • 14 lectures • 1h 39m total lengthCollapse all sections
Welcome1 lecture • 1min
- Introduction01:09
Starting with Basic5 lectures • 33min
- Analyse Data by Manual Grouping10:24
- Analyse Time Series Data10:29
- Dynamically Update Pivot Tables04:15
- Create Histograms03:18
- Uneven Histogram04:58
Adding Calculated Fields and Items3 lectures • 30min
- Calculated Fields07:58
- Calculated Items16:10
- Delete and Add Calculated Fields05:44
Work with additional categories3 lectures • 23min
- Group by Month and Week05:44
- Group by Month not working07:25
- Cumulative Values09:38
Building Dashboards1 lecture • 12min
- Build Corona Dashboard11:42
We are done!1 lecture • 1min
- Thank You00:45