Special One-time Offer

SNAG-3906

Excel + Power BI
COMBO

online + download access
$798
$ 347
  • 6 Modules of Adv. Excel
  • 6 Modules of Power BI
  • 1 Module on Dashboards
  • 100+ Lesson videos
  • 70+ Example workbooks
  • 2 Years online access
  • Download HD videos
  • 4 Bonus files & videos
  • 14 Day guarantee
Buy Now
Pay in INR - ₹25,000
BEST DEAL

Scan QR Codes to pay from your phone 📸

SALE ends in
Days
Hours
Minutes
Seconds

What my students say...

This is the first course that I have attended with you. I've already told my supervisor that I can't wait to take another one.
Angie W
Joined live session
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Joined live session
This is the first course that I have attended with you. I've already told my supervisor that I can't wait to take another one.
Angie W
Joined live session
Wonderful & Awesome explanation... Learnt a Lot... Thanks Chandoo...
Nandan
Joined live session

G’day Chandoo,

I love it. Very insightful and lots of useful tips and tricks. Looking forward to immersing myself in more lessons soon.
 
Appreciate all your hard work ; enthusiasm and dedication to the Excel cause.
 
– Harry F (Aussie, living in Texas)
excel-school-testimonial-deramin
You are just awesome, it's one thing to have the knowledge and a totally different thing to share it so simply.
Aadityendra
Joined live session
Great bootcamp! Worth every penny.
John A
Joined live session
Hi Chandoo 👋 You really have a great knack for educating ppl on Excel applications. I have learnt alot from your online videos and tutorials and it pushed me into learning PQ and now I'm building PQ templates for my work for routine tasks and stuff!.. thanks again for generously sharing your knowledge and making an impact always 😌
M Kader
Joined live session

Thank you! Your product has literally changed my work life and provided easy to use solutions that I was able to immediately put into practice. 

– Sheelyah

I have subscribed for your online excel and dashboard lessons and was able to complete all the excel lessons. And these turned out to be very very useful in my work and made me very confident in excel reporting. A very big thank you to you for that 🙏😊

 

– Subhashini 

Detailed Topics in the Course

Power BI Topics:

56 Lessons | 50+ Workbooks | 16+ Hours

  • Introduction and Basics 4 Topics
    • Welcome to the Power BI Module – PB – 001
    • Power BI Technology & Jargon Explainer – PB – 002
    • Getting Started with Power BI – PB – 003
    • How to create a quick sales dashboard with Power BI- PB – 004
  • Power Query for Power BI 2 Topics
    • Working with Power Query – US Population data in Power BI- PB – 005
    • Fetching data and processing – NZ Election information [ADVANCED]- PB – 006
  • Power Pivot & DAX 12 Topics
    • Getting started with DAX- PB – 007
    • DAX 101 – continued- PB – 008
    • Story telling with Power BI – putting all that DAX to good use- PB – 009
    • Data Modeling with Power BI (Awesome Chocolates Data)
    • Understanding DAX with Awesome Chocolates Dataset
    • Advanced DAX Examples – 1 (SWITCH and more CALCULATE)
    • Advanced DAX Examples – 2 (ALL function)
    • Advanced DAX Examples – 3 (visual calcs)
    • Advanced DAX Examples – 4 (SUMX)
    • Advanced DAX Examples – 5 (DAX thinking)
    • Advanced DAX Examples – 6 (TOPN)
    • Advanced DAX – Homework problems
  • Time Intelligence Calculations with DAX 8 Topics
    • Organizing Measures with a separate table & folders – T01
    • Basics of Time Intelligence in DAX – T02
    • Year on Year (YoY) comparison with DAX – T03
    • Using SAMEPERIODLASTYEAR in DAX – T04
    • Surge, Slump or Stable – Practical DAX Problem – T05
    • Monthly Running Totals – Practical DAX Problem – T06
    • Moving Average with DAX – T07
    • Moving Average with Visual Calculations – T08
  • Working with Power BI Visuals 8 Topics
    • Power BI Visuals – The Basics – V01
    • Combination Charts – V02
    • Maps in Power BI – V03
    • Scatter Plots in Power BI – V04
    • Top 3 Salespersons as a table – V05
    • Waterfall Charts in Power BI – V06
    • Customizing the interactions in Power BI – V07
    • Conditional Formatting + Matrix in Power BI – V08
  • Data Analysis & Dashboards with Power BI 6 Topics
    • Case study 1: Retail Dashboard – PB – 010
    • Case study 2: Budget vs. Actual Dashboard – PB – 011
    • Insurance Dashboard with Power BI – Full Case Study
    • Bonus case study – Executive dashboard with Storagemart – PB – 012
    • London in Future – Population pyramids & trends explored- PB – 013
    • Squirrels in New York- PB – 014
  • Power BI Adv. Features and Concepts 6 Topics
    • Drillthrough feature- PB – 015
    • Bookmarks- PB – 016
    • Dynamic titles with conditional formatting- PB – 017
    • Advanced labeling tricks for visuals- PB – 018
    • Variance charts in Power BI- PB – 019
    • New vs. Returning Customers – DAX concept
    • Bonus Materials
  • Power Query Crash Course 10 Topics
    • Introduction to PQ Crash Course – PQ01
    • How to use Power Query to clean-up data – PQ02
    • Data cleaning with Power Query contd. – PQ03
    • Power Query homework – Salary Grouping – PQ04
    • Power Query homework solution – Salary Grouping – PQ05
    • Merging (joining) two datasets with Power Query – PQ06
    • Combining (appending) datasets with Power Query – PQ07
    • Unpivoting data with Power Query – PQ08
    • More Power Query videos – PQ99
    • Power Query mind-map (PDF Download)

Excel Topics:

64 Lessons | 100+ Workbooks | 32+ Hours

  • Module 0 – Getting started
    • 1. Introduction to Excel
    • 2. Working with data
    • 3. Cleaning up data
    • 4. Using Power Query – Quick intro
    • 5. Writing formulas
    • 6. Creating pivot tables
    • 7. Making charts
    • 8. Using conditional formatting
    • 9. Working with filters
    • 10. Using shortcuts & customization options
  • Module 1 – Working with Data, Tables & Power Query
    • 1. Bad data to good data – journey – Power Query
    • 2. Creating and using Excel Tables
    • 3. Filters & Slicers on Tables
    • 4. Introduction to conditional formatting
    • 5. [Advanced] Conditional formatting formulas + goal tracker app NEW
    • 6. [Advanced] Bad data example 2 – Unpivoting data
    • 7. [Advanced] Bad data example 3 – merging multiple files
  • Module 2 – Analyzing data with formulas
    • 1. Referencing data – cell, named, structural
    • 2. IF formula in Excel
    • 3. Statistics & summaries
    • 4. Conditional sums, counts
    • 5. Lookups – VLOOKUP, XLOOKUP, INDEX+MATCH, HLOOKUP
    • 6. Dynamic Array Functions in Excel – FILTER, SORT, UNIQUE, SEQUENCE etc.
    • 7. [Adv] Advanced Lookups in Excel
    • 8. [Adv] XLOOKUP Deep Dive: 5 Advanced Scenarios
    • 9. Working with dates in formulas
    • 10. Text formulas
    • 11. [Adv] Sentiment analysis with Excel – case study
    • 12. [Adv] Exploratory Data Analysis – Hotel Reviews case study
  • Module 3 – Data analysis with Pivot Tables
    • 1. Introduction to Pivot tables & advanced tips
    • 2. Grouping data in Pivots
    • 3. Calculating things in Pivots
    • 4. [Adv] GETPIVOTDATA – talking to pivots
    • 5. Formatting pivot tables, charts and slicers
    • 6. Answering business questions – Pivot table case study
    • 7. [New] Sparklines + Pivot Tables – trick
    • 8. [NEW] Dynamic Business Dashboard with Pivot Tables alone
  • Module 4 – Making charts & graphics
    • 1. How to pick right chart for your data?
    • 2. Introduction to Excel charting
    • 3. Anatomy of an Excel chart
    • 4. Working with new charts in Excel 2016 / Office 365
    • 5. [Adv] Conditional charts
    • 6. [Adv] Budget vs. Actual charts
    • 7. [Adv] Then vs. Now charts
    • 8. Sparklines, in-cell charting in Excel
  • Module 5 – Productivity & Advanced Excel
    • 1. Data validation in Excel
    • 2. Form controls in Excel
    • 3. Working with shapes & pictures
    • 4. Making chart & workbook templates
    • 5. Unpivoting complex data – Power Query case study NEW
    • 6. [Advanced] VLOOKUP Multiple Matches trick NEW
    • 7. Cascading Drop-downs in Excel
    • 8. Customizing Excel for productivity
    • 9. Chandoo’s favorite time saving features of Excel
  • Module 6 – Excel Dashboards
    • 1. Our first dashboard – dynamic, interactive, automated and wow
    • 2. Dashboard creation process
    • 3. [Adv] Sales Performance Dashboard
    • 4. [Adv] Employee Vacation Tracker & Dashboard
    • 5. Employee Training Tracker
    • 6. [Adv ++] Hotel KPI Dashboard
    • 7. [Bonus] Web Analytics Dashboard with Excel
    • 8. [NEW] Awesome Sales Dashboard with Excel
    • 9. Dynamic Business Dashboard with Pivot Tables alone
    • 10. [NEW] One formula dashboard with Excel’s LET function

Need more information? Check out the course page for all the details.

Learn more about the courses