New and special tips and tricks to help you in your day to day work
Use the Go To F5 function key in Excel to go to named ranges if
you have them and also to find Formulas from the Special button
Want a quick chart on a separate sheet in Excel, select data and
then press the function key F11! All chart features still available to
you.
For an absolute reference don’t type Dollar signs $ in a formula
use the F4 function key to toggle through =$A$1, =A$1, =$A1 and then =A1
Use the Format Painter to paint not just one cells but multiples by double-clicking on the icon and
selecting multiple cells, to toggle off this feature, just click on the icon again.
Quickly name a cell and use it in a formula i.e. 20% VAT using the Name Box
PDF 
