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.
(HOME -- CONDITIONAL FORMATTING)
In the above example, cell A2 is conditionally forma...
Microsoft Excel Power Query Pivot Column
April 3, 2020
Microsoft Excel Brand New LET() Function
March 18, 2020
Microsoft PowerPoint ZOOM Feature
March 10, 2020
Windows Task Scheduler