98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Microsoft Office articles
Discovering New Things In Office All The Time
Tue 24th May 2011
Word
I've been using Word longer than any other Office application and I consider myself to be fairly adept in its use. What I have only recently discovered, however, is that it is possible to show the boundaries of the text on the page. This simple action will create a box consisting of a tightly dotted line to mark the boundaries of the text on that document.
To see these boundaries, select Tools/Options and click on the View tab. In the Show menu, under the Print and Web Layout Options, check the Text Boundaries box and click OK. You will now be able to see exactly how much of the page area your text will take up.
Excel
I mentioned recently that I have created a monthly spreadsheet to keep track of my finances. After I set up January's worksheet I created a few simple formulas that would tell me how much I had left after certain bills were paid and so on. I then wanted to copy and paste the same spreadsheet into each of the following months. I wanted to delete all of the numbers I had entered in January's sheet, but I also wanted to keep the formulas. I knew there would be a way to do this and I found it.
After pasting January's spreadsheet into February's worksheet, I clicked on Edit/GoTo (Ctrl +G), and then on the Special button. In the dialog box I clicked on the Constants radio button and unchecked all of the boxes except the Numbers one. When I clicked OK, Excel had highlighted all of the values in the spreadsheet that had no formula attached. I clicked Delete and the spreadsheet was devoid of numbers, but the formulas were intact and ready to take the new values.
PowerPoint
I recently came across a neat little trick in PowerPoint that places a picture inside a shape. Open up any shape from the AutoShapes menu, although obviously something with a spacious inside area works best; a heart shape or a five sided star for example.
Pull out the shape to the required size and then right click and select Format AutoShape. From the dialog box select the Colours and Lines tab and in the Fill section, click on the down arrow to open up the colour palette. Select Fill Effects and then the Picture tab. Click on Select Picture and browse for the picture you want as in any other application.
When you have found the picture you want to use, select it and click OK. Then back in the Format AutoShape dialog box click OK again and the picture will appear inside the shape. Going back to the Format AutoShape dialog box, you can adjust the colour and weight of the line around the shape for extra effect.
Visio
In a previous article I did on planning an office layout with Visio, I expressed surprise that among the usual office equipment that could be dragged onto the page, computers, telephones, printers etc, there was even a selection of plants that could be positioned around the office. I have since discovered that these plants can actually be ungrouped and different colours applied to the pot, plant and soil to match whatever you have in your office.
What this means is that if you go away on holiday and you forget to have someone water your office plant, when you return you can update your office plan by changing the leaves on the plant from green to yellow to reflect the colour of the actual plant.
I think it is safe to say that these will not be the last of my Office discoveries.
Author is a freelance copywriter. For more information on microsoft training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1694-discovering-new-things-in-office-all-time.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsArdent Consulting Ltd
George Kirwan Dreamweaver Introduction (2 days) I have really enjoyed the course so far. It will be of great help to me in my business and my social activities Carphonewarehouse
Paul B Access VBA Knew the subject matter, had good exercises to do and also good practices. Crown Prosecution Service
Crown Advocate Peter Hussey Office 365 End User I thought today's course was gauged well to match different individuals' various needs, which was helped by not having too many delegates. There is a lot of material, and people have very different needs / experience / familiarity with the topics covered. Thanks for your help! |
PUBLICATION GUIDELINES