Online Courses from Chandoo.org
We run many online courses so that you can become awesome in Excel at your own pace. You can join these programs any time and access the material from anywhere, 24×7.
Beginner to Advanced Excel
Our flagship Excel training program makes you awesome in beginner to advanced level Excel in a short span of 8 weeks. You will be learning how to use formulas, conditional formatting, tables, pivot tables, charts, form controls, database connections & more. Join today and unleash the Excel pro in you.
Excel Dashboards course
Create world-class Excel dashboards using powerful features like Excel tables, advanced formulas, interactive charts, sparklines, slicers & conditional formatting. Join our famous Excel School dashboards program and become awesome today..
Explore the world of VBA, macros & automation. See how much more you can achieve by customizing Excel & creating your own applications. Automate boring, repetitive work to save time & $$$s. You will learn right from basics of programming to advanced VBA. Topics include – loops & conditional statements, using various Excel objects, establishing connections to databases & flat files, creating user forms, automating charts, presentations & reports, adding animations etc.
Power Pivot School
Jump in to power pivot, analyze data & extract insights like a pro by going thru this program. Aimed at Excel analysts & reporting professionals, this course helps you unleash power of PowerPivot to do awesome things. You will learn how to set up PowerPivot tables, write DAX measures, using features like conditional formatting, KPIs with PowerPivot & how to create powerful, insightful dashboards using PowerPivot.
Financial Modeling Classes
Learn how to create a completely integrated valuation model using Excel. Analyze financial data like a pro & impress your colleagues. You will learn basics of finance, best-practice modeling, valuation & analysis techniques, Excel financial formulas, how to visualize financial analysis (waterfall charts, football field analysis etc.) and more.
Finance for non-finance people
Learn about financial basics, financial analysis thru Excel in our finance for non-finance people course. Designed by partners at Pristine education, this course helps you gain insights to finance world quickly.
Upcoming Live Training
Unlock Excel Conference – Auckland
11 & 12 May, 2017
Announcing my first ever conference in New Zealand – Join me & many other Excel experts to at Unlock Excel conference in Auckland this May (11th & 12th May – Thursday & Friday).
This two day event is a great opportunity to learn some cutting edge Excel data analysis & visualization techniques from world’s best.
Over the two conference days you can also get answers to your most challenging problems directly from one of Microsoft’s Excel developers and to hear what the next version of Excel might include!
Tickets on sale now. Check out the conference page and book your slot today.
Monthly Master Classes
Here is a fun way to learn Advanced Excel in bite sized portions. Every month, we cover one topic extensively and offer incredible value in a video lesson. Check out the episodes below.
01 – Advanced Interactive Charts
Learn how to create advanced interactive charts using Excel pivot tables, slicers, conditional formatting and VBA.
02 – All about SUMPRODUCT()
From beginner to advanced, learn everything about SUMPRODUCT formula, inner workings of array formulas in Excel and so much more in this episode of our Master Class.
03 – Maps in Excel
Learn how to make awesome interactive maps that to go in your dashboards & reports. In this Masterclass, we explore several ways to get maps in Excel.