Learn Excel* online intuitively!

Thousands of professionals from all over the world come to Wizdoh to learn Excel online.

Are you ready to discover The Power Of Mastering The Fundamentals Of Excel?

Discover my professional and free Excel training that will show the fundamentals of Excel VBA and macros, PivotTables, Dashboards, Vlookup, and much more. This Excel wisdom is packed in comprehensive Excel online courses you will love:


Data Control

Learn how to import unstructured data into the desired layout, how to export data to the desired layout, how to clean data, and much more!

Free Excel online courses: Excel Pivot Table tutorial

In-depth Excel online courses: Master of Pivot Tables, Pivot Table Data Success Blueprint



Insights Generation

Learn how to write advanced formulas, array formulas, how to make formulas dynamic, and much more!

In-depth Excel online courses: Master of Megaformulas


Sharing Insights

Learn how to create interactive dashboards, how to extract information for your reports using VLOOKUP, INDEX & MATCH, learn how to use charts, and much more.

Learn Excel free: How to create Excel dashboards

In-depth Excel online courses: How to create Excel dashboards


Task Control

Learn how to collect, analyze and present data faster, smarter, and more accurate with Excel VBA macros, shortcuts, and dynamic techniques.

Learn Excel VBA free:  How to record a macro in Excel

In-depth Excel VBA online courses: Master of Macros Blueprint, Simple Macro Writing System, How to do more than 150 basic Excel tasks using VBA

Here’s what some students who enrolled in my Excel courses and started to learn Excel online, say:




John can teach you some really awesome tricks and help you become better at writing lookup formulas.



I like the way that you encourage us to make our work adaptive to change. In fact you have been a major influence in how I design my spreadsheets.

I used to force my users to work the way I wanted them to work, by making it difficult to work any other way. Now, I use more adaptive functions, macros and many more error traps when I make new spreadsheets and also when I modify the old ones.

Thanks a lot, John.


As a teacher I love your simple creative ways of explaining complex subjects, it was through your teaching I learned so much more and in turn shared with my students.

To this day I use your rules about designing a good table. I always enjoyed your teaching style and I am thrilled to know you have returned to Excel.

Dave U.

I’ve purchased some of your publications in the past (“Master-of-Macros-book”, “Pivot-Tables-VBA-Secrets”,”How-to-write-perfect-vlookup-im-formulas”, etc), and I am quite impressed with how you go about making difficult concepts very clear.

Mary Grimes

Very good beginning to understanding the logical flow of programming. This lesson has helped me greatly in understanding what I call the GrandParent.Parent.Child objects. How to take action on each one of them and in what order.

Emad Talafeha

Dear John…

Really you are fascinating and have an explanation method that is highly attractive. Your approach impressed me because it hits the point directly…

Lesley F

The Pivot Tables Seminar has given me lots of ideas of how the dashboard can be better produced, and hopefully be more dynamic rather than a monthly task! I’m not a data analyst but find manipulating the data on a dashboard to be fun (as far as work is!).

I will continue to follow your seminars, and have learnt a lot – I’m not frighted of pivot tables anymore!!!!

Shreepad G.

I do keep reading and enjoying your emails about Excel. They have proved helpful at work, I must admit.

Good luck and thanks again.

Anonymous subscriber

John brings to light useful functions/methods/approaches otherwise unknown to a significant portion of Excel users.


I love you John Franco. You make me a master at Excel!

Geir S

I have been “following” you for several years, and you produce lots of really good stuff for us Excel addicts

Emad Talafeha

Sometimes, thankful and gratitude words might not express the right thanks that should be extended to you. I have just finished reading your great book “How to Create Dynamic and Interactive Excel Dashboards.”

Your efforts and great help that you are presenting to Excel learners are unbelievable. I wish if I would be able to meet you face to face to thank you.


John Maybee, Canada

Don’t stop sending me your emails though!


I love your use of analogies to illustrate how Excel and VBA works.

Amir Afshar

Solid first introduction to Pivot Tables.

I am really liking the course so far. It is very well-structured and you explain the concepts in a new, great way. I am looking forward to going through this entire course.

Wow! I never thought of it like that. That rotating the cube description is really enlightening for me and brilliant. Thanks!

Danielle Stein

Thanks – lots of useful articles on Excel.

Author of Using Excel for Business Analysis


Rob R

Hi John, I just bought your dashboards book. It looks very good and a new innovative way to view things!!
I love the way you are breaking things down and getting my brain working and improving my thought process.


Hi John… you have very good content here. I am subscribing to your blog for my daily reading list.


Don't miss my Excel Secrets Newsletter

When you subscribe to my Excel Secrets Newsletter, you’ll learn the jealously guarded Excel secrets I’ve used to do a lot more (with a lot less) in my own corporate career… and continue to share with my elite inner circle!

Enter your email and name below...

Professionals from all kinds of organizations** learn Excel online here and gain fundamental Excel knowledge