The 30 Excel Formulae You Must Know In 2024 (1-HOUR MASTERCLASS!)
With around 500 Excel formulae now available, which should you actually use, and which can you safely ignore?
In this special one-hour Masterclass video, I take you through the 30 Excel formulae I'm using frequently in my real-life analytical projects, with the aim of moving you from Excel frustration ('not another formula!') to Excel control ('I know what to use in this situation ...')
WATCH THE VIDEO HERE
DOWNLOAD THE EXCEL FILE AND WORK ALONG WITH ME
The truth is, I tried to create a 'top-40' formula video, a bit like the music chart rundown. But, I found I'm only using around 30 Excel formulae with much frequency (get it?) This surprised me: with only a fraction of what's available in spreadsheet software, you can get most jobs done. It's the 20% that drives the 80%.
Yes, I found I'm only really using around 30 Excel formulae on a day-to-day basis. They are explained in the video and timstamped below. Make sure you download the Excel download file and work along with me to learn this Excel formula toolkit yourself. I hope you'll have a look at this video today and save it for ongoing reference.
I would love to hear your thoughts on the Excel formula selections in the comments. I will get back to you there!
TIMESTAMPS :
00:00 30 Excel Formulae You Must Know!
00:04 30. LARGE / SMALL
01:49 29. XLOOKUP
03:51 28. SWITCH
06:41 27. FREQUENCY
10:23 26. SUBSTITUTE
12:26 25. AND / OR
14:19 24. TEXTSPLIT / TEXJOIN
16:21 23. ROUND / ROUNDUP / ROUNDDOWN
18:10 22. LEFT et al
20:26 21. INDIRECT
22:10 20. INDEX
25:09 19. EOMONTH
27:02 18. TEXT
28:07 17. VSTACK / HSTACK
29:40 16. VLOOKUP
31:35 15. SUMIFS et al
33:45 14. SEQUENCE
35:04 13. OFFSET
37:30 12. MOD
40:38 11. MAXIFS / MINIFS
42:33 10. MATCH
43:51 9. COUNTA
44:35 8. SUM et al
46:00 7. RAND / RANDBETWEEN
47:35 6. IF
48:50 5. FILTER / SORT
51:26 4. DSUM et al
54:21 3. ROW / COLUMN
55:11 2. UNIQUE
56:23 1. COUNTIF
WATCH NEXT
XLOOKUP For Beginners (And Why I'm Sceptical Of New Excel Formulae ...)
EXCEL FREQUENCY FORMULA TUTORIAL
HOW TO USE THE INDIRECT FORMULA IN EXCEL
INTRODUCTION TO DYNAMIC ARRAY FORMULAE IN EXCEL
PLAYLIST:
Become An Excel Analyst In 30 Days