# Video 00047 Formulas_Add 20 minutes to TIME value

### What is the difference between a time value and a date & time value?

There’s a lot of confusion about data and time values in Excel but it’s easy to learn! Continue reading

# Free Excel template: SWOT planner

### SWOT = Strengths, Weaknesses, Opportunities, Threats

Enter strengths, weaknesses, opportunities and threats.  For each entry, you select “Y” to display it in the output sheet or “N” to hide it (no need to erase the entry and then have to type it back in later). Continue reading

# Video 00044 Array Formulas_Example2_EXACT LEFT_functions

### Answer: You can answer a complex question using only 1 array.

In this video, the array uses the EXACT and LEFT worksheet functions. Continue reading

# Video 00043 Formulas_Array Formulas_Example1_LEN_function

### Answer: Because you can answer many complex questions using only 1 array formula!

In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading

# Video 00042 Why would I need an array formula?

### Why would I need an array formula?

I have heard this question so many times over the years! If you have never ever used an array formula than this video is for you.

Don’t worry….No prior knowledge is required. I explain things slowly. Continue reading

# Video 00035 Solution_Dynamic array HYPERLINK

### Create a dynamic hyperlink using an array formula!

This means that you can jump to a location in your data depending on conditions in the values

This is one of my favorite ways to use an array formula! Continue reading

# Video 00033 Solution_identify rows if any in same group meet condition_V2

Requirement: Identify all items within a group if any of the items in that group meet a condition.

Solution: This time I use the SUMPRODUCT function for a quicker solution.  SUMPRODUCT can be used to count with conditions (within the same group).

# Video 00032 Solution_identify rows if any in same group meet condition

Requirement: Identify all items within a group if any of the items in that group meet a condition.

Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading

# Video 00037 Formulas_Adding numbers in Excel

Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading

# Video 00031 DATA VALIDATION restrict values entered into a cell

Use Excel’s data validation feature to restrict values that can be entered into cells.

Data validation can save you hours of data cleanup work! Continue reading