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
NEW COURSE! Microsoft Excel Data Analysis and Dashboard Reporting
I'm excited to announce that I have a new Microsoft Excel course in the pipeline. I plan on having it released before the end of Oct....
CONTEST TIME - Win a Microsoft Office Specialist Practice Exam Voucher
Its time for another CONTEST! I’ve been getting a lot of students in my Udemy courses sending me message expressing interest in taking...
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 Dynamic Validation Lists
QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example;...
A Little SharePoint Humor
During the release of SharePoint 2010, Microsoft put out a website called “I Use SharePoint”. Today the site no longer exists as it did...
Creating Custom SharePoint Workflows with SharePoint Designer
SharePoint Workflows are huge. The ability to automate a business process, such as submitting a document for approval, ultimately saves...
Udemy Course Certificate and LinkedIn
First off, thank you for your continued participation in my courses on Udemy. Everyday I check my QA box, in my courses, and find loads...
Schedule Microsoft Excel Tasks with Windows Task Scheduler
I got an excellent question from a student in my Excel course hosted on Udemy. QUESTION: "How can you schedule Microsoft Excel...
Microsoft Excel - Dynamic VLOOKUP() with MATCH() Function
A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought...