New Digital Product

Stop Googling
Excel Formulas

A complete 49-slide visual guide to the 22 essential Excel formulas — with real examples, pro tips, and cheat sheets you'll actually use.

Get Instant Access See what's inside ↓
49 Slides
22 Formulas
∞ Use Forever
MASTER EXCEL FORMULAS
The Complete
Guide to Excel
Formulas
22 Formulas • Examples • Tips
1
SUM
=SUM(number1, number2, ...)
=SUM(A1:A9)
SECTION 02
Referencing
Formulas
INDEX • MATCH • VLOOKUP
Quick Cheat Sheet
SUM
=SUM(A1:A9)
AVG
=AVERAGE(B:B)
IF
=IF(A>5,"Y","N")
VLK
=VLOOKUP(...)
CNT
=COUNTIF(A,">0")
TXT
=TEXT(A,"MMM")

Preview of 4 slides from the 49-slide guide

Contents

Everything in
one guide

5 sections covering every formula you need — from basics to advanced lookups.

01
Core Calculation Formulas
The 6 formulas every Excel user must know cold. With examples for each.
SUMAVERAGEROUNDMINMAXCOUNT
02
Referencing Formulas
Master lookups and references — the skill that separates beginners from pros.
INDEXMATCHVLOOKUPXLOOKUP
03
Conditional Calculations
Count, sum, and average based on conditions. The core of data analysis.
COUNTIFSUMIFIFAVERAGEIF
04
Logical Operators
Combine multiple conditions with AND/OR to build powerful decision formulas.
ANDORNOTTruth Tables
05
Output Format Management
Format, clean, and combine text like a data professional.
CONCATENATEMIDTEXTIFERROR
★
Bonus Reference Slides
Shortcuts, error fixes, best practices, named ranges, dynamic arrays, and a full cheat sheet.
Cheat SheetShortcutsErrorsRoadmap

22 Formulas

Every formula
explained clearly

Syntax, real examples, what the result looks like, and 3 pro tips — per formula.

Formula 01
SUM
=SUM(A1:A9)
Add all numbers in a range. The most-used function in Excel.
Formula 09
VLOOKUP
=VLOOKUP(G1,H1:I10,2,FALSE)
Search for a value in the first column of a table and return a result.
Formula 11
XLOOKUP
=XLOOKUP(A7,A2:A4,B2:C4)
The modern replacement for VLOOKUP — looks in any direction.
Formula 15
IF / Nested IFs
=IF(R1>5,"Yes","No")
Test a condition and return different values. The cornerstone of logic.
Formula 14
SUMIF / SUMIFS
=SUMIF(P1:P9,">5")
Add only the cells that meet your conditions — essential for reports.
Formula 22
IFERROR
=IFERROR(W1, 0)
Return a custom result instead of #DIV/0! or #N/A errors.

Bonus Content

Way more than
just formulas

Packed with bonus slides that turn this into a full Excel reference guide.

⚡
Keyboard Shortcuts
10 essential shortcuts that make you 2× faster in Excel instantly.
🔴
Error Decoder
Every Excel error explained with exact fixes: #DIV/0!, #N/A, #REF! and more.
📊
Cheat Sheet Slide
All 22 formulas with examples on one slide. Print it, save it, use it daily.
🗺️
Learning Roadmap
A clear week-by-week path from Beginner to Excel Expert.
🔗
Dynamic Arrays
FILTER, SORT, UNIQUE, XLOOKUP — the future of Excel explained.
✅
Best Practices
Do's and Don'ts that separate amateur spreadsheets from professional ones.

Reviews

What people
are saying

★★★★★
I've watched hundreds of Excel tutorials but nothing stuck until I had this guide. The visual layout makes everything click — I finally understand VLOOKUP vs XLOOKUP.
👩
Sarah K.
Financial Analyst
★★★★★
The cheat sheet slide alone is worth 10x the price. I have it printed above my desk. The pro tips section taught me things I didn't know after 5 years of using Excel.
👨
James M.
Operations Manager
★★★★★
I bought this for my whole team. We went from spending 2 hours on reports to 30 minutes. SUMIFS and COUNTIFS changed everything for us. Highly recommend.
👩
Maria L.
Marketing Director

Get the Guide

One guide.
Excel forever.

Instant download. Use on any device. No subscription.

Complete Excel Formulas Guide
Master Excel Formulas
49-slide visual guide by msexcelforyou
  • ✓ 49 professionally designed slides
  • ✓ All 22 essential Excel formulas covered
  • ✓ Syntax + examples + pro tips for each
  • ✓ Full cheat sheet & keyboard shortcuts
  • ✓ Common errors decoder with exact fixes
  • ✓ Bonus: Dynamic arrays, date formulas, text functions
  • ✓ Instant download — yours forever

🌍 Price automatically adjusts for your country  ·  Indian buyers may see a lower price at checkout

Get Instant Access →

🔒 Secure checkout via Gumroad

📊
msexcelforyou
@msexcelforyou on YouTube

About

Made by an Excel obsessive,
for real people

I created msexcelforyou because most Excel content is either too boring or too complicated. My goal is simple: make Excel click for anyone, no matter where they're starting from.

This guide is everything I wish I had when I was learning. Every formula explained in plain English, with the examples that actually make it stick.

Subscribe on YouTube

FAQ

Questions answered

The guide is a .pptx (PowerPoint) file. You can open it in Microsoft PowerPoint, Google Slides, LibreOffice, or Keynote. You can also export individual slides as PDFs or images.
Most formulas work in Excel 2016 and later. XLOOKUP and dynamic array functions (FILTER, SORT, UNIQUE) require Excel 365 or Excel 2021 — these are clearly noted in the guide.
Absolutely. The guide starts from SUM and AVERAGE and progressively builds to advanced functions. The learning roadmap slide helps you know exactly where to focus first.
Personal and team use is welcome — many people buy one copy for their whole team. Please don't resell or redistribute it publicly as your own product.
Gumroad sends you an email with an instant download link immediately after payment. You can re-download it anytime from your Gumroad library.