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 i

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 key

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. T

Creating a comprehensive calendar table is crucial for time-based analysis in Power BI. Here are 15 essential DAX functions to enhance...

Transforming raw data from the left to the one on the right where the data is split nicely into each column. Let's look at the raw data,...

Having leading zeros is crucial when a standard data length is necessary. Here is a sample Calendar table featuring columns for Date,...

Below is a screenshot of time in Second format and in Minutes format. I'm going to show you to convert them into mm:ss format. Second to...

Transforming table on the left to table on the right. Let's look at the blue table below first, it can be seen that the Date column (to...

When appending tables in Power Query, the M code used looks something like below: =Table.Combine({Table1, Table2, Table3}) The problem...

Here's an example of ever changing headers where the dates are the headers of the data, basically means the headers change every month or...

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...

Imagine your boss giving you a dataset like below table and wanting you to include it in the Power BI dashboard and at the same time...

Calendar table is pretty useful as it can link different data sources to produce a consolidated reports or dashboards. For example, in...

Before diving into the steps for date formatting, we need to understand what is locale. Locale is used to display and identify the data...

During my initial days of transitioning to the data analysis field, I used to think that the most crucial part was the ability to use all...

This project is to create a dashboard in Excel to analyse Netflix Userbase. In this blog post, I'll show you how I did it. This is the...