Excel School online training program - become Awesome in Excel from Chandoo

Introducing the most advanced Excel class yet.

Friends & supporters of Chandoo.org. It gives me great pleasure to announce Excel School v2.0, my most advanced, powerful and complete Excel training program ever. In this course, you will get comprehensive, unparalleled coverage on how to be awesome in data analysis, dashboard reporting and day to day usage of Excel.

What is Excel School?

Excel School is structured and comprehensive online training program for learning Microsoft Excel. It is full of real world examples.

The aim of Excel School is to make beginners become productive and awesome in Excel. It has an optional module on Dashboards, which can teach you how to design awesome Excel Dashboards.

Why should you join Excel School?

These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job and can give you time to focus on things and people that matter.

While we can argue that Excel can be learned by reading help and visiting blogs like Chandoo.org, it also takes good amount of time if you use that method.

Today, there are over 1,000 articles, tutorials and examples on Chandoo.org explaining almost every aspect of MS Excel. I am sure there are thousands of useful, free and fun articles on learning Excel across Internet. It would take almost 6 months if you read one article a day to master some of the core concepts of Excel. Even then you may not know some important things.

That is why I designed Excel School Program. This is an advanced Excel class like no other. The 6+1 modules in Excel School cover entire spectrum of Excel work. Each module contains several videos and downloadable excel files for you to learn the concepts in detail. This is an intense, focused and clearly defined program to help you learn Excel in useful and fun way.

Enrollments close soon. Check out below course plan & sign-up today.

  • What is Excel School and how it helps you?

Your teacher - Chandoo

My name is Chandoo and I will be your teacher in Excel School program. I have been training people on Excel, Power BI, Power Pivot and analytics for over a decade. My teaching is practical and hands-on with several real world examples. I have taught more than 20,000 people to date (online and offline) and I would love to help you. I live in coastal city of Wellington in New Zealand with my beautiful wife and two kids.

0
Excel School students to date

8 reasons why

  • Step-by-step instruction
  • 20 hours + video content
  • 50+ Example workbooks
  • 24x7 online access
  • Download HD quality videos
  • 2 years validity
  • Secure classroom
  • 30 day money-back guarantee

Modern Excel + You =

If there is no data, then you wouldn’t need Excel. Data is the first thing we start with whenever you are building that next-fancy-spreadsheet.xlsx. So the first thing you will learn in Excel School is how to work with data. We cover below areas in-depth.

  • Power Query – for data management, connections, clean-up and reshaping data
  • Tables – for setting up data, using structural references, quick formats and ad-hoc analysis of data
  • Relationships – Connect two tables to see magic happen. Create data models and build beautiful stuff.
  • References – learn the rules of the game. A1 is not same as $A$1.
  • Clean-up – poorly presented data with tricks like flash fill, find replace, goto special and Power Query.

Once you have clean data, the next step is to analyze it. Excel offers two main routes for data analysis – (1) Formulas (2) Pivot Tables. In Excel School we cover both areas in-depth so you can be a master of the game. Learn when to use formulas, when to use pivot tables and how to mix both for pleasure and power.

  • Formulas – Start with basics like operators, reference styles and quickly migrate to statistical decision making (IF, CHOOSE, IFS, AND etc.), analysis functions, summaries (COUNTIFS, SUMIFS etc.), lookups (VLOOKUP, INDEX+MATCH, 2 way lookups) and how to combine functions.
  • Pivot tables – Create simple pivot tables, data model driven multi-table pivots, use features like slicers, timelines, report filters with confidence, create groups, work with advanced pivot table reporting and pivot charts.
  • Advanced Formulas: Learn how to use advanced lookup formulas (multiple condition lookups, duplicate value handling), weighted averages thru SUMPRODUCT, summarizing filtered values (SUBTOTAL), date and time formulas, text analysis formulas and more.
  • Ad-hoc analysis – sometimes we are not in the mood to write an elaborate formula or make a pivot. Learn how to use Excel’s built-in quick analysis features to get answers for your questions.

Now that we have analyzed some data, let’s make beautiful outputs. You can use charts, sparklines, conditional formats, pivot reports and many other features of Excel to create stunning, elegant and informative displays for your audience.

  • Charts – start with the rules of which chart goes with which data. Then progress to chart creation, customization. Finally learn how to create complex, interactive charts for your audience. 
  • Sparklines –  Create small, in-cell visualizations from your data. Make them powerful and insightful.
  • Conditional formatting – Create rule based formatting and visualization behavior to wow your boss.
  • Reports & Dashboards – In this optional module, learn how to create beautiful dashboard reports from any data.

There is no point having a beautiful workbook locked up in your computer. The last step of any Excel work is to publish and let your audience get the information you want. This last mile is vital. That is why, In Excel School you will learn how to deal with the publishing aspect of your work. We focus on,

  • Interactivity – Everyone likes to play. Wouldn’t it be cool if your spreadsheets are playable? Learn how to use interactive features like slicers, timelines, form controls, data validation and hyperlinks to maximize the WOW factor of your workbooks.
  • Formatting –  Even the most powerful analysis can look ugly and confusing if formatted poorly. Through out Excel School, I teach you how to create beautiful, elegant and readable workbooks so that your boss will be stunned.
  • Navigation – Whenever we create more than one page Excel files, it is important to provide sensible navigation. Learn how to set up large dashboards, reports or business workbooks.
  • Refresh – Change is the only constant in business. So when you have new data next {day, week, month, year} does it mean you must create the file all over again? No, of course not. Learn how to build refreshable files so that you create once and reuse often.

You will create spreadsheets

Few of the awesome things you will learn in Excel School

Topics covered in Excel School

Getting Started

  • 10 lessons
  • 2 hours

Intro to Excel
Setting up tables
Cleaning bad data
Cleaning using Power Query
Writing formulas
Creating pivot tables
Making charts
Filtering & sorting
Shortcuts

Data + Tables + PQ

  • 5 lessons
  • 3.5 hours

Excel Tables
Filtering, slicing tables
Bad data to good with PQ
Unpivoting data with PQ
Merging multiple files to one table

Writing Formulas

  • 10 lessons
  • 4.5 hours

Referencing data
IF condition, CHOOSE, IFS
Statistical analysis
Conditional sum, count
Lookups
Advanced Lookups
Date formulas
Text analysis
Sentiment analysis
Exploratory data analysis

Making Pivot Tables

  • 4 lessons
  • 3 hours

Creating pivot tables
Data model + relationships
Multiple table pivots
Customizing pivots
Extra calculations in Pivots
Grouping data
Slicing and dicing
GETPIVOTDATA

Charts + Graphs

  • 10 lessons
  • 4 hours

Intro to Charting
Picking right charts
Anatomy of Excel chart
Formatting charts
New charts in Excel 2016
Budget vs. Actual charts
Then vs. Now charts
Conditional charts
Sparklines
Interactive charts

Advanced Concepts

  • 9 lessons
  • 2 hours

Data validation
Creating templates
Workbook protection
Publishing to web
Shapes + pictures
Navigation buttons
Priting
Form controls
Custom ribbons

Optional module on

What is a dashboard?
Process for dashboards
Business dashboard #1
Business dashboard #2
Business dashboard #3
Employee Dashboard
Financial metrics dashboard
KPI Dashboard
Web enabled dashboard

Excel Dashboard Training Course

Excel Dashboards

  • 9 lessons
  • 8 hours

Dashboards from Excel School

Join Excel School Today

Excel School

online + download access
$ 147
  • 6 modules of Adv. Excel Lessons
  • 48 lesson videos
  • 40+ example workbooks
  • 2 years online access
  • Download HD quality videos
  • Formula cheat sheet
  • Shortcuts poster
  • 30 day money back guarantee

Excel School
Dashboards

online + download access
$297
$ 247
  • 6 modules of Adv. Excel Lessons
  • Extra module on Dashboards
  • 57 lesson videos
  • 50+ example workbooks
  • 2 years online access
  • Download HD quality videos
  • Formula cheat sheet
  • Shortcuts poster
  • Slicers for Dashboards video
  • $50 discount
  • 30 day money back guarantee
Offer

Problems with payment? Try  below alternatives …

  • Secure Payment
  • 30 day money back guarantee
  • 24x7 online access

Your sense of humor, kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable.

Mary Scott, HR professional

Frequently Asked Questions...

Which version of Excel do I need?

In Excel School we are using Excel 2016 / Office 365. While you can apply the concepts to older versions of Excel (Excel 2013, 2010 or 2007), to get the most out of it, use Excel 2016 or Office 365.

Can I use this on Mac Excel?

You may. Excel School is recorded on Excel 2016 / O365 for Windows. Most of the formulas, charts & techniques work equally well on Mac. I suggest borrowing a PC for practicing other ideas.

Is this a one-time payment?

Yes. Excel School is a one time payment program. There are no recurring charges.

Can I get team / group discount?

Yes. You get 25% discount when purchasing 3 or more memberships for Excel School programs.

If you want to enroll a large team (50 or more people), please email chandoo.d@gmail.com

Can I get a purchase receipt / invoice?

Yes you can. After your payment you will get it automatically.

If you need it in a specific format, please email chandoo.d@gmail.com with “invoice” in the subject. 

We can also invoice you before purchase so you can make a payment against it. Please email.

My question is not listed…

No problem. Just email me at chandoo.d@gmail.com or call me on +64 21 070 1136 so I can help you make a decision.

What is Power Query? What is Power Pivot?

Power Query:

Power Query is a data management interface for Excel (and Power BI). Using Power Query you can connect to any kind of data sources (SQL Databases, workbooks, online data sets, web pages etc.) and bring the data to Excel (or Power BI). Power Query also lets you manipulate data by adding columns, changing shape of the data or combining data sets. It is part of Excel functionality in 2016 or Office 365 versions. For older versions, you can download the free add-in from Microsoft website.

Power Pivot:

Power Pivot is a calculation engine for pivot tables in Excel (and Power BI). Using Power Pivot you can enhance your pivot tables and add extra calculations easily. Power Pivot is available by default in Excel 2016, Office 365 and Excel 2013. For other versions of Excel, you can download the free Power Pivot add-in from Microsoft Website

Thank you...

I am thankful to all the readers and supporters of Chandoo.org. Thank you for considering my Excel School program. I am excited to share this powerful course with you so that you can be awesome at what you do. Thank you. 🙏

PS: As of writing this, more than 350 students have already enrolled in Excel School 2.0. Don’t miss out the chance to learn and use powerful features of Excel.