Loads of FREE content on Microsoft Office Training

Dynamic Excel Charts with Excel’s Offset() Function

I got another great question from a student of mine in my “Excel with Top Microsoft Excel Hacks” course on Udemy. In Lecture #24, Hack #22, I demonstrate how to use Excel’s Offset() Function to create a dynamic cell range for an Excel…


Creating Interactive Dashboards with Microsoft Power BI Desktop

If you haven’t heard of Microsoft Power BI, you’re in for a real treat. “Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly…


Microsoft Office Specialist Exam (MOS) Information

The Microsoft Office Specialist exams provide one of the best opportunities to stand out from the average Microsoft Office user. Below are some quick facts about the various Office Exams available through Microsoft Certification program. Short Blurb from the Microsoft Official MOS site.…


Passing Values to an Excel VBA Procedure

I recently got a question from a student in my Excel VBA UserForms course on Udemy.  I love it when someone is able to take the material that I’ve created, in one of my courses, and look for ways to applied the concepts…


Automate Monthly Excel PivotTables with VBA

Another great question from a student of mine on one of my favorite Microsoft Excel features, PivotTables. QUESTION: “I were to receive a huge volume of data in Excel on a monthly basis and every time I have to do a pivot table on a…



I recently helped a student of mine with automating a series of tasks within Microsoft Excel with VBA. The tasks included; Identifying from 20,000+ line items which items where still in stock. (Used a VLOOKUP to compare current list with INSTOCK items) Removing…


Create a Folder with Excel VBA

A few posts back I wrote about managing files within a local directory from within Excel using VBA. Today I came across a great question, related question, in one of the Excel LinkedIn groups I participate in. This Excel user was looking for a…


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…


Copy… Paste… with VBA

Another excellent question from a student in one of my courses on Udemy. QUESTION: … looking for VBA code to transfer data from a master list to individual files? Say a site list by manager? How would I loop thru each row of the…

Subscribe to Blog via Email

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