To learn Excel for your first office job in Singapore, master six things in this order: navigating a spreadsheet, IF, VLOOKUP or XLOOKUP, pivot tables, charts, and keyboard shortcuts. You can get to a work-ready level in about two weeks of focused practice, using free resources. This guide gives you the function list, the order to learn it in, and a day-by-day plan.
Most fresh grads in Singapore think they need to know hundreds of formulas. You do not. The day-to-day work in a typical first job is cleaning data someone sent you, looking up a value in a big list, summarising numbers into a one-page answer, and turning that into a chart your manager can read in five seconds. Six skills cover almost all of it.
The six Excel skills that actually matter in your first job
Here is the short version: what each skill does, and when you will reach for it at work. Learn these and you will handle most requests a junior gets without asking for help.
| Skill | What it does | When you will use it |
|---|---|---|
| Spreadsheet basics (cells, rows, freeze panes, sort, filter) | Move around a sheet, sort and filter a list, lock the header row | Every single day, the moment someone sends you a file |
| IF (and nested IF) | Returns one value when a condition is true, another when false | Flagging rows: "overdue" vs "on time", "pass" vs "fail", commission tiers |
| VLOOKUP / XLOOKUP | Finds a value in one table and pulls a matching value from another | Matching a customer ID to a name, a product code to a price |
| Pivot tables | Summarises thousands of rows into totals, counts, and averages by category | "How much did we sell per region last month?" answered in 30 seconds |
| Charts | Turns a table into a bar, line, or pie your boss reads instantly | Any report, deck, or update that goes above your manager |
| Keyboard shortcuts | Lets you work without reaching for the mouse | All day. This is what makes you look fast and feel competent |
Start here: spreadsheet basics
Before any formula, get comfortable moving around. Open a sheet, click a cell, and learn what a cell reference like B7 means. Practise sorting a list (Data menu) and filtering it so you only see rows that match a condition. Freeze the top row so your column headers stay visible when you scroll. Microsoft keeps free, plain-English guides for all of this in its official Excel help centre.
Two habits to build from day one. First, keep your raw data clean and untouched, and do your calculations in separate columns or sheets. Second, never delete the original file someone sent you. Save your version with a clear name. These two habits prevent most of the panic moments juniors have.
The functions a fresh grad must know
IF
IF checks a condition and returns one of two answers. The pattern is =IF(test, value if true, value if false). For example, =IF(C2>1000,"big","small") labels every order. You will use this to flag late payments, mark targets as hit or missed, or split data into groups. Microsoft's IF function reference has worked examples you can copy.
Looking up data with VLOOKUP or XLOOKUP
This is the skill that gets juniors noticed. You have a list of customer IDs and a separate master list with IDs and names. VLOOKUP finds each ID in the master list and pulls back the name, so you do not match them by hand. XLOOKUP is the newer, easier version that does the same thing and looks in any direction. If your office runs a recent version of Excel or Microsoft 365, learn XLOOKUP first. If it runs an older version, learn VLOOKUP. Both are documented with examples: the VLOOKUP guide and the XLOOKUP guide.
Pivot tables
A pivot table is the fastest way to answer "how much" or "how many" by category. Drop in a table of 5,000 sales rows, drag "Region" to rows and "Amount" to values, and you have a clean summary in seconds without writing a formula. This single skill turns a scary spreadsheet into a one-line answer. Follow Microsoft's step-by-step pivot table guide and build one with your own practice data.
Charts
Once you have a summary, select it and insert a chart. Bar charts compare categories. Line charts show change over time. Keep it simple, label the axes, and give it a title that states the takeaway rather than a default like "Chart 1". A clear chart is often the only part of your work a senior person actually reads.
Keyboard shortcuts
Shortcuts are what separate someone who looks slow from someone who looks like they have done this before. Learn ten and use them until they are automatic. Ctrl+C and Ctrl+V you know. Add Ctrl+Z (undo), Ctrl+S (save), Ctrl+arrow (jump to the edge of data), Ctrl+Shift+arrow (select to the edge), Alt+= (autosum), Ctrl+; (insert today's date), and F2 (edit a cell). Microsoft publishes the full Excel keyboard shortcuts list. Pick ten, print them, and stick them on your monitor.
A two-week learning plan
This assumes about one hour a day. The point is to build muscle memory on a real dataset, not to watch tutorials passively. Get one practice file (search for any free sample sales dataset, or export your own bank transactions) and work through it.
| Day | Focus | What you can do by the end |
|---|---|---|
| 1-2 | Spreadsheet basics: sort, filter, freeze panes, cell references | Open any file and move around without panic |
| 3-4 | Simple formulas: SUM, AVERAGE, COUNT, plus Alt+= autosum | Total and average any column |
| 5-6 | IF, including a nested IF for three outcomes | Flag and categorise rows automatically |
| 7-8 | VLOOKUP or XLOOKUP across two tables | Match data between lists without copy-pasting |
| 9-10 | Pivot tables: rows, columns, values, filters | Summarise thousands of rows into one report |
| 11-12 | Charts and basic formatting | Turn a summary into a clean, labelled chart |
| 13-14 | Keyboard shortcuts drill plus a mock task end to end | Clean, look up, summarise, and chart a file in one sitting |
On the last two days, give yourself a fake brief: "Here are 2,000 rows of orders. Tell me total sales per month and show it as a chart." Doing the whole thing start to finish is what proves you are ready, far more than finishing another tutorial.
Free and low-cost resources in Singapore
You do not need to pay for an expensive bootcamp to get work-ready. Start with what is free. Microsoft's official Excel help covers every function with examples, and the in-app help inside Excel itself answers most questions. For structured courses, the national SkillsFuture portal lists Excel and data-skills courses from local training providers, and Singaporeans aged 25 and above can use their SkillsFuture Credit to offset course fees. If you are still building your first CV, the government's MyCareersFuture jobs portal lets you see which roles ask for Excel so you can match your practice to real listings.
One honest point. Watching videos feels like progress but rarely sticks. Doing beats watching every time. Pick one resource, one practice file, and one hour a day, and you will be further along than someone who has bookmarked twenty courses and opened none.
How Excel fits the bigger skill picture
Excel is one of the most asked-for tools in junior office roles here, but it sits inside a wider set of abilities employers look for. If you want the full picture of what gets you hired, read our guide on the in-demand skills employers want in Singapore and the more specific list of skills employers actually notice in fresh graduates. Excel pairs especially well with clear communication: knowing the formula is half the job, explaining the answer in one sentence is the other half.
If you would rather learn this with structure and a mentor instead of alone, the free six-week FINternship masterclass covers practical workplace skills like this for Singaporeans aged 18 to 28. You can also see what the full apprenticeship involves on the apprenticeships page.
Frequently asked questions
How long does it take to learn Excel for a first office job?
About two weeks of focused, hands-on practice at roughly an hour a day is enough to handle most junior tasks. You are not aiming for expert level. You are aiming to clean data, look up values, summarise with a pivot table, and make a chart without help. Real mastery comes later, on the job.
Should I learn VLOOKUP or XLOOKUP first?
It depends on what your office uses. XLOOKUP is newer, easier, and more flexible, so learn it first if you have a recent version of Excel or Microsoft 365. If your workplace runs an older version that lacks XLOOKUP, learn VLOOKUP, because it works everywhere. Knowing both is ideal, but start with the one your office has.
Do I need to pay for an Excel course in Singapore?
No. Microsoft's official help pages and the help built into Excel are free and cover everything a beginner needs. If you prefer a structured course, the SkillsFuture portal lists options, and Singaporeans aged 25 and above can use SkillsFuture Credit to offset fees. Start free, and only pay if you want a certificate or guided structure.
Is Excel still worth learning if jobs use Google Sheets?
Yes. The core ideas transfer almost directly. IF, lookups, pivot tables, and charts all exist in Google Sheets with nearly identical logic, so learning one teaches you most of the other. Plenty of Singapore offices still run on Excel, so it remains the safer skill to put on your CV.
Pick your practice file today and start with day one. Two weeks of real reps will do more for your first job than any amount of reading. If you want guidance while you build skills like this, the FINternship masterclass is free and built for exactly this stage of your career.