Shortcut keys in Excel – Function Keys (6 of 8)
In all my years of training I am always stunned that most people don’t even know that there are keys at the top of their keyboard that are called function keys....
Soft Returns for Word Documents Explained
What is a soft return? It conjures up some lovely images of warm duvets and soft beds to crawl into and sleep.
I’m afraid it's not that at all. I’m talking about...
The Status Bar in Excel explained
Have you even noticed that there is a status bar at the bottom of your excel window? A lot of my students who have been using Excel for a number of...
Shortcut keys in Excel for Data, Functions and Formula Bar (5 of 8)
This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar. I have highlighted for you some that I find very useful...
Using Grouping in Excel
As part of my training process I do what's known as floor walking. This is when I walk about the company I have done some training at so that anyone can...
Assigning a Macro to a Tool
There are loads of tools on the ribbons in Excel. Most of which are extremely useful. The Quick Access Toolbar is an extra where you can add those tools not easily...
Recording a simple Macro in Excel
What is a Macro? Well simply put, it is a single instruction that expands automatically into a set of instructions to perform a particular task.
I’m sure that all of you reading...
Keyboard shortcuts in Excel – Referencing and Selections (4 of 8)
Here is another list of shortcuts you can use in Excel. Once again I stress that it is only a shortcut if you learn it and not just print off the...
Saving a screen print in Windows 10
How many times do you wish that it was easy to take a screen shot of your work? Or even an error message. They are notoriously difficult to understand with their...
Tips – Format Painter feature in Microsoft Office
In all the years that this feature has been available it still astounds me to find that people just don’t know it exists or how very useful it can be. How...