Use SUMIF, SUMIFS or SUMPRODUCT to SUM a range of cells Conditionally =SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has...

The FILTER function allows you to filter a range of data based on criteria you define. =FILTER(ARRAY,INCLUDE,[IF_EMPTY]) ARRAY = THE...

With just a little bit of cell formatting, a pinch of Excel function magic and Excel conditional formatting, you can create an...

Microsoft is releasing a handful of TEXT based functions that make splitting column values into multiple columns, super easy to do. For...

How can you take a column with duplicate values and extract just the unique values? Follow along as I demonstrate four techniques you can...

Microsoft Excel PivotTables are one of the most popular features of Excel. Take a look at the videos below to find out why PivotTables...

Excel Power Query Microsoft Excel's Power Query feature allows you to append multiple data lists, creating a master list to user within...

Microsoft Excel contains loads of Shortcut keys to help you become more efficient and save time while working with your Excel data. Below...

***** This feature has been introduced to Microsoft Office Beta users and will be made available to the public soon. Microsoft is...

Have you ever needed to sort Excel data in a specific order other than alphabetical, Ascending/Descending? For example, if you have a...

Check out the differences between Microsoft Excel Relative and Absolute Cell references in Excel formulas. DOWNLOAD EXERCISE FILE TO...

QUESTION: “Is it possible to make one validation column dependent upon choices from another validation column?” Here’s an example;...

A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought...

Below is a quick video demonstration on Microsoft Excel Array Formulas. Arrays, simply put, are a collection of data. For example you may...

Another great question from a student in my Complete Excel training course on Udemy. Download the example file to try yourself:...

I got another excellent question from a student in my Complete Microsoft Excel course. Take a look at the video below on how to create a...

Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!! "Note: September 24, 2018: The...

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

TEXTJOIN() FUNCTION DEFINITION =TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …) BENEFITS The TEXTJOIN function combines...

I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them...