Master the VLOOKUP

Everything you need to know to master the VLOOKUP What is a VLOOKUP Function? Whenever you keep track of anything with spread sheets, there’ll come a time when you want to find information without having to scroll through a list or Table. That’s when the...

Sorting Data in Excel using a Custom List

Sorting Data in Excel using a Custom List  This quick video explains Sorting Data in Excel using a custom list. Excel provides a mechanism to sort using a custom list – this allows us to specify the preferred sort order for a list. So instead of a simple alphabetic...