Experience true Excel power by using Microsoft Excels Power Query (GET AND TRANSFORM - Excel 2016+) feature. In this video I will introduce you to some of the hottest features Power Query has to offer.

Full Microsoft Excel Power Query -- Beginner to Advanced course comi...

(Watch the video for a demonstration)

The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the SUM function at the basic level. But, with a little bit of cell reference magic, we can use the SUM function to create a Running Tota...

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 courses on Udemy.

PARTICIPATE

Your already enrolled in one of my courses on Udemy. 

• Excel Beginner to Advanced

• Word Beginner to Ad...

Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking up information and overcomes the limitations that the popular VLOOKUP() function has.

XLOOKUP()

XLOOKUP is named for its ability to loo...

Microsoft Excel's Power Query makes it easy to combine multiple Excel tables, from different worksheets, into one master list. You can then use that master list to create your PivotTables and summarize the data.

Make sure you download the exercise file used in the video...

Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will learn how to overcome one of these limitations in order to use the VLOOKUP() Function to find a corresponding value based on multiple...

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.

• Asking questions means that the person asking is learning.

• I get to make more videos!!

I'd like to share one of the questions...

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...

Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!!

"Note: September 24, 2018: The FILTER function is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll cont...

HAPPY THANKSGIVING!

What better way to finish up a contest then to celebrate by giving thanks. I want to thank everyone that has been participating in my courses on Udemy. I love creating these courses and hope that you are finding the information beneficial and product...