This Excel file is more of a custom solution than it is a template.
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
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
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.
There are many different on-line wedding planners. For example, click here to see Marha Stewart’s on-line wedding planning tool. Continue reading
There’s a lot of confusion about data and time values in Excel but it’s easy to learn! Continue reading
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
In this video, the array uses the EXACT and LEFT worksheet functions. Continue reading
In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading
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
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