Say six months ago you wrote a formula similar to this: =10000+787-12*299.64. Now you find you just can’t remember what exactly each figure represents. Try writing yourself a reminder about the calculation and add a hidden note to your formula by using the N() function i.e. =10000+787-12*299.64+N(“Loan+Interest-12 months of loan repayments”). The N() function converts […]
Close all open messages in Outlook
Do you want to be able to close all the message windows in one fell swoop, but leave the main Outlook application running? In Outlook 2010 click on the View tab and select Close All Items. (In earlier versions of Outlook, Close All Items is usually found under the File menu).
Quick Drop-down List in Excel
Do you want to repeat data that’s already been used in the column? To enter Yellow in a new cell in the column Excel will bring it up anyway when simply typing Y – this is because there is only one data entry starting with the letter Y. Conversely if you need to enter Blueish, […]
Pin Files and Folders
To pin files to the Recent List in 2010 click on the File tab, Recent. Click on a stickpin, next to a Recent Document that you want to anchor to the top of the list. On the right hand side in Recent Places you can now also pin entire folders permanently to the top of […]
Clipboard
The Clipboard is handy to use when you want to Copy and Paste something but you don’t necessarily want to do the pasting immediately after you’ve done the copy. The Clipboard will also hold items you’ve copied from various programs, not just Word. To use open the Clipboard by clicking on the Clipboard button. Position your insertion […]
Quickest way to review a Sum or Average
A quick way to find the sum and average of cells in Excel 2010 is to select adjacent or non-adjacent cells and look in the status bar. Excel displays the average of the numbers, a count of the cells, and the sum.
Crop to a Shape
First we need a picture in our Word document (Insert tab – Picture). The Picture Tools format ribbon should now be active. If not, click on the image. In the Size group click on the Crop down triangle. Select Crop to Shape and choose any of the available shapes.
Cropping Pictures Word 2010
First we need a picture in our Word document (Insert tab – Picture). The Picture Tools format ribbon should now be active. If not, click on the image. Click on Crop. Click and drag inward any of the four corners to crop from any one side. You can still see the area to be cropped […]
Keyboard strokes for AutoSum
The AutoSum tool is already fast, but even quicker just try selecting a cell at the bottom of a column of figures and press Alt+=, which inserts the =Sum() function (just like AutoSum does).
Customise Excel’s Default Workbook 2010
If you really only use one sheet and not the default three that Excel creates with any new workbook you can customise this to suit your way of working. Change Excel’s default settings by going to the File menu > Options > General. Look in the section ‘When creating new workbooks’ and change ‘Include this […]
