These shortcuts tips are for desktop Outlook client, which often comes as part of the Microsoft Office suite. I was inspired to write this post when I came across a useful shortcut I wasn’t aware of. You can save time and clicks when wanting to copy text straight into an Outlook item. To do this […]
Go Back
There is a great and pretty handy little ‘Go Back’ shortcut in Word. To illustrate its potential use: if you’re working away on page 4, then move to page 23 to copy some text ‘Go Back’ can return you to the previous editing location (page 4) quickly. Simply press… Shift+F5 This keystroke will cycle through your […]
Readability Statistics
Enabling Readability Statistics in Word 2010, to evaluate the writing’s complexity. This can be useful if you are writing a document aimed toward a particular level of audience, for example either the comprehension level of undergraduates or an average 11 year old. For reading ease in most documents you’ll want to aim between a score […]
Excel chart – fast!
Select your data. Press F11 on the keyboard and voila! An instant column chart is created on a new worksheet…
Transpose Data
This would be useful if you wanted to change the orientation of the display of your data, but really didn’t want to retype it all. Copy all the original data first, find an empty area and click on a cell where you want to begin the copy. Go to Home > Paste > Transpose (you […]
Keep Preceding Noughts
When an input value starts with zero Excel will delete the zero(s) by default – try adding a single quote mark ahead of the first zero.
Navigating Sheets
It’s common knowledge and instinctive to click on a different sheet tab in a workbook to activate it. You can also use the keyboard; press Ctrl-Page Up and Ctrl-Page Down to go up and down the sheets. If your workbook contains a large number of sheets they may not all fit on the screen and it […]
Split full names in single column
How to split full names (in a single column) out into separate columns. Use functions: =LEFT(B4,FIND(” “,B4,1)-1) =RIGHT(B4,LEN(B4)-FIND(” “,B4,1))
Page Numbering
To insert Page Number click the Insert tab. In the Header & Footer group click Page Number. Select position of page number (Top of Page = Header, Bottom of Page = Footer, Page Margins = left or right and Current Position = at your current cursor point). Once position has been selected you will see various options […]
Formula Syntax
Sometimes you might find a quick reminder of the formula syntax useful when working in Excel. If this is the case then type an equal sign followed by the function name and then Ctrl+Shift+A. For Example typing =Sumif and then using the keyboard stroke Ctrl+Shift+A will give you: =Sumif(range,criteria,sum_range). In 2010 you will find Excel […]
