http://www.microsofttraining.net/microsoft-office-hints-tips.html Software application hints and tips from our Microsoft Qualified trainers en Tue, 21 May 2013 16:06:22 GMT Tue, 21 May 2013 16:06:22 GMT http://www.microsofttraining.net/rss-feeds.php If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document. http://www.microsofttraining.net/tip-705-navigate-with-keyboard.html Wed, 21 Nov 2012 00:00:00 GMT http://www.microsofttraining.net/tip-705-navigate-with-keyboard.html If you press Alt and = at the same time, it applies autosum. http://www.microsofttraining.net/tip-703-use-autosum-shortcut.html Wed, 07 Nov 2012 00:00:00 GMT http://www.microsofttraining.net/tip-703-use-autosum-shortcut.html If you press Alt and = at the same time, it applies autosum. http://www.microsofttraining.net/tip-704-use-autosum-shortcut.html Wed, 07 Nov 2012 00:00:00 GMT http://www.microsofttraining.net/tip-704-use-autosum-shortcut.html Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share! http://www.microsofttraining.net/tip-702-shortcut-fill-cells.html Tue, 06 Nov 2012 00:00:00 GMT http://www.microsofttraining.net/tip-702-shortcut-fill-cells.html If you need to add a € symbol to your Excel sheet - hold down the key Alt Gr and 4. Alt Gr is located on the right side of the space bar. http://www.microsofttraining.net/tip-701-shortcut-key-€.html Tue, 16 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-701-shortcut-key-€.html When you have related tables such as Customers and their Orders, the Customer table is the Primary table. Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok. Now you can click the + symbol by each company to show the related orders. http://www.microsofttraining.net/tip-700-insert-subdatasheet.html Mon, 15 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-700-insert-subdatasheet.html A well-used and favourite shortcut is Control + z. If you are typing and you need to undo an action, it is quicker to undo using the keyboard, rather than reach for the mouse. so control + z to undo.... http://www.microsofttraining.net/tip-697-undo-last-action.html Fri, 12 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-697-undo-last-action.html A quick way to close a presentation in Powerpoint is to use Control+W. You may be prompted to save changes, and you can press S to do this. You won't need to use the mouse, and it is easier if you are using the keyboard to use a keyboard shortcut. http://www.microsofttraining.net/tip-698-shortcut-key-close.html Fri, 12 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-698-shortcut-key-close.html Powerpoint has easy to use, ready made templates, with colour and formatting all ready for you to add your photos. This is a great way to show family photos in a fun way, you can even add music or embed videos to bring it to life. In the File menu, select new, then select templates to select the album style to suit you. http://www.microsofttraining.net/tip-699-powerpoint-photo-album.html Fri, 12 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-699-powerpoint-photo-album.html If you are happy using your Ctrl + shortcuts and Alt + shortcuts, they still work in Powerpoint 2010. You can also benefit from the 2010 enhancements using Key Tips. http://www.microsofttraining.net/tip-695-shortcuts-2003-and-2010.html Thu, 11 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-695-shortcuts-2003-and-2010.html If you need to set up a presentation quickly and don't have the time to add the colours and formatting yourself - take advantage of the ready-made templates in Powerpoint 2010. When you create a new presentation in Powerpoint, you can select a ready made template from the Office.com section in the File menu. http://www.microsofttraining.net/tip-696-templates-powerpoint-2010.html Thu, 11 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-696-templates-powerpoint-2010.html If you have a presentation in 2003 you can work on it with the 2010 enhancements by using the compatibility mode. Open the 2003 file in Powerpoint, and it will open it compatibility mode. Click on the File tab then select Info, and Convert. Then save the file using "Save as", type in your new file name, and then click Save. Your 2003 presentation will now be in 2010 and you'll be able to use all the enhancements available. http://www.microsofttraining.net/tip-693-compatibility-mode-in-2010.html Wed, 10 Oct 2012 00:00:00 GMT http://www.microsofttraining.net/tip-693-compatibility-mode-in-2010.html When you want to send an image in an email, start by writing your message then click the Insert tab on the Ribbon, next click Screenshot. A box will appear showing you all the current windows you have open on your desktop, choose the one you want then press Enter. http://www.microsofttraining.net/tip-688-inserting-screenshots-in-outlook.html Thu, 27 Oct 2011 00:00:00 GMT http://www.microsofttraining.net/tip-688-inserting-screenshots-in-outlook.html If you want Outlook to automatically close the message window after each time you send a reply, click on File, then Options, then Mail, then scroll down to Replies and Forwards and check ''Close original message window when replying or forwarding.'' http://www.microsofttraining.net/tip-689-auto-close-outlooks-message-window.html Thu, 27 Oct 2011 00:00:00 GMT http://www.microsofttraining.net/tip-689-auto-close-outlooks-message-window.html If you prefer not to have hundred's of messages pile up in your Deleted Items folder in Outlook 2010, click on the File menu, then Options, then click Advanced, find the Outlook Start and Exit section. Check the box next to Empty Deleted Items folder when exiting Outlook. http://www.microsofttraining.net/tip-690-auto-emptying-outlooks-bin.html Thu, 27 Oct 2011 00:00:00 GMT http://www.microsofttraining.net/tip-690-auto-emptying-outlooks-bin.html