In this tutorial we are going to use the MAX and IF functions in an array formula, along with INDEX and MATCH to extract the last date in a list of events that is less than a control date and the event related to that date.
In this tutorial we are going to see how we can create a list of worksheets in our workbook, automatically create a hyperlink to each worksheet and make it dynamic so that when we add or delete any worksheet, the hyperlinked list will automatically update.
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.