Videos

Below are links to the videos linked to by this blog:

Date Video Title Description
2015-10-19 Text Manipulation in Microsoft Excel In this video demo I’m going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you’re looking for. At the end of the demo, we’ll touch on the IF function and show you how you can manipulate the table based on some set of criteria.
2016-03-09 Using VLOOKUP in Microsoft Excel In this video demo I’m going to show you how to use the VLOOKUP function.