The "Life Or Death" Excel Essentials Class
(LIVE ZOOM Online class)
I will cover the essential shortcuts, formulas, and design techniques you must master to actually make Excel not suck. VLOOKUPS, Pivot Tables, and all. Start with this class or you'll be lost.
Upcoming Classes: Summer 2023
Note: each class totals just over 4 hours, meeting for 2 hours Tuesday & 2 more hours on Thursday
Time zone: Eastern Time (US & Canada)
What I Cover:
-
Design - The Most Important Part
How to design a workbook that doesn't become a MESS once you start updating it. We'll also use magical tables that "grow" when you add larger datasets. Yes, this class teaches you how to use Excel, but more importantly, this class teaches you how to actually design proper spreadsheets. Almost nobody knows this part. Because nobody knows Excel. Read more about that here.
-
The Shortcuts
There are over 500 shortcuts in Excel but you only need to know less than 20 of them! Using shortcuts quadruples your speed. If you practice right ones, you'll become a ninja.
-
Writing Slick Formulas
The formulas should be doing the work, NOT YOU! Most importantly they should be EASY to read. Yes, Excel does more than allow you to put stuff in boxes!
-
VLOOKUPS
They're so useful and almost NOBODY in your office can do them! Once you realize how easy they are, you'll be the Excel STUD of your team. You'll wonder how you used Excel without it.
-
IF Functions
It's only the MOST IMPORTANT function ever. This gives the formulas the ability to make decisions. This is when Excel becomes powerful.
-
SUMIF and COUNTIF
The easiest way to get a "subtotal" from a large data set without making a Pivot Table is to use COUNTIF and SUMIF. You should never have to sort your data to figure out a subtotal! I bet MAXIF and AVERAGEIF work the exact same way....
-
The Easy Way to make Pivot Tables
If you're not using Pivot Tables to summarize you're data, you will DIE once you realize how much unnecessary work you've been doing. Pivot Tables are the best way to summarize your data.
-
And More...
I knew I was supposed to say "And MORE" so there it is. Bla bla, bla, bla bla. Yes, we'll even learn more. Stop putting it off and register!
The Next Class Starts In:
Can't Make It To Class?
Get email updates on upcoming LIVE online classes and events.
Meet Your Guru
Excel Mike
Founder, Easy Learning Labs
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 JP Morgan, Cole Haan, Kate Spade, RBC, TripAdvisor, Goldman Sachs and Spotify, and SoulCycle.
Michael's teaching style is highly unconventional, wildly entertaining, and may induce learning. He holds a bachelor's degree from NYU.
I've seldom learned as much while laughing (or laughed as much while learning). Mike's class is brilliant and, no matter your skill set, age or profession, you simply cannot find a better teacher. Highly recommend checking him out. You'll quickly realize that it's one of the best investments you'll make in your business and your career.
When I think about the time we've saved using the approaches we learned in Mike's class, I have to say, it's difficult to imagine a better return-on-investment. But, when I think about the clients we've impressed with the skill set honed in Mike's class, it's honestly one of our most powerful secret weapons."
Mike is a rare talent. He's patient but not condescending, he repeats without being repetitious, he's funny without shtick. In the end, you have fun while you learn more than you would anywhere else. If you want to be in the top 2% of Excel users, take his class. Don't wait. Your career may depend on it.
PJ Leary
Founder, PJL Media LLC
FAQ
-
Is this class really live?
Yes! I will personally be hosting the class LIVE and you'll be able to see me and ask me questions.
-
How does this work online?
After you sign up we'll email you a link that will allow you to join the live class, which will be hosted via ZOOM. As long as your internet connection is good enough to watch a YouTube video, you'll have no problem viewing the live class. Once you join, you'll see my live presentation in your web browser (Chrome or Firefox or Safari or whatever you use). During class you'll have the chance the ask questions (typed or spoken through your microphone). If you don't want to use your computer's mic, you can also dial-in on a normal phone and still watch the presentation on your computer.
-
I've been using Excel for years. I need VLOOKUPs and Macros! Shouldn't I be taking your "Advanced Class"?
No. You've probably been using Excel incorrectly for years. Yes, this is class covers VLOOKUPS. And yes, we will cover the most important features in Excel. But more importantly this class teaches you how to actually design functional spreadsheets. This is something almost NOBODY KNOWS. Most people make a MESS. Read more about that here.
-
What if I registered for class but can't make it?
All registrants will automatically get an email the night after class with a video recording of the class you missed. You'll have 14 days to watch it! If you have any questions you can always email us.