How to Learn Excel on Your iPhone (and Actually Remember It)
Yes, you can learn Excel on an iPhone. What works on a small screen, what doesn't, and a simple routine to build real formula skills in minutes a day.
By Ayoub Farid · · 3 min read
You probably have more five-minute gaps in your day than free evenings. A commute, a queue, a lunch break. If you could turn those into Excel practice, you'd be job-test ready in weeks instead of "someday".
The good news: formulas are one of the few Excel skills that work well on a phone. Here's how to do it without fighting the small screen.
What you can and can't learn on a phone
Works well on iPhone:
- Formulas and functions: SUM, AVERAGE, IF, COUNTIF, lookups
- Cell references, ranges and $ locks
- Reading a sheet and spotting errors
- Building the habit of thinking in cells instead of numbers
Better on a computer:
- Pivot tables and charts with lots of options
- Long data-entry sessions
- Macros and Power Query
- Keyboard shortcuts (you'll need a keyboard to practise those)
Formulas are also what job tests and day-to-day work lean on most, so the phone covers the part that matters most.
Three ways to practise Excel on iPhone
1. The Microsoft Excel app
Excel for iPhone is free for basic editing on smaller screens. Open a blank workbook, type a few numbers and practise writing formulas. Tap the formula bar, type =SUM(, then tap and drag over cells to insert the range.
The catch: nobody tells you whether your formula is right, or why it's wrong. You need to bring your own exercises. Our Excel practice exercises give you some with answers.
2. Google Sheets on iPhone
The Google Sheets app works the same way and is free. Most beginner formulas are identical, so practice transfers. See Excel vs Google Sheets formulas.
3. A learning app built for the phone
Typing =SUM(B2:B13) on a phone keyboard means switching between letters, numbers and symbols constantly. Learning apps get around this.
In Cellio, you tap a cell to add it to the formula and tap another to make a range. The keys for brackets, colons and $ are right there. Each lesson takes about two minutes, and every answer is calculated on the sheet and re-checked on hidden data, so a formula only passes if it really works.
A 10-minute daily routine
- 2 minutes: review yesterday's formula from memory. Write it in a blank sheet.
- 5 minutes: one new lesson or one new function.
- 3 minutes: use it on something real, like your budget, a shopping list or your step count.
Consistency matters more than session length. A streak of short sessions beats a weekend binge. The 10-minutes-a-day plan gives you a week-by-week order.
Tips for the small screen
- Turn your phone sideways in Excel or Sheets to see more columns.
- Name your columns clearly in row 1. It helps you read formulas later.
- Zoom out to see the shape of the data, zoom in to edit.
- If a formula is long, build it in pieces in separate cells first.
Frequently asked questions
Is the Excel app free on iPhone?
Microsoft offers Excel for iPhone free for core viewing and editing on devices with smaller screens. Some advanced features need a Microsoft 365 subscription.
Can I really learn Excel on a phone?
You can learn formulas, references and how to think in a spreadsheet. For pivot tables, charts and shortcuts, add some computer practice later.
How long should I practise each day?
Ten minutes a day is enough to make steady progress if you practise writing formulas, not just watching videos.
Does Cellio need Excel installed?
No. Exercises run on a spreadsheet inside the app with its own formula engine.