Loads of FREE content on Microsoft Office Training

Category Archives

Archive of posts published in the category: Excel
Apr
19

CONTEST TIME – Microsoft Office Specialist Practice Exam

It’s time for another CONTEST! I’ve been getting a lot of students in┬ámy Udemy courses sending me message expressing interest in taking one of the Microsoft Office Specialist exams (MOS). So, I’ve decided to run a contest to help and inspire those interested.…

Feb
8

Microsoft Excel Dynamic Validation Lists

Its been a while, but I’m back with another great questions from a student in my Microsoft Excel course on Udemy. QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example; Imagine you have…

Jan
5

Excel Conditional Formatting with the MOD() Function

Another great question from a student in one of my Microsoft Excel courses. QUESTION: What are some good uses of Excel’s MOD() function? WHAT IS THE MOD() FUNCTION? Before I go into a use for Excel’s MOD() Function, let’s make sure we understand…

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

Subscribe to Blog via Email

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