Microsoft Excel learning centre

Microsoft Excel Practical Tutorials

Choose a practical Microsoft Excel task below. Check the guide’s version, prerequisites and verification notes before following the steps.

For individual formulas, browse the Microsoft Excel function directory.

10 practical tutorials

CSV and text import

Import UTF-8 Semicolon CSV in Excel 2013 Without Broken AccentsChoose the source encoding and semicolon delimiter explicitly, preserve empty fields and codes, then verify accented text and decimal-comma amounts.Intermediate · Microsoft Excel

Date and time analysis

COUNTIFS Missing Timestamped Records? Count the Whole DayBuild numeric timestamps, diagnose midnight-only matches, and count daily or multi-day windows with an exclusive next-day boundary.Intermediate · Microsoft Excel

Dynamic arrays and tables

Excel #SPILL! Inside a Table: Keep the Table, Move the FormulaUse a growing Excel table as a FILTER source while placing the spilled result outside it. Diagnose table restrictions separately from blocked output cells.Intermediate · Microsoft Excel

Formula troubleshooting

Why Excel 2013 Formulas Stop Updating After Another Workbook OpensDiagnose calculation mode inherited from the first workbook, reproduce it safely with two small files, and restore automatic updates.Intermediate · Microsoft Excel

Import and data cleanup

Keep 16-Digit Tracking Numbers Intact in Excel 2013Import long identifiers as text before Excel changes their digits, verify exact matches, and recover safely from a damaged import.Beginner · Microsoft Excel Stop Excel 2013 Swapping Day and Month in CSV DatesChoose the source date order during CSV import, verify day and month separately, and recover dates without guessing.Intermediate · Microsoft Excel

Lookup and extraction

Return Every Matching Row in Excel 2013 Without FILTERUse a visible row-position helper with INDEX and SMALL to return all matches, preserve duplicates and zero values, and check the result when the selector changes.Intermediate · Microsoft Excel

Pivot tables and analysis

Excel PivotTable Missing New Rows? Fix the Source and RefreshBuild and check a sales PivotTable, diagnose a fixed source range, and switch to an expanding Excel table so new records are included after refresh.Intermediate · Microsoft Excel

Power Query and data imports

Fix Power Query Formula.Firewall Without Disabling Privacy ChecksIdentify the Firewall error category, inspect only the relevant data sources, and separate source queries from a synthetic file-combination query.Intermediate · Microsoft Excel

Printing and PDF output

Excel Prints Blank Pages After Deleting Data: Find the CauseSeparate an oversized print area from leftover formatting, safely reset the last used cell, and verify the pages without deleting working formulas.Intermediate · Microsoft Excel