This article looks at managing holiday using Excel 2010 and making use of the following Excel features: INDIRECT function NETWORKDAYS function Format as Table Conditional Formatting The finished file is available here (Holidays). However this article explains how to use the finished article and how to create it, so read on (or bookmark me for … Continue reading Calculating Employee Holiday Allowance in Excel
Category: Microsoft Office
Named Cells, Ranges and Values
Formulas and functions are usually created using references to other cells on the spreadsheet. Where you need to refer to a fixed cell and still be able to duplicate the formula around the spreadsheet then you can use fixed cell references as explained in the Simple Formulas and Functions reference guide. These absolute and mixed … Continue reading Named Cells, Ranges and Values
More Functions in Excel
Named Cells, Ranges and Values Formulas and functions are usually created using references to other cells on the spreadsheet. Where you need to refer to a fixed cell and still be able to duplicate the formula around the spreadsheet then you can use fixed cell references as explained in the Simple Formulas and Functions reference … Continue reading More Functions in Excel
Mum’s Bragging Rights
Today my 8 year old son, decided to put to use skills learnt at school and produce a Diamond Jubilee picture in PowerPoint. He used images from the internet (mainly the official Jubilee website) and then saved his poster as a picture. So I'm now a very proud Mum, but slightly embarassed trainer, as he … Continue reading Mum’s Bragging Rights
Quick Charts in Excel
My favourite shortcut in Excel - to draw a chart select the data and press F11 key. Job done.
Analysis Functions in Excel 2010
Enable Analysis Tools The analysis tools in Excel need to be switched on before use. To enable the Data Analysis tools: Select Options from the File tab Choose Add-ins At the bottom of the box, select Excel Add-ins and click Go Ensure both the Analysis ToolPak and Solver Add-in are ticked and click OK Performing … Continue reading Analysis Functions in Excel 2010
Selecting Text
In order to modify the text you need to be able to indicate to the system which text you wish to modify. We do this by selecting the text. There are a few methods by which you can select text. Click & Drag Hover your mouse at the end of the text you wish to … Continue reading Selecting Text
Creating Simple Documents
When creating a word document you need to be able to type in your text and then change the look and feel of the document to make the presentation of the document match your requirements. Selecting Text In order to modify the text you need to be able to indicate to the system which text … Continue reading Creating Simple Documents
Advanced Formatting in Excel 2010
Comments Comments can be added to an Excel document for many purposes such as: Reviewing a document. Giving instructions to people completing a form. Explaining how a calculation works. Create a Comment To create a comment: Highlight the cell the comment is to be added to. On the Review tab, in the Comments group, click … Continue reading Advanced Formatting in Excel 2010
Research and Thesaurus
With either the Research or Thesaurus button from the Review tab, the Research Pane can be opened. This looks up the selected word or phrase in the chosen reference book. To change the word or phrase to be looked up, simply overtype the information in the Search for: box. Once you have entered your desired … Continue reading Research and Thesaurus
Sara Fennah's Blog 
You must be logged in to post a comment.