# Video 00064 Solution_Customized and Sorted Data Validation List

### Hide and Seek

Imagine a data validation drop down list with many names that are not sorted. Trying to find a particular name in that list would get frustrating as the list grows.

Did you know that there are ways to sort text in Excel? Continue reading

# Free Excel template: Class Student Grade Calculator v2.20

This Excel file is more of a custom solution than it is a template.

### So, why share it?

Because, you can learn a lot about Excel by auditing formulas!

Take apart the template and see how it works (password is ‘test’). Continue reading

# Video 00058 Filter Out Number (digits in any order)

### Imagine a column of numbers. Each number is 3 digits in length.

If we select 127 then we want to also hide 127, 172, 217, 271, 712, and 721 (six unique orders).

In this video I show you two possible solutions.  Continue reading

# Video 00057 Find the Monday before the oldest date

We can use Excel’s MIN function to find the minimum number in a range. As date values are technically numbers, the MIN function can show the oldest date.

# Free Excel template: Wedding Planner

### Web Based Planner or Spreadsheet Wedding Template?

There are many different on-line wedding planners.  For example, click here to see Marha Stewart’s on-line wedding planning tool. Continue reading

# 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