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 Customizing pivots Extra calculations in Pivots Grouping data Slicing and dicing GETPIVOTDATA
Adv. Pivot Table bonus
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 / 2019 / 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 2019, 2016 or Office 365.
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
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
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.
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. Excel School is a one time payment program. There are no recurring charges.
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.
PS: As of writing this, more than 1,200 students have already enrolled in Excel School 2.0. Don’t miss out the chance to learn and use powerful features of Excel.
Proceed To Pay