UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

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.

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

(HOME -- CONDITIONAL FORMATTING)

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

Please reload

Please reload

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb