Microsoft just released a new Excel function called LET(). The LET() function allows users to associate a value or calculation with a name/variable.

LET() FUNCTION DEFINITION

=LET(name1, value1, [name2...], [value2...], calculation)

BENEFITS

• LET() allows users to poten...

Microsoft PowerPoint Zoom allows you to create more dynamic and exciting presentations. The Zoom feature gives the presenter the ability to jump to and from any portion of their presentation while presenting.

CURRENT AVAILABLILITY (March 2020)

• PowerPoint for Office 3...

Microsoft has introduced a new feature in PowerPoint Office 365. This is a subscription feature through Office 365.

MORPH TRANSITION

The Morph Transition allows the creator to create smooth animations for objects on the slide. This is accomplished by creating the origina...

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