Learn Excel: Formulas & Course

Learn Excel formulas by doing: short interactive lessons, a practice spreadsheet you can type into, and real-world problems to fix. From your first =SUM to XLOOKUP, INDEX MATCH and LAMBDA, every step is built for your phone.

WHAT'S INSIDE

• 30 courses and 120 lessons, levelled from A1 beginner to B2 advanced

• A practice spreadsheet with a formula bar and 64 functions you can type and test

• 20 hands-on exercises based on real work problems

• A daily quiz, a formula cheat sheet with 86 entries, notes, saved lessons and review sessions

• An AI mentor that explains formulas, functions and error messages in plain words

• Create a custom lesson on any topic with AI

• A daily streak and reminders to keep your practice going

THE COURSE, STEP BY STEP

• Spreadsheet basics: cells, rows, columns, cell references and the fill handle

• Your first formulas: SUM, AVERAGE, COUNT, COUNTA and COUNTBLANK

• Absolute and relative references, and what the dollar sign does

• Logical functions: IF, AND, OR, NOT, nested IFs, IFS, SWITCH and CHOOSE

• Text functions: LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN, UPPER and PROPER

• Conditional math: SUMIF, COUNTIF, AVERAGEIF, SUMIFS and COUNTIFS

• Lookups: VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH and two-way lookups

• Errors: IFERROR, IFNA and what #N/A, #REF! and #VALUE! mean

• Dates, rounding, named ranges and data validation

• Advanced Excel: dynamic arrays with FILTER, UNIQUE, SORT and SEQUENCE, plus LET and LAMBDA

• Financial and statistical formulas: PMT, PV, FV, NPV, MEDIAN, STDEV and RANK

• Database functions, text cleaning with regular expressions and dashboard-style reports built with formulas

• Google Sheets: QUERY and ARRAYFORMULA

A REAL SPREADSHEET TO PRACTICE IN

The Sheet tab is a working spreadsheet on your phone. Tap a cell, type a formula, change a number and watch every formula that depends on it recalculate. A function browser explains each function and inserts it for you, and when a cell shows an error, the app tells you what went wrong. The formulas you learn work the same way in Microsoft Excel and Google Sheets, so the skills carry over to both.

EXERCISES FROM REAL WORK

Missions are short spreadsheet exercises built on problems people hit at work:

• a VLOOKUP that returns #N/A

• a total that is 400 short because some numbers are stored as text

• duplicate rows that inflate a total

• dates that won't sort

• a new column that breaks every lookup

• revenue per region per quarter with a pivot table

• a chart that exaggerates growth, and a pie chart hiding a trend

Each one asks you to find the cause and fix it, the way you would in a real workbook.

WHO IT'S FOR

• Complete beginners who want to learn formulas from the very first cell

• Students and office workers who use spreadsheets for reports, budgets and data analysis

• Anyone who wants to brush up on VLOOKUP, SUMIFS and other formulas before a test or a new job

FREE AND PRO

Learn Excel is free to download. Free learners get the full first course (Spreadsheet Foundations), a preview of every other lesson, the practice sheet with 10 core functions (SUM, AVERAGE, MIN, MAX, COUNT, IF, ROUND, VLOOKUP, CONCAT and LEN), 2 missions, and a small number of AI mentor questions each day. Learn Excel Pro unlocks all 120 lessons, all 64 sheet functions, AI help inside the sheet, all 20 missions and unlimited AI questions. Prices are shown in the app before you buy.

Learn Excel is an independent learning app. It is not affiliated with, endorsed by or sponsored by Microsoft Corporation. Excel is a trademark of Microsoft Corporation.

Privacy Policy: https://coddykit.com/privacy