The solution is NOT to simply learn the features in Excel. The key, as you probably guessed from reading above, is in learning how to DESIGN SPREADSHEETS PROPERLY. Yes, by learning a few key principles, you can transform your spreadsheets from MESSY DISASTERS into elegant tools, dashboards, and templates that actually solve problems!
Building proper spreadsheets requires a certain discipline that does NOT come naturally to most people. If it did, everyone would be a great spreadsheet designer. Using Excel the right way also requires you to actually learn some shortcuts so you’re not wasting time fiddling with the mouse when you could have pressed F2.
There are over 500 shortcuts in Excel. There are hundreds of functions in Excel. And just like painting a picture, there are millions of ways you can design a spreadsheet. How do you know where to start?
Lucky for you, I figured it out. I have packed all of this knowledge into a 4 hour course! I’m not kidding. It turns out that you don’t need to learn all of the features in Excel to understand the principles of proper design. You only need to focus on the most important 5% of Excel. Shortcuts, VLOOKUPs, Pivot Tables, and a handful of key concepts. You will use these same tools 95% of the time! They call this the 80/20 but in Excel it’s more like 95/5.
That’s why my course is just 4 hours. Not 10 hours. Not a huge book that you will never read. Just 4 HOURS. Let’s face it. If it was 20 hours- it would just be TOO DAMN LONG. And you probably wouldn’t even want to do it. I also would not want to be speaking for 20 hours! I’d much rather be sitting at a blackjack table slamming an EXTRA DIRTY martini. In fact, my #1 rule in class is to never work. Say it to yourself:
Good, you’re already learning the first lesson in class. Why work if you can set up a template to do your work for you? I have countless clients whose lives have been transformed because I turned their job into a BUTTON. They push the button, it opens up a template, it processes their data, it saves a new colorful sexy dashboard as a PDF file, it opens Outlook, sends it to their boss… and they can spend their extra time doing things that are actually important. Like CHILLING.