Turning on and off Filters

Turning on and off Filters This quick video explains how to turn on and off Filters in Excel. There are two ways of turning on the filters in Excel – which will work with any list – providing there are no complete empty rows of data. Using the HOME TAB we can apply a...

Using Excel Templates

Using Templates in Excel This quick video explains how to use the Templates in Excel. Excel is shipped with hundreds of powerful templates. Learn how to browse and access them. [et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top"...

Quick Access Toolbar

The Quick Access Toolbar This quick video explains how to use the Quick Access Toolbar on your Excel worksheet If you have used earlier versions of Excel – you may find you are missing some of your favorite toolbar buttons. Learn how to add them to the Quick Access...

Importing data from the Web into Excel

Importing Data from the Web into Excel This quick video explains how to Import Data from the Web into Excel. More frequently we can find data we need to feed our spreadsheet online – learn how to import and link to web data using Excel. [et_social_follow...

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

Excel 2013 New Features – Quick Analysis Tool

Excel 2013 New Features – Quick Analysis Tool The Quick Analysis tool as the name suggests allows us to select data on our sheet and then quickly analyse it using the short cut options available to us from the tool. Once you select your data, if the option is...