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 ...')

📊DOWNLOAD THE EXCEL FILE AND WORK ALONG WITH ME
https://tinyurl.com/bd9effdv

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!

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 ...)
   • XLOOKUP For Beginners (And Why I'm Sc...  

🔥EXCEL FREQUENCY FORMULA TUTORIAL
   • Make Your Excel Data Chartable With T...  

🔥HOW TO USE THE INDIRECT FORMULA IN EXCEL
   • When You SHOULD Use INDIRECT  

🔥INTRODUCTION TO DYNAMIC ARRAY FORMULAE IN EXCEL
   • Excel Dynamic Arrays 3 Years On - Hav...  

🔥EXCEL MOD FORMULA TUTORIAL
   • Complete Manual Excel Tasks In Second...  

📺PLAYLIST: Become An Excel Analyst In 30 Days
   • 30 Day Excel Analyst (COMPLETE COURSE)  

📺PLAYLIST: Learn Excel VBA In Around An Hour
   • Learn Excel VBA Quickly With These 10...  

📺PLAYLIST: 30 For 30 Excel VBA Beginner Course
   • Learn Excel VBA In 30 30-Minute Sessi...