Practical Excel & Power BI Learning Resources

Learn the difference between Excel’s CLEAN and TRIM functions, when to use each one and how to combine them correctly. Download the free workbook to practise with the included examples.

Learn how to use INDEX MATCH in Excel to build a reporting template that turns a full system export into a clean manager report with selected KPIs.

PivotTables are one of the most useful tools in Excel for summarising and analysing data quickly. But if you are new to PivotTables, they can feel confusing at first. You may wonder where to place fields, why Excel sometimes uses SUM and sometimes COUNT, or how to turn a PivotTable into something useful for real analysis. That is why I created this PivotTables Tutorial Series. In this series, I walk through the fundamentals step by step using a simple sales dataset, so you ca

Excel suddenly showing numbers instead of letters? If your Excel suddenly looks like this: Columns are numbers (1, 2, 3…) instead of letters (A, B, C…) Cell references show R1C1 instead of A1 Don’t worry — your Excel is not broken. It may have switched to Excel R1C1 reference style. ⚡ Quick Fix (Back to Normal in Seconds) To switch Excel back to A1 style: Go to File Click Options Select Formulas Uncheck “R1C1 reference style” Click OK ✅ Your Excel will go back to normal immed

Excel can already filter text that contains a keyword…but what if you didn’t have to do it manually every time? For example, your data might include values like “Apple”, “Green Apple”, or “Apple Juice”. While the standard filter can find these, you need to reapply it each time — and it doesn’t update dynamically. In this guide, you’ll learn how to create a more flexible solution using an Excel filter that contains text formula, so your results update instantly based on a keyw

Comparing daily data can be misleading. For example, a Monday usually behaves differently from a Sunday, so comparing them directly may lead to the wrong conclusion. A better approach is to compare the same weekday across different weeks. For example, comparing all Wednesdays in the past few weeks. In this post, I’ll walk through 3 different methods to compare the same weekday across weeks in Excel. Each method can work well depending on the workflow and reporting needs. Thes

Here's an example of a Pivot Table, and I want to automatically filter the past 30 days whenever I update the raw data and refresh it. So here's the sample raw data of stores sales for the above Pivot Table from May 2024 until June 2024. To make it filter the past 30 days data in the Pivot Table, this is how I do it: At the raw data: Add an additional column to check on whether the date is within the past 30days period. The Formula goes like this: =AND([@Date]>=(TODAY()-30),[