Top Ten Excel Formulas and Functions - IF, VLOOKUP, PMT, INDEX MATCH - Excel Tutorial
Simon Sez IT via YouTube
Lead AI-Native Products with Microsoft's Agentic AI Program
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
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