Remove First or Last Character From Text String in Excel
Microsoft Excel Tips and Tricks In this video I demonstrate how to remove the first or last character in a[…]
Read more
The Learning Zone
Dedicated to everything Learning, learning is fun
Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Without Using an Array Formula)
Microsoft Excel Tips and Tricks In this video, I demonstrate how to lookup the 2nd, 3rd, 4th or nth occurrence[…]
Read more
How to Import Data from the Web in Excel
Microsoft Excel Tips and Tricks In this step-by-step tutorial, learn how to import and dynamically connect web data to your[…]
Read more
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
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