The CORE class that will change the way you think about Excel forever.
Learn shortcuts to triple your speed, learn the most important formulas (VLOOKUPS, IF, SUMIF, etc), and turn your stubborn messy dataset into an elegant report using pivot tables.
Best of all, you'll learn to build a template you can re-use next week when the dataset grows.
Take Excel to the next level while expanding on the knowlege from the first class.
We'll learn to write cleaner formulas, use advanced logic, maser the infamous INDEX/MATCH, and learn to build a spreadsheet that doesn't get slow and crash.
We'll also learn to write some simple macros and use automation to eliminate tedious tasks.
Take Excel to the Moon.
Power Query allows us to capture and clean several datasets from multiple sources.
Power Pivot allows us to analyze multiple datasets in one "powerful" pivot table.
These are the very same features used in Power BI, which is Microsoft's answer to Tableau, a professional cloud-based dashboarding tool.
Ed Blach (DVM, MS, MBA) is co-founder of Ask.Vet, the leading telehealth innovator in the pet care market. He co-invented the FLAIR(R) nasal strip to protect the lungs of competing horses. He is former CEO of the largest equine hospital in the world, Hagyard Equine Medical Institute in Lexington, KY.
Dr. Blach built Ismypracticehealthy.com as a concise resource to teach veterinarians how to grow their practices, improve profitability, and enhance enterprise value. He mentored the owners of more than 150 veterinary practices, helping grow their collective enterprise value from approximately $300,000,000 to more than $3.0 billion over a 10 year period.
Ed was fortunate to meet “Excel Mike” at La Guardia airport in New York after seeing him work a keyboard like a concert pianist. Even after 12 years of college, Mike is still the best teacher Dr. Blach has ever experienced. He’s seen the impact of Mike’s work on the practice owners and managers he has worked with over the past 10 years.
After escaping Wall Street, Michael went on to design one of New York's most coveted Excel training programs. Michael has trained over 50,000 students for clients including Goldman Sachs, JP Morgan, Cole Haan, Kate Spade, Royal Bank of Canada, TripAdvisor, Spotify, and SoulCycle.
Michael's teaching style is highly unconventional, wildly entertaining, and may induce learning. He is a published co-author in the scientific Journal of Visualized Experimentation and holds a bachelor's degree from NYU.
Michael has been working with Dr. Ed for over a decade. Refer to our reviews by former students that can attest to the quality of his workshops.
“I have attended two workshops with Michael and would rate them both 10 out of 10. He makes what would seemingly be a boring study of Excel into a fun, practical, valuable learning experience.
The spreadsheet techniques I learned have allowed me to organize and better manage my practice's finances, employees, and overall goals.“
“My leadership team and I participated in Mike's Excel course and found him engaging and refreshingly gifted at teaching the program to a group of practice owners and managers who came to that meeting with varied prior Excel experience.
We each left the session having learned simple but effective strategies to better use Excel as intended for business management.“
“Mike’s Excel workshop helped me get more out of my data, and make better decisions. His teaching style, mastery, and humor makes learning Excel surprisingly easy!“
“Michael was incredibly funny, engaging, and exceptionally fluent in Excel. What he was able to show us in a few hours was remarkable and extremely helpful. Every business owner who uses excel (and they should),would benefit from his classes.“
No. Unless you took Michael's class before, you need the Essentials class.
In fact, you probably learned to use Excel the way most people do - the wrong way. You've probably been using Excel incorrectly for years. Yes, this is class covers VLOOKUPS and Pivot Tables. More importantly, this class teaches you how to actually design functional spreadsheets that don't become a MESS.
Start with the Essentials class or you'll be lost in the later classes.
Yes, but as mentioned above, these classes are meant to be taken in order, and if you don't, you'll most likely be lost. The knowledge in Part 2 and Part 3 build on the previous classes.
Yes. BEFORE you purchase tickets, fill out the contact form or email XXXXXXXXX we'll happily provide you with a discount code.
Yes, the event is 100% live. We also encourage you to have your camera and microphone on during the ZOOM call so you can ask questions during class. This is not meant to be a passive workshop. We love questions! You are also free to simply observe the class without turning on your camera/mic.
You will receive a recording of the class afterwards so you can review the material.
1.) Press the "BUY TICKET" button on this site. It will take you to a purchase page (100% secure and provided by ZOOM).
-When buying a ticket, it will ask you to log in to your ZOOM account. Be sure to use this same account when you attend class!
-If you are registering a group of students, be sure to use the email addresses associated with their ZOOM accounts!
3.) On the day of the course, simply open the confirmation email and click the "view ticket"button. It will prompt you to log in to:
From there, you can join the meeting.
4.)After class, this same portal (on.zoom.us) will allow attendees to view a recording of the class.
5.) If there is any confusion, email us:
Each course is 6 hours long, which takes place over 2 separate 3-hour sessions. (Tuesday 2-5pm, and then Thursday 2-5pm, for example).
The class will be live on Zoom. Questions are encouraged. Example files and datasets will be provided before class (via email)
Yes. Part 1 and Part 2 are 100% Mac compatible. Part 3 covers SOME features that work on the latest version of Mac for Excel (Power Query), but Power Pivot and Power BI are only available on Windows.
If you're serious about using Excel, you'll eventually want to get a windows computer ($400 laptop is fine) because Microsoft purposely makes the best features only available on the Windows version. You can imagine why.
NO. Michael is famous in the Excel training world primarily because he's so good at making Excel feel easy. Michael has a very down-to earth teaching style. See our reviews.