Loads of FREE content on Microsoft Office Training
Dec
29

Hiding Excel Worksheets with VBA

Got another great question from a student in my Excel VBA UserForms course on Udemy. QUESTION: I have built and Excel UserForm that allows users to interact with worksheets within a workbook. I don’t want the users to interact with the worksheets directly.…

Dec
29

Microsoft Excel Format as Table Feature

Microsoft Excel’s FORMAT AS TABLE feature places common list commands at your fingertips and automates many Excel list features for you. Think about it for a moment… What are some Excel features you use when working with a list of records. To help…

Dec
22

Excel Experts Share the Best Excel Tips of 2016

John Michaloudis, of MyExcelOnline.com, put together a great podcast showcasing 23 of the best Microsoft Excel Tips of 2016 from 23 Microsoft Excel Experts. Click the link below to enjoy the podcast and learn some of the hottest Microsoft Excel tips. Take a…

Dec
19

Creating Interactive PivotTables with PivotTable Slicers

Microsoft Excel PivotTables are one of my absolute favorite features found in Excel. Excel PivotTables allow for relatively quick reporting on Excel list or even external data. In the below example I was able to take 800+ detailed records about customer orders and…

Dec
8

Creating a Unique Value for an Excel VLOOKUP()

Microsoft Excels VLOOKUP Function is perhaps one of the most popular, more advanced, functions. Any time the conversation turns to Excel functions, during my live Excel classes, VLOOKUP tends to be one of the more sought after topics to learn. A brief introduction…

Nov
22

Microsoft Access DSUM() Function with Multiple Criteria

Another great question from a student in my Access VBA Introduction course on Udemy. QUESTION: “Can you help me understand how to use the DSUM() function, in Microsoft Access, with multiple criteria using VBA?” If you are unfamiliar with the DSUM() function here…

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…

Subscribe to Blog via Email

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