Excel

Lookup Data From a Table Using VLOOKUP in Excel

VLOOKUP can help you return data from any column in a table based on whatever information ...

Relative and Absolute References in Excel

This video will help you to both use and understand relative and absolute cell references ...

Add Radio Buttons in Excel

Learn how to add radio buttons (option buttons) to your Excel spreadsheet using the tools ...

Add Only Cells that Meet Certain Criteria with SUMIF in Excel

This video will help you to add only certain items from a range (table) based on criteria ...

Create 2 Dynamic Drop-Downs Dependent on the Same Source In Excel (1 to 2 relationship)

This lesson will explain how to use the INDIRECT function and the VLOOKUP function to crea...

Create a Dynamic (changing) Drop-Down List in Excel

This video will teach you how to create a drop-down list with content that changes based o...