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

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

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

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