Excel Shortcut of the Week: Ctrl+E Flash Fill
Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use…
Read article →Category Archives: Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained
Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus…
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →VBA String Functions: Left, Mid, InStr, Replace, Split and More
VBA String Functions: Left, Mid, InStr, Replace, Split and More
Clean and reshape text in Excel VBA with Left, Right, Mid, Len, InStr, Replace, Trim, UCase, Split and Join — with real data-cleaning examples.
Read article →VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
VBA Error Handling and Debugging: On Error, Breakpoints and the Immediate Window
Handle errors in Excel VBA properly with On Error GoTo, find bugs with breakpoints, Watch and the Immediate window, and write comments that help.
Read article →VBA Loops Explained: For, For Each, Do While and Do Until
VBA Loops Explained: For, For Each, Do While and Do Until
Learn every Excel VBA loop — For…Next, For Each, Do While, Do Until — when to use each, how to exit early, and how…
Read article →5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
5 Handy VBA Macros: Mod, Second Highest, Sum by Colour and Delete Blank Rows
Five small, useful Excel VBA macros explained: the Mod operator, finding the second highest value, summing by cell colour, deleting blank rows and highlighting…
Read article →Decisions in VBA: If…Then, And/Or and Select Case
Decisions in VBA: If…Then, And/Or and Select Case
Make Excel macros decide: If…Then…ElseIf, logical operators And/Or/Not, and Select Case — with real examples and common mistakes.
Read article →Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Cells with VBA: Fonts, Colours, Borders and Number Formats
Format Excel cells from VBA: fonts, fill colours, borders, number and date formats, alignment and conditional formatting — with copy-paste examples.
Read article →Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Working with Ranges in Excel VBA: Cells, Offset, Resize and More
Everything you need to read and write cells in Excel VBA: Range vs Cells, Offset, Resize, CurrentRegion, rows and columns — with practical examples.
Read article →Excel VBA Variables and Data Types: A Practical Guide
Excel VBA Variables and Data Types: A Practical Guide
Learn how to declare variables in Excel VBA, choose the right data type, use Option Explicit, and avoid the mistakes that cause type mismatch…
Read article →Conditional Formatting with Formulas: 10 Rules Worth Knowing
Conditional Formatting with Formulas: 10 Rules Worth Knowing
Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.
Read article →