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...
Top Time Saving Excel Techniques in Microsoft Exce...
September 19, 2019
Microsoft Excel Running Total with SUM and SUMIF F...
September 6, 2019
Sep. 2019 MOS Practice Voucher Contest
September 3, 2019
Windows Task Scheduler