Loads of FREE content on Microsoft Office Training
Nov
21

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…

Nov
19

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…

Nov
14

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.…

Nov
11

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…

Nov
10

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…

Nov
7

SPEED UP EXCEL VBA PROCEDURE RUNTIME

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…

Nov
4

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…

Oct
31

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.…

Oct
26

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…

Sep
12

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.