Excel

What The Tech?!? – Episode 21 – More Microsoft Excel – Date and Time Tricks (Part 2)

Welcome to Episode 21 of What The Tech - Plain Speak From a Non Geek. Tips to make you mor...

What The Tech?!? – Episode 20 – Microsoft Excel – Date and Time Tricks

Welcome to Episode 20 of What The Tech - Plain Speak From a Non Geek. Tips to make you mor...

Rank and Order Data Automatically in Excel

The trick to automatically ranking your data is to combine the RANK function and the VLOOK...

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...

Add Numbers in Excel Using the SUM Function

This video will give you a brief overview of what Excel is, and teach you how to use the S...

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...