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.
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.
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 opening on 22nd August, 2018 – Wednesday. Meanwhile, check out the course plan and samples below.
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 and I would love to help you. I live in coastal city of Wellington in New Zealand with my beautiful wife and two kids.
8 reasons why
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.
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.
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.
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,
Intro to Excel
Setting up tables
Cleaning bad data
Cleaning using Power Query
Creating pivot tables
Filtering & sorting
Filtering, slicing tables
Bad data to good with PQ
Unpivoting data with PQ
Merging multiple files to one table
IF condition, CHOOSE, IFS
Conditional sum, count
Exploratory data analysis
Creating pivot tables
Data model + relationships
Multiple table pivots
Extra calculations in Pivots
Slicing and dicing
Intro to Charting
Picking right charts
Anatomy of Excel chart
New charts in Excel 2016
Budget vs. Actual charts
Then vs. Now charts
Publishing to web
Shapes + pictures
What is a dashboard?
Process for dashboards
Business dashboard #1
Business dashboard #2
Business dashboard #3
Financial metrics dashboard
Web enabled dashboard
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.
Yes. Excel School is a one time payment program. There are no recurring charges.
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 email@example.com
Yes you can. After your payment you will get it automatically. If you need it in a specific format, please email firstname.lastname@example.org with “invoice” in the subject.
We can also invoice you before purchase so you can make a payment against it. Please email.
Yes you can. Just pay the fee difference and you will be upgraded. There is an upgrade page in the classroom with instructions to help you.
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 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
No problem. Just email me at email@example.com or call me on +64 21 070 1136 so I can help you make a decision.
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.