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
Strange Signs
During my University life I collected photos of badly translated signs. This sign in my hotel room today made me laugh and reminded me of those days. I must locate those old photos or start a new collection.
What makes a ‘good’ training course?
As a trainer, I often hear tales of courses people have attended previously. Sometimes they sound like a lot of fun and really useful learning experiences. However other courses give training a bad name. So what makes a good training course? It really depends on your role in the course, as we all want something … Continue reading What makes a ‘good’ training course?
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
Using this blog
This blog contains extracts from training materials I use during training delivery. To use this blog, either use the category links or search for the topic you are interested in using a keyword typed into the search box at the top of the page. I'm gradually adding more content as I update old materials and … Continue reading Using this blog
Sara Fennah's Blog 
You must be logged in to post a comment.