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.
In this tutorial we are going to take a look at how to separate first and last names using Text To Columns, and then see how we can accomplish the same thing using Flash Fill, plus so much more! Flash Fill is only available in Excel 2013 and later (sorry for those using earlier versions).
In this tutorial we’ll take a look at the SUBTOTAL function in Excel and see how each of the 22 options available with this function work.
Recently we’ve talked about how to hide and very hide worksheets in Excel. In this tutorial we’ll look at how to hide an Excel workbook and why you may want to do that.