Excel guides and tips
Practical guides to learn Excel, prepare for MOS and ICDL certification, and use Excel at work.
-
Excel Crash Course: The 20% of Excel That Covers 80% of Your Work
An Excel crash course in ten short lessons: navigation, fast data entry, references, six key functions, tables, sorting, conditional formatting, charts, a first PivotTable and shortcuts, with exercises…
-
Excel for Small Business: 6 Practical Uses and a Step-by-Step Example
Excel for small business, in practice: cash flow, invoices and reminders, stock, budget, sales PivotTables and a one-page dashboard, with a step-by-step tracker and the signs it is…
-
Excel Pivot Table Training: A Step-by-Step PivotTable Tutorial
Excel pivot table training you can do on your own: a step-by-step PivotTable tutorial, from clean source data to slicers, calculated fields and PivotCharts, plus a progressive exercise…
-
Excel for Accounting: Reconciliations, Aging Reports and Checks
How accountants use Excel day to day: bank reconciliations with XLOOKUP and COUNTIFS, AR aging with SUMIFS, journal checks, validation, PivotTables and Power Query.
-
Excel for Finance: The Functions and Tools Finance Teams Actually Use
The Excel functions and tools finance teams rely on: NPV, IRR, PMT, Goal Seek, data tables, lookups, PivotTables, Power Query, with a step-by-step NPV example.
-
Advanced Excel Course: What It Should Cover (Skills Checklist + Self-Test)
What should an advanced Excel course cover in 2026? A complete skills checklist, a 10-task self-test and the criteria to choose a course that is worth your time.
-
Excel Certificate: Which One Is Worth It? MOS vs ICDL vs Online
MOS, ICDL or an online course certificate? Compare cost, exam format and employer value to choose the Excel certificate that fits your goal.