Guides & Tips Microsoft Excel

Excel Formulas & Functions

Formula = a calculation you enter yourselfFunction = a pre programmed formula, commonly shortened to ‘fx’Understanding FormulasWhen you enter […]

Read more

Formula Auditing in Excel

Excel has a variety of powerful tools in it’s toolbox to help you see what is going on in […]

Read more

Excel – Editing In A Workbook

There are three ways you can edit data in Excel – overwrite, edit and delete.OverwritingThis is the easiest way […]

Read more

Excel – Ranges

A range is a group of 2 or more cells selected/highlighted at the same time.A range is named […]

Read more

Working with Comments in Excel

Comments are a way of adding a comment to a particular cell within Excel without altering it’s contents. When […]

Read more

How to customise the QAT in Excel

Firstly, what is the QAT? It stands for the Quick Access Toolbar and is used for quick access to commands […]

Read more

Excel KeyTips

Navigate Excel 2010 without a mouse, this is possible by using KeyTip badges. To find these press the ‘Alt’ key […]

Read more

Excel 2010 Orientation

If you are new to Excel or just new to Excel 2010, this will show you what you will see […]

Read more

Page 2 of 512345