Excel: 50 Essential Formulas Crash Course

Learn 50 of the most widely used Excel formulas in just 50 minutes with a focused, hands‑on crash course designed for beginners and busy professionals. You’ll quickly build confidence using the formulas that appear in real jobs, reports, and interviews.

What you’ll learn

By the end of this course, you will be able to:

• Use core Excel formulas to analyze and summarize data quickly

• Apply financial functions like PV, FV, NPV, PMT and PPMT to common business scenarios

• Look up and combine data with VLOOKUP, HLOOKUP, INDEX, MATCH and INDEX‑MATCH

• Build smart logic in your sheets using IF, IFS, IFNA, IFERROR, OR and AND

• Perform fast calculations with SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, ROUND, ROUNDDOWN and ROUNDUP

• Clean and format text using CONCAT, UPPER, PROPER, LOWER, LEN, REPLACE, SUBSTITUTE, LEFT, RIGHT, MID and TRIM

• Work confidently with dates and times using NOW, TODAY, DAY, MONTH, YEAR, TIME, HOUR, MINUTE and SECOND

Course content & structure

This course is organized into six clear sections so you can learn and review formulas by type:

• Financial functions: PV, FV, NPV, PMT, PPMT

• Lookup & reference: VLOOKUP, HLOOKUP, INDEX, MATCH, INDEX‑MATCH

• Logical functions: IF, IFS, IFNA, IFERROR, OR, AND

• Math & trig: SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, ROUND, ROUNDDOWN, ROUNDUP

• Text functions: CONCAT, UPPER, PROPER, LOWER, LEN, REPLACE, SUBSTITUTE, LEFT, RIGHT, MID, TRIM

• Date & time: NOW, TODAY, DAY, MONTH, YEAR, TIME, HOUR, MINUTE, SECOND

Each video lesson walks you through clear examples using a downloadable Excel project file so you can follow along and practice in real time.

How you’ll learn (hands‑on approach)

• Follow along using the included Excel practice workbook

• See each formula demonstrated step by step, then try it yourself

• Take a quick quiz after each formula to confirm you've mastered it

• Learn through short, focused explanations instead of long theory

• Rewatch any formula section quickly whenever you need a refresher

Who this course is for

This course is ideal for:

• Excel beginners who want a structured, practical introduction to formulas

• Intermediate users who know the basics but want to fill gaps and gain speed

• Professionals who use Excel at work and want to build reliable, error‑free spreadsheets

• Students and job seekers preparing for Excel‑based tests, interviews or internships

What’s included

• A 50‑minute video‑based crash course

• 50+ essential Excel formulas, grouped by category

• Quiz after every formula to test your understanding and reinforce learning

• Downloadable practice workbook to use during the lessons

• Lifetime access to all videos and future updates

By the end, you’ll be able to build clean, efficient spreadsheets using the most important Excel formulas that show up in real‑world tasks.