VLOOKUP and Other Excel Lookup Formula Tutorials
Excel VLOOKUP Step by Step Tutorial
The VLOOKUP function is used to find specific information that has been stored in a database. This tutorial includes a step by step example of how retrieve information using the VLOOKUP function in Excel.
Excel SUM OFFSET Formula Tutorial
The SUM OFFSET Formula can be used to create a dynamic sum formula that will update the range totalled as new cells are added.