Learn essential Excel formulas and functions in this comprehensive 52-minute tutorial. Master the basics of SUM, AVERAGE, MIN, MAX, and COUNT before progressing to more advanced concepts like absolute vs. relative referencing, text functions, IF statements (including nested IFs), PMT for loan calculations, VLOOKUP, HLOOKUP, and INDEX MATCH. Follow along with downloadable practice files to enhance your Excel skills from beginner to intermediate level. Gain practical knowledge of the most crucial functions among Excel's 500+ offerings to efficiently manage spreadsheets and data analysis tasks.
Top Ten Excel Formulas and Functions - IF, VLOOKUP, PMT, INDEX MATCH - Excel Tutorial
Simon Sez IT via YouTube
Overview
Syllabus
- Introduction
- SUM:
- AVERAGE:
- MIN:
- MAX:
- COUNT:
- Absolute vs Relative Referencing:
- Text Functions:
- Simple IF statements:
- Nested IF functions in Excel:
- Using PMT to calculate loan payments:
- VLOOKUP in Excel:
- HLOOKUP in Excel:
- INDEX MATCH Excel:
Taught by
Simon Sez IT
