Loads of FREE content on Microsoft Office Training

Monthly Archives: October 2016

Archive of posts published in the specified Month


Filter Columns in a Microsoft Excel List

Another AWESOME question from a student in one of my courses on Udemy. QUESTION: How can you create VBA code that will hide columns in an Excel list, based on cell values? Imagine you have a list within Excel that contains monthly data.…


Create an Excel PivotTable Based on Multiple Worksheets

It’s been a while, but I am back again with another EXCELLENT question from a student in one of my Excel courses on Udemy. Question: How canĀ I merge several worksheets and make one Excel PivotTable? ANSWER: Imagine you have an Excel Workbook that…

Subscribe to Blog via Email

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