Blog

Excel, explained for work

Practical guides to the formulas and skills that come up at work and in job tests. Every article links to a lesson where you can practise it.

• Interviews10 Excel interview questions you should be ready forThe Excel questions that come up again and again in job interviews and tests, with the answers and the formulas behind them.
• DatesHow to calculate age in Excel (years, months and days)Work out someone's age from their date of birth in Excel, in whole years, as years and months, or as a decimal, with formulas that stay correct every day.
• CareersHow to prepare for an Excel test for a jobWhat pre-employment Excel tests usually cover, how they are scored, and a one-week plan to get ready.
• FormulasSUMIF vs SUMIFS: what's the difference?When to use SUMIF and when to use SUMIFS in Excel, why their arguments are in a different order, and the mistakes that trip people up.
• LookupsVLOOKUP vs XLOOKUP vs INDEX MATCH: which should you use?A plain comparison of Excel's three main lookup methods, with the same example solved each way and a simple rule for choosing.

RSS feed