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

Excel – Creating a New Workbook

When you open a new file in Excel it is called a workbook. Workbooks are made up of columns which […]

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

Page 2 of 612345...Last »