[June 1, 2009]
It's just a beautiful day here and I have spent the better part of it potting flowers for my front porch. The sun is shining and the birds are singing - my favorite kind of day!
Please remember that if you are having a problem with an MS Office application, please let me know. I will be more than happy to help you with the resolution. Alternatively, if you have a great tip you would like to share, please send it along and I will give you credit in the issue in which it appears.
Also, please remember that premium subscribers, receive big discounts on all my books and tutorials and be on the lookout for some new ones! Shouldn't YOU be a premium subscriber?
Let's get to the tips now!
Table of Contents
Add a Smart Column in MS Excel 2007 - Aren't they all smart??
Add AutoText to the Toolbar in MS Word 2007 - Very Easily Done!
View AND Edit a Presentation in MS PowerPoint 2007 Simultaneously - Not a problem!
 |
|
Add a Smart Column in MS Excel 2007
Adding a new column to an MS Excel table is as easy as falling off a log!
Follow the steps below:
- Place a formula, such as SUM, in the first cell of a new data column.
- That formula is then automatically applied to all the cells in that column, which can also be sorted and filtered.
- Add another column and use a different formula, such as AVERAGE, to create a column that leaves out the SUM totals you already added.
Very simple isn't it?
Add AutoText to the Toolbar in MS Word 2007
You can make AutoText very easy to find on the Quick Access Toolbar (QAT). Follow the steps below to learn how:
- Click on the Office Button | Word Options | Customize.
- Under Choose commands from look for All Commands.
- Scroll until you see AutoText and click Add.
You will now have a drop-down box to select from!
View & Edit a Presentation in MS PowerPoint at Once
In the latest version of MS PowerPoint, you are able to view your presentation and edit it at the very same time. This is an extremely useful feature in my estimation. Sometimes you cannot really judge whether a presentation is effective until you see it in action.
Follow the steps below to learn how to utilize this great 2007 PowerPoint feature:
- Click on the View tab and depress and hold the Control key as you click the Slideshow button.
This will now display the presentation in the top left of the screen, allowing you to move between viewing your presentaiton and editing it.
Included in the Premium Newsletter:
- Automatic Recalculation in MS Excel 2007
- Another Method of Automatic Recalculation
- Easy Method of Applying and Seeing Keep with Next Formatting in MS Word
- Reset Your Text to Columns Settings in MS Excel
- Invert Your File Selections in Windows Explorer
- FREE Dictionaries
Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.