Excel Course Files
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
Microsoft Excel Running Total with SUM and SUMIF Functions
(Watch the video for a demonstration) The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the...
Sep. 2019 MOS Practice Voucher Contest
It's that time again... Time for another CONTEST. For the month of September 2019 I will be running a contest in conjunction with my...
Microsoft Announces a New XLOOKUP Function for Excel
Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking...
Now You Can Blog from Everywhere!
We’ve made it quick and convenient for you to manage your blog from anywhere. In this blog post we’ll share the ways you can post to your...
Design a Stunning Blog
When it comes to design, the Wix blog has everything you need to create beautiful posts that will grab your reader's attention. Check out...
Grow Your Blog Community
With Wix Blog, you’re not only sharing your voice with the world, you can also grow an active online community. That’s why the Wix blog...
Microsoft Excel Combine Worksheets with Power Query
Microsoft Excel's Power Query makes it easy to combine multiple Excel tables, from different worksheets, into one master list. You can...
Microsoft Excel VLOOKUP Function with Multiple Criteria
Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will...
Use Microsoft Excels Camera Tool with Formulas
Everyday I take some time to get through the questions I get in my online courses. I enjoy getting questions for a couple of reasons....
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...