Advanced Excel tricks

Smart Excel Pivot Table Trick - Choose Your KPI from Slicer (Excel Dashboard with DAX)New!!

If you've used pivot tables and pivot charts in Excel before, you know that you can do something like this: you could create a pivot chart that breaks down total quantity by company. You could even go ahead and add a slicer and break this down further by product, for example. But what if you wanted your quantity […]