Practical Excel & Power BI Learning Resources

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.

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