Learn Excel: Formulas Offline

AppsLib

Contains ads

About this app

Learn Excel formulas, functions and keyboard shortcuts — offline, on your phone or tablet, at your own pace.
Whether you are new to Excel or just need a quick reference on the go, this app breaks down the essential Excel formulas and functions into short lessons with syntax, a clear example and screenshots — no internet, no account, no sign-in.
★ WHAT IS INSIDE
▸ Excel formulas
• Logical formulas: IF, IFS, AND, OR
• Mathematical formulas: SUM, SUMIF, AVERAGE, AVERAGEIF, COUNT, COUNTA, COUNTIF, RAND, ROUND, ROUNDUP, ROUNDDOWN
▸ Excel functions
• Text functions: CONCAT, UPPER, LOWER, PROPER, LEN, REPLACE, TRIM
• Lookup functions: VLOOKUP, MATCH, XLOOKUP
• Date and time functions: TODAY, NOW, DATE, DATEDIF, TIME DIFFERENCE, TEXT
▸ Excel keyboard shortcuts (Windows AND Mac shown side by side)
• General: open, save, close, print
• Editing: copy, paste, cut, undo, redo
• Formatting
• Navigation and selection
• Calculation
★ WHY THIS APP
▸ Offline — everything works with no data connection, on planes, trains, or in the field.
▸ Windows and Mac shortcuts side by side — no need to guess the Cmd equivalent.
▸ Focused — the formulas and functions you will actually use, not a 500-item dump.
▸ Fast — lightweight, opens in seconds.
▸ Bilingual — the app follows your device language (English or French).
▸ Search — jump straight to any formula or function by name.
★ HOW IT WORKS
Open Formulas, Functions or Shortcuts from the home screen.
Tap any item to see the syntax, a real example, and screenshots.
Use the search bar to jump straight to what you need.
★ WHO IT IS FOR
▸ Beginners learning Excel from scratch.
▸ Students preparing for a class or a certification.
▸ Job seekers who need a fast refresher before an Excel interview or test.
▸ Office workers who want the syntax of VLOOKUP or SUMIF on their phone.
▸ Mac users switching from Windows (or the other way around) who need the shortcut equivalents.
★ FREQUENTLY ASKED QUESTIONS
Q: Does this app need the internet?
A: No. Every lesson, formula, function and shortcut works fully offline.
Q: Does it include VLOOKUP, XLOOKUP, SUMIF, COUNTIF and IF?
A: Yes — with syntax, a worked example and screenshots for each.
Q: Are the shortcuts for Windows or Mac?
A: Both. Every shortcut shows the Windows key combo and the Mac (⌘) equivalent side by side.
Q: Is the app available in French?
A: Yes. The app follows your device language — English or French.