Learn Excel Formulas: Offline

Zorya Tech Studio

Contains ads

About this app

Learn Excel formulas by doing, not just reading. Every short lesson ends with real tasks in a live spreadsheet grid on your phone, and the app checks your answer instantly. It works fully offline, so you can learn Excel anywhere.

Most Excel apps give you pages of text. This one gives you practice. Type a formula, tap cells to insert references, drag to select a range, press Check and see if you got it right. If not, you get a clear explanation of what went wrong: a range that stops one row too early, a missing $ sign, VLOOKUP without FALSE, or a number typed instead of a cell reference.

A COMPLETE EXCEL COURSE FOR BEGINNERS
Three free tracks take you from your first cell to job-ready skills: Foundations, Everyday Excel and Job Ready. Learn Excel from scratch at your own pace, then move on to lookups, dates, text functions and pivot tables.

WHAT YOU WILL LEARN
• Basics: cells, ranges, operators, percentages, SUM, AVERAGE, MIN, MAX, COUNT, ROUND
• Copying formulas: relative, absolute and mixed references ($A$1)
• Decisions: IF, IFS, AND, OR, IFERROR
• Conditional math: COUNTIF, SUMIF, SUMIFS, COUNTIFS, AVERAGEIF
• Lookups: VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH
• Dates: DATE, EOMONTH, NETWORKDAYS, days between dates
• Text and data cleaning: TRIM, LEFT, MID, FIND, SUBSTITUTE, TEXT
• Modern Excel 365: FILTER, UNIQUE, SORT
• Pivot tables: build your first pivot table step by step

EXCEL TEST SERIES FOR JOB INTERVIEWS
Many employers give an Excel test before hiring. Excel Test Series gives you 15 timed tasks in 15 minutes, with a 70% pass mark like a real assessment, and shows which topics to practice next. Trap drills train the classic mistakes that cost points.

PRACTICE EVERY DAY
✓ Daily challenge and streak
✓ Mistakes come back for review after 1, 3 and 7 days
✓ Unlimited drills for every topic
✓ Real-life case projects: budget, sales report, payroll, inventory, grades, marketing funnel

EXCEL FORMULAS REFERENCE
✓ 100+ functions explained in plain English with examples
✓ Try any function in a sandbox grid
✓ 61 keyboard shortcuts for Windows and Mac

MADE FOR PHONES
✓ Formula keyboard with brackets, $, colon and common functions
✓ Function suggestions and syntax hints while you type
✓ No account and no daily limits
✓ Light and dark themes
✓ 20+ languages

A practical Excel course for students, office workers and job seekers: learn Excel formulas and functions offline and get ready for an Excel test.

Formulas use standard English function names, the same as in Google Sheets and English versions of Excel.

Independent learning app. Not affiliated with or endorsed by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.

What’s new

First release! Learn Excel formulas by practicing in a real spreadsheet grid with an instant answer check. Includes 3 free tracks, an Excel job test and 100+ functions in the reference. Works offline.