Ever wonder if there is a faster way to sift through data in Excel?

Perform your day to day analysis faster.. so you can go home early!

Do you want to work more efficiently?

You're a corporate worker, often raking through many data files transmitted to you. You get spreadsheets after spreadsheets containing tons of data and you wonder, there must be an easier way to analyze this?

You're a student or a researcher, working through many sample data or lab results. You painstakingly group your data manually and create numerous charts, constantly re-arranging your data to get some insights. 

... Or you are just someone curious about learning how to simply handle and analyse data for your business.


Does this sound like you?


What If..

  • You already knew Pivot Tables could analyse most of the things that you want automatically?

  • You can already manipulate the data from various angles easily to uncover insights and discover trends that can lead to a breakthrough in YOUR research?

  • You can already skip through scouring all over the internet in hope of finding all things related to Pivot Tables - and learn it all in one place?

  • You already have that extra skill and expertise in using Excel that can set you apart from others? Not to mention, go home early because you're so awesome at your job?

Meet Pivot Table..

PivotTable is one of the most important and powerful tools available in Excel to calculate, summarize, and analyze data quickly. It allows you to see comparisons, patterns, and trends in your data in seconds! Without having to do calculations manually!

Want to know more?

Get to know Pivot Tables better

Learn More

Course curriculum

  • 1

    1. Introduction

  • 2

    2. Creating your First Pivot Table

  • 3

    3. Formatting your Pivot Table

    • 3.0 Introduction

    • 3.1 Formatting - Number Formats

    • 3.2 Formatting - Table Layout & Styles

    • 3.3 Tip! Changing Headers & Labels

    • 3.4.1 Conditional Formatting - Apply Rules to Cells

    • 3.4.2 Conditional Formatting - Top/Bottom Rules & Databars

    • 3.5 Tip! Invisible Text
  • 4

    4. Sorting, Filtering & Grouping

    • 4.0 Introduction

    • 4.1 Sorting

    • 4.2 Filtering - Label

    • 4.3 Filtering - Number

    • 4.4 Grouping

    • 4.5 Show Report Filter Pages
  • 5

    5. Calculated Values & Fields

    • 5.0 Introduction

    • 5.1 Summarize Values by

    • 5.2.1 Show Values as Percentage Total

    • 5.2.2 Show Values as Percentage Parent Total

    • 5.2.3 Show Values as Difference From

    • 5.2.4 Show Values as Running Total In

    • 5.2.5 Show Values as Ranks

    • 5.2.6 Show Values as Index

    • 5.3 Calculated Field

    • 5.4 Calculated Item

    • 5.5 Solve Order
  • 6

    6. Charts & Visualizations

    • 6.0 Introduction

    • 6.1 Trend Chart

    • 6.2 Clustered Column

    • 6.3 Pie Chart

    • 6.4 Line Chart

    • 6.5 Column Chart

    • 6.6 Slicer

    • 6.7 Putting Everything Together
  • 7

    7. Additional Info - Personal Expenses Dataset

    • 7.1 Introduction to a New Dataset

    • 7.2 Date Grouping

    • 7.3 Inserting Timeline

    • 7.4 The GetPivotData Formula
  • 8

    8. Closing

    • A Thank you Note
  • 9

    Bonus #1! Creating Personal Expenses Dashboard

    • 1.1 Introduction

    • 1.2 Monthly Tracking

    • 1.3 Utility Tracking

    • 1.4 Expenses Breakdown

    • 1.5 Dynamic Field in Charts - Grand Totals

    • 1.6 Dynamic Field in Charts - Timeline

    • 1.7 Sub-Category Breakdowns

    • 1.8.1 Putting Everything Together 1

    • 1.8.2 Putting Everything Together 2
  • 10

    Bonus #2!

    • Introduction

    • Formatting Source Data Using Power Query

but hold on.. there is a Bonus!

With this purchase TODAY, you get access to additional contents!

  • Bonus #1

    Learn how to create your own Personal Expenses Dashboard! Includes lessons on how to use the TEXT and IF excel formulas to create dynamic chart titles

  • Bonus #2

    Learn how to use Power Query to transform and restructure your source data

So.. Here's What You're Getting

  • Approximately 50 videos worth of lessons on Pivot Tables, making up to almost 5 hours of knowledge, that you can go at your own pace

  • Little snippets of Excel tips and shortcuts throughout the course to help you become more efficient in Excel

  • Your own Personal Expenses Dashboard

  • A quick introduction to Power Query

Course Instructor

Ally Raz

Ally holds a degree in Bachelor of Engineering (Mechanical) and most of her experiences are drawn from the Oil and Gas Industry. Her roles include carrying out Front-End activities and project engineering tasks for oil and gas development projects. She developed an interest to work more efficiently in Excel while working with cost models and project benchmarking models. Her expertise in Excel grew when she took on to become a Petroleum Economist, developing oil and gas economic evaluation models for various fiscal contracts and performing company portfolio analysis.