Top 10 Excel Formulas for Analysts

on YouTube ↗57m

" summary

Live demos in Excel 2013 show ten core techniques with concrete results: relative/absolute/mixed references and named/structural table references that auto-update when rows are added, a SUMIFS instead of VLOOKUP pattern to return 0 rather than #N/A, INDEX+MATCH to find the region for the 3rd-largest sale (115), SMALL/LARGE for nth values, text functions (LEFT/RIGHT/MID/FIND/LEN/&) to extract zip or door numbers, date arithmetic and WORKDAY/NETWORKDAYS, logical AND/OR/NOT, and IFERROR to suppress errors.

AI-written summary · about

" chapters (11)

1. 0:00Welcome
2. 1:04Cell references in Excel
3. 15:37SUMIFS formula
4. 23:35VLOOKUP for data
5. 31:24INDEX and MATCH
6. 36:26Nth smallest/largest values
7. 40:15Text processing formulas
8. 47:00Dates and times in Excel
9. 51:46Logical conditions AND OR NOT
10. 53:56Handling errors
11. 55:00Top 10 summary

" related talks

• 01h 00mMastering the CUBE Functions in Excel 2013Peter Myers · PASS Business Analytics Conference 2013
• 01h 01mDark Matter: Domain Experts & Nextgen Spreadsheets Are Our FutureRob Collie · PASS Business Analytics Conference 2013
• 16mEXCELsioR!Cesaire Tobias · satRday Johannesburg 2019
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 18mBold indicates negative?Luis D. Verde Arregoitia · posit::conf(2025)
• 51mUnderstanding window functions in DAXMarco Russo · SQLBits 2024
• 20m20 Power BI tips in 20 minutesMatt Lakin · SQLBits 2024
• 01h 03mFrom Data to Insight – Views from Microsoft FinanceMarc Reguera · PASS Business Analytics Conference 2013