Join us for a live Q&A on Microsoft Excel, Wednesday June 24th at 10:00 AM Mountain Time US.

I've asked those that will be attending to post questions in the comment section of the page that I can use in this Q&A session. I've also created an exercise file that you can...

Join us for a live Q&A on Microsoft Excel, Monday June 1st at 11:00 AM Mountain Time US.

I've asked those that will be attending to post questions in the comment section of the page that I can use in this Q&A session. I've also created an exercise file that you can down...

Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command you'll transform nested data into a clean, useable list.

Download the Exercise file to follow along: ExcelPowerQueryFeatures 

I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them in a YouTube playlist to make is accessible in order to go through each.

The videos include working with Excel's VLOOKUP, HLOOKUP and...

TEXTJOIN() FUNCTION DEFINITION

=TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …)

BENEFITS

• The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. I...

I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks something like this.

It's a pretty simple list of addresses. But, not very useable. The data is in two columns and organized into addres...

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