How to Use Colour Scales in Excel

How to use Colour Scales in Excel This quick video explains how to use Colour Scales in Excel. Colour scales or heat maps are a useful way to highlight values in a range of cells. Built-in heat maps allow you to apply different schemes dependent on the rules you wish...

How to remove # symbols from Excel

How to Remove the #### Symbols in Excel This quick video explains how to Remove the #### Symbols from your Excel worksheet. Removing symbols from Excel. Seeing ##### (hash) symbols in your spreadsheet is very common. Learn what causes it to happen and how to remove...

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

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

Icon Sets

Icon Sets This quick video explains how you use Icon Sets in Conditional Formatting in Excel Traffic light icons, signal bars, indicators and other symbols can be used to highlight values in a range of cells and compare them with each other using icon sets....

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