by Fiona Hannon | Dec 9, 2014 | Excel Top Tips! |
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...
by Fiona Hannon | Aug 15, 2014 | Excel Top Tips! |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Top Tips! |
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"...
by Fiona Hannon | Aug 14, 2014 | Excel Top Tips! |
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...
by Fiona Hannon | Aug 14, 2014 | Excel Formulas and Functions, Excel Top Tips! |
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....
by Fiona Hannon | Aug 14, 2014 | Excel Formulas and Functions, Excel Top Tips! |
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"...