Excel Course Files
Use tab to navigate through the menu items.
LIVE QA ON MICROSOFT EXCEL - June 24th, 2020
LIVE QA ON MICROSOFT EXCEL
Microsoft Excel Power Query Cleaning Nested Data with Conditional Columns and Fill Command
Windows Task Scheduler
Intro Web Scraping with Excel VBA
Excel has a few different ways to import data from various sources, including web content. If you visit the DATA TAB, found within the...
Microsoft Excel - Hiding Excel Worksheets with VBA
Got another great question from a student in my Excel VBA UserForms course on Udemy. QUESTION: I have built and Excel UserForm that...
Microsoft Excel - Create User Defined Functions with VBA
I just got another great question from a student in my Microsoft Excel course on Udemy. The question deals with automating a conditional...
Microsoft Excel VBA - Play a sound based on a condition
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...