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...
LIVE QA ON MICROSOFT EXCEL - June 24th, 2020
June 24, 2020
LIVE QA ON MICROSOFT EXCEL
June 1, 2020
Microsoft Excel Power Query Cleaning Nested Data w...
April 30, 2020
Windows Task Scheduler