Loads of FREE content on Microsoft Office Training

Monthly Archives: July 2017

Archive of posts published in the specified Month


Microsoft Excel 2016 New Get and Transform feature

In my Complete Microsoft Excel Course on Udemy, Excel from Beginner to Advanced, I recorded some instruction on working with Microsoft Excel’s powerful Power Query and PowerPivot Add-Ins. When Excel 2013 was released, Microsoft made some changes and the 2 Add-Ins are no…


Creating an Excel Balance Sheet Using Format as Table

Another great question from a student in my Complete Excel training course on Udemy. Download the example file to try yourself: ExcelBalanceSheet-01


Microsoft Excel Array Formulas

Below is a quick video demonstration on Microsoft Excel Array Formulas. Arrays, simply put, are a collection of data. For example you may have a column of data in an Excel document. All those values, in range C2:C27, are a collection of data…

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.