converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Tips and Tricks – December 2017

Wednesday January 3, 2018 at 8:44am
Windows

If you have programs (e.g. Internet Explorer, Word, Excel) pinned to your TaskBar, hold the Windows Logo key and press 1 to start the first program, Windows Logo + 2 for the second and so on.

Excel

Struggling to understand a complex formula? Select the cell containing the formula and click "Evaluate Formula" on the Formulas tab. This will show you the steps Excel follows to arrive at the final result.

Word

Do you need a non-numbered paragraph in the middle of a numbered list? Type the whole numbered list, including the paragraph that doesn't need a number. Then place the cursor at the beginning of the text for that paragraph and press Backspace once. The number will disappear and the following numbers will adjust accordingly.

Outlook

If you have the standard Navigation options: Mail, Calendar, People, Tasks at the bottom left of your Outlook screen, press CTRL+1 to switch to the first item (normally Mail), CTRL+2 for the second and so on.

PowerPoint

Need to show someone how to complete a task on their computer when they are not with you? Try the Screen Recording feature on the Insert tab, which allows you to record a video of your screen as you demonstrate how to complete the task (PowerPoint 2013 onwards)

Access

Are your Properties and formulas difficult to read - Access uses an 8-point font for many things, which is not always easy to read. Select the property you want to view or modify and press SHIFT+F2 to open the Zoom box where you can increase the font size temporarily.

Comments

There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 21 - 4?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd