Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
If you use Excel PivotTables then you’re probably familiar with the need to consolidate data from multiple tables into a single table before you can Pivot it. One way to do this is using VLOOKUP or INDEX & MATCH formulas to bring columns from one table into another. However, in Excel 2010 onwards we have …
If you attended my Excel Dashboard webinar with Power Query and Power Pivot this past week, you’ll have seen how easy it is to build interactive dashboard reports with these amazing new tools. If you missed it, you can catch a replay on the Excel webinars page. Scroll down to the second webinar which includes …
Unfortunately there’s no built in way to calculate the median in a PivotTable. The approach is different depending on whether you’re using a regular PivotTable or a Power Pivot PivotTable. We’ll look at both options in this tutorial. The Data The data we’ll be using in this example is in an Excel Table called Table1: …
Excel PivotTable Named Sets enable you to pick and choose which columns or rows you want included in your PivotTable report, but there's a catch. They require you to use Power Pivot to create your PivotTable. Don't worry, it's so easy you won't even realise you're using Power Pivot. Note: Named Sets are only available …
