Month: October 2016

Different count functions in Excel

COUNT returns the amount of cells in the range which contain a number. COUNTA (count all) returns the amount of cells containing any value. COUNTBLANK returns the amount of cells containing no value. COUNTIF returns the amount of cells in the range which meet your chosen criteria.  

Excel HYPERLINK function

Excel has a built-in function allowing you to add hyperlinks to a cell. You can also give the hyperlink a user-friendly name rather than just displaying the file path.   E.g. =HYPERLINK(“E:\Documents\Finance\Financial Calendar.xlsx”,”Finance calendar”)

Hide gridlines in Excel

A dashboard or summary in Excel often looks smoother without the gridlines in the background, here’s how to remove them.   The quickest way to toggle between showing and hiding them is the following shortcut: Alt, W, V, G.   The ribbon equivalent is to go to the View tab and de-select Gridlines.