How to use the SUM Function in Microsoft Excel

How to use the SUM Function in Microsoft Excel This quick video explains how to use the SUM Function in Excel. Learn how to add rows and columns of data quickly and easily using Excel’s built-in SUM function – use the ribbon or type the function directly into a cell....

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

Turning on and off option in Show Group

Turning On and Off option in Show Group This quick video will show you how to display or hide items in a Pivot Table for presentation purposes. We can display or hide items in a Pivot Table for presentation purposes – this makes the Pivot Table easier to view without...

Importing Web Data

Importing Web Data This quick video explains how to easily Import Data from the Web. 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 icon_style="slide"...