Preview of The Hero Tools Add in for Excel
Microsoft Excel Tips and Tricks The Hero Tools Add-in combines all of our existing add-ins (plus brand new features) to[…]
Read more
Tag: excel
How to Create Simple Excel Form for Data Entry
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to create a simple data entry form in Microsoft[…]
Read more
Assign Categories Based on Keywords in Excel | Check if Cell Contains Text From List
Microsoft Excel Tips and Tricks In this video I demonstrate how to categorise text values based on a list of[…]
Read more
Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text
Microsoft Excel Tips and Tricks In this video, I demonstrate how to combine concatenation with an IF condition. In the[…]
Read more
If Time is Within Range | If Time is Greater Than or Less Than, Return Value
Microsoft Excel Tips and Tricks In this video I demonstrate how to do the following: 1) Perform an IF statement[…]
Read more