One of the common uses for Excel is to keep a list of contacts; names, addresses and telephone numbers. But, the problem is that when you enter the ‘phone number you lose the leading 0. so a ‘phone number of 01234567899 becomes 1234567899. It is also aligned to the right instead of the left. To [...]
Posted in Excel, Microsoft Office | No Comments »
Let’s say you are in the middle of a Powerpoint presentation and you wish to draw the attention of your audience to a particluar part of a slide. You can use the mouse to draw freehand directly on to the slide without leaving the presentation. On the kepboard press crtl + P The mouse will [...]
Posted in Powerpoint | No Comments »
You already know that whenever you need to copy, cut or change the format of text in Word you need to select it first. Selected text looks like this. Using the mouse makes it very easy to select text. To select just one word; double-click on the word. To select a group of words; click [...]
Posted in Word | No Comments »
Wether it’s a name like Siân or a word like résumé there are many occassions when we need to add an accent or a foreign character. Of course, we could use Insert|Symbol but it gets a bit tedious if you need to add an accent or foreign character frequently. There is a quicker, easier way [...]
Posted in Word | No Comments »
If your table has a row or column of numbers you can enter a formula similar to those in Excel to add up all the numbers. For example: To add up a row of numbers; click in the right-most cell of the table (making sure it’s empty, of course) and on the Word toolbar click [...]
Posted in Word | No Comments »
Instead of using the mouse to point and click at the edit menu and choose “copy”, “cut”, or “paste” you can use the keyboard for swift editing. While holing down the Ctrl key press: “C” to Copy “X” to Cut “V” to Paste For Example: To move a word select the word then press Ctrl [...]
Posted in Word | No Comments »
If you want to quicly enter the date in Excel then simply hold down the “ctrl” key and press the semi-colon key “;” and woosh – the date is entered. This is a static value unlike using NOW() or TODAY() the date will not update. viagra softpurchase viagracialis softviagra professionalcialis professionalgeneric viagrageneric cialislevitraviagracialisviagra soft tabscialis [...]
Posted in Excel | No Comments »
To show the current date & time whenever a spreadsheet is opened use NOW() Enter “=NOW()” in to the cell where you want the date and time to show press enter and there it is. If you just want the date then use “=TODAY()” But remember these functions will show the current date and time, [...]
Posted in Excel | No Comments »
When you are writing your Word document you can easily capitalise headings using s build-in Word shortcut. Write the heading as normal. Select the line. Press shift+F3 to toggle through capitalising options: ALL CAPS / First Letter Of Each Word / no caps i.e. all lower case. If you’re like me this will save a [...]
Posted in Word | No Comments »