I Tried To Learn 500 Excel Formulae (TAKE THE TEST!)
With the new Excel formula releases coming soon, there will be more than 500 formulae in Excel. Yes, 500! But, does the typical professional need to know all of them?
In today’s video, I explain how I have been learning new Excel formulae, show you the custom Excel VBA tool I have used to help me, and help you prioritise the formulae you do and don’t need to know. CLICK HERE TO WATCH THE VIDEO
If you’re looking to learn new Excel formulae, you’re going to love the Excel Formula Quiz tool. As I demonstrate in the video, using only Excel on your desktop, you can test your knowledge of formulae and gradually build your Excel vocabulary. Got a colleague who is using Excel too? Why not share the file with them and settle once and for all who the better Excel user is?!
Seriously, the Formula Quiz tool has helped me build my Excel formula vocabulary recently in a fun an interactive way. You’re going to love it, and it’s available for download absolutely free here:
FREE DOWNLOAD: Excel Formula Quiz Tool Oh, and if you’re interesting in how I built it, I’ve created a 2-hour walkthrough video as part of our free Excel VBA Building Blocks course, check it out!
So, do you need to know 500 Excel formulae? The truth is, probably not. You’ve heard me say many times on the channel that there’s a subset of formulae and techniques you need to know – I cover them in my Excel Cheatsheet which you can download here.
The concept of ‘category’, however, could help you find a path through this forest of Excel functions! Microsoft categorises the formulae according to their usage – Lookup and Reference, for example, contains VLOOKUP and its friends. Other categories relate to specific vocations such as Engineering.
As I explain in the video, if you’re not a specialist in one of the categories (eg. A mathematician or finance specialist), I suggest focusing on the first five categories only. They comprise around 100 formulae and will give you a very firm foundation in Excel and data analysis. Don’t learn them all, however! Perhaps pick a few from each category to get started, then let the utility of the new formulae guide your learning … Or, simply download the Excel Cheatsheet to access the specific subset of Excel formulae and techniques that I recommend.
At the very least, I hope you’ll download the Excel Formula Quiz tool and have a go! Let me know how you get on in the YouTube comments and let’s start a conversation there.
