How do you add 20 minutes to a time value in Microsoft Excel?
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
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 →
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).
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 →
Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading →
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 →