In this tutorial we’ll take a look at how you can use the CUBEVALUE function in Excel to allow more flexibility with laying out your PivotTables.
In this tutorial we’ll take a look at how to use the Watch Window feature in Excel. This tool is a great way to keep an eye on other areas of your workbook or even other workbooks while managing your data.
In this tutorial we’ll look at combining two different file types using Power Query to create a single table that we can then create a PivotTable from to do our analysis.
In this tutorial we’ll take a look at several features in Power Query that help you manage poorly structured data, and put it in a format to best use it with tools such as PivotTables.
In this tutorial we’ll take a look at how to combine files using Power Query in Excel. I will be using Excel 2016 which has Power Query built into the Data tab, but Power Query is available as an add on to 2010 & 2013, so make sure you add that to your version in […]
Recently I did a post on the SUBTOTAL function, but since then I learned a new feature of this useful tool. Let’s take a look at this bonus feature of the SUBTOTAL function in Excel.