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 how to collect, analyze and present data faster, smarter, and more accurate with Excel VBA macros, shortcuts, and dynamic techniques.
John can teach you some really awesome tricks and help you become better at writing lookup formulas.
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.
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.
John brings to light useful functions/methods/approaches otherwise unknown to a significant portion of Excel users.
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.
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… Read more…