Recent Posts

December 18, 2017

Microsoft Excel offers many ways to work with and analyze your data. There are loads of functions to calculate and lookup data, charts to visualize, PivotTables to quickly summarize and much more. These features, and more, combine to make Microsoft Excel a very powerfu...

October 18, 2017

I'm excited to announce that I have a new Microsoft Excel course in the pipeline. I plan on having it released before the end of Oct. 2017, called...

Microsoft Excel Data Analysis and Dashboard Reporting

Below are the first few videos introducing the course and what you...

October 5, 2017

Got another great question from a student in my Excel VBA UserForms course on Udemy.


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. How can I hide...

October 3, 2017

I just got another great question from a student in my Microsoft Excel course on Udemy.

The question deals with automating a conditional check using VBA. One way to accomplish this would be create a custom function using VBA. I put together a quick video describing the...

September 30, 2017


“Is it possible to make one validation column dependent upon choices from another validation column?”

Here’s an example;

Imagine you have 2 columns in an Excel list, one column for the Make of car entries and another column for the Model of the car entry. If a u...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb