Drop down lists

Drop Down Lists This quick video explains how to create a Drop Down List in Excel. Drop down lists are a useful way of presenting the user with a finite list of options. Learn how to create them Data Validation [et_social_follow icon_style="slide"...

Drop down lists using INDIRECT

Drop Down Lists using INDIRECT This quick video explains Drop Down Lists using the INDIRECT Formula Learn how to create drop-down lists using the INDIRECT function. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top" col_number="auto"...

Paste Special

Using Paste Special This quick video explains using Paste Special in Excel. The Paste Special button allows us to change the behavior of the standard Paste command – and includes special features allowing us to transpose cells, copy just the values (without the...

The IF statement in Excel

The IF Statement in Excel This quick video explains using the IF Statement in Excel The IF statement in Excel is widely used in Excel and can be confusing if you haven’t come across it before. This short video will show you how to use the IF statement –...

Using the VLOOKUP Formula

Using the VLOOKUP Formula This quick video explains how to use the VLOOKUP Formula in Excel Using The VLOOKUP Formula is one of the most widely used functions in Excel and is regularly used incorrectly. Learn why it is so useful and what errors to avoid. V is short...

Calculating a person’s age in Excel

Calculating a person’s age in Excel Calculating a Persons Age in Excel. So you want to know a person’s age or need to calculate how many years have lapsed since a renewal date. Perhaps you want to know the ages of your staff without having to calculate it each year or...