Practical Excel & Power BI Learning Resources

In this tutorial, I’ll show you how to build an interactive Excel sales dashboard using PivotTables, PivotCharts, slicers, and timelines. We’ll start from raw sales data, review the dataset, plan what the dashboard should show, create the supporting PivotTables, and then turn everything into a clean dashboard. You can download the practice file below and follow along with the video. Download the practice file: Watch the full tutorial: Dashboard scenario In this example, we ar

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),[