Recent Posts

December 20, 2018

Excel has a few different ways to import data from various sources, including web content. If you visit the DATA TAB, found within the Excel ribbon, you'll find various import features.

 The GET & TRANSFORM tools provide a quick, easy and powerful method of importing da...

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 8, 2017

Using Microsoft Excel's IF() function and a sprinkle of VBA you can play a sound when a condition is met.

Chances are you may have used Microsoft Excel's CONDITIONAL FORMATTING feature.


 In the above example, cell A2 is conditionally forma...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb