Excel Formulas & Functions

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.