|
Trying to set up records for the coming year? Microsoft offers free
templates for Word, Excel, PowerPoint, and other Office programs, which can
help you set up records in a number of categories:
 |
Academic records |
|
|
Financial records |
|
|
Home records |
|
|
Human Resources records |
|
|
Journals |
|
|
Ledgers |
|
|
Logs |
|
|
Medical and health care records |
And more.
Click to download record templates
Gearing up for the new year? Microsoft has a collection of templates
for creating calendars using Word, Excel. PowerPoint, Access, and other
programs. You can download them for free. Check it out.
Click to download free calendar templates
In Office 2010 –
Word, PowerPoint and Excel –
you can recolor a
picture, adjust the color saturation and tone, and more! Here's how:
|
|
Select the picture you want to recolor |
|
|
Click the Picture Tools Format tab on
the Ribbon |
|
|
In the Adjust group, click Color |
|
|
Select one of the many options, for
example: |
Here are some more resources to help you switch from Office 2003 to the
new Office 2010.
How to Find Office 2003 Commands in Office 2010 This is a "how to"
article from
www.howtogeek.com. If you scroll to the bottom of this article
you will find the following links to free information from Microsoft.
Office 2010 interactive guide
Download Office 2010 reference workbooks
There are a lot of great resources to help you learn Office 2010.
Custom Guide Online
Learning has created printable 2-page quick reference guides which you
can download for free. Give it a try.
Word 2010
Excel 2010
PowerPoint 2010
Screenshot -- a new feature in Office 2010 -- allows
you to capture images from your screen.
|
|
Click the document that you want to add the
screenshot to |
|
|
Click the Insert tab on the Ribbon |
|
|
In the Illustrations group, click Screenshot |
|
|
To add the whole window, click the thumbnail in
the Available Windows gallery |
|
|
To add part of the window, click Screen
Clipping, and when the pointer becomes a cross, press and hold the
left mouse button to select the area of your screen that you want to
capture |
|
|
If you have multiple windows open, click the
window you want to clip from before clicking Screen Clipping.
When you click Screen Clipping, the program you are working in is
minimized and only the window behind it is available for clipping |
|
|
After adding a screenshot, you can use the
tools on the Picture Tools tab to edit and enhance the screenshot |
You can use Screenshot in Word 2010, PowerPoint 2010 and Excel 2010.
Office 2010 allows you to customize the Ribbon in Excel, Word, and
PowerPoint. Here's how:
|
|
Click the File tab on the Ribbon
|
|
|
Click Options to display the Options dialog box
|
|
|
Click Customize the Ribbon
|
|
|
Select the command you want to add to the
Ribbon |
|
|
Click the tab where you want the command added
and click new group -- commands can only be added to custom groups
(you can even create a new custom tab if you want to)
|
|
|
Click Add |
|
|
Click OK when you are finished adding commands
to the Ribbon
|
SmartArt is a new feature in Office 2007. It’s easy to
use and available in Word, Excel and PowerPoint. It can be used to create
organization charts and time lines, to show sequential tasks, and much more.
These resources can help you get started:
Create a SmartArt graphic “How to” article from
Microsoft.com
Demo: Spice up your text with SmartArt graphics Demo with audio from
Microsoft.com
Microsoft Office PowerPoint 2007 introduces SmartArt graphics
Online training from
Microsoft.com
Exploring Office 2007: Using SmartArt Graphics Article by Helen Bradley
from
SmallBusinessComputing.com
An excellent resource for learning Office 2007 is a
set of Cheat Sheets published by
ComputerWorld. Whether you’re just making the switch to 2007 or a
seasoned user, you’re certain to find many useful tips and tricks.
Word 2007 Cheat Sheet
Excel 2007 Cheat Sheet
PowerPoint 2007 Cheat Sheet
|
|
Right click on any command |
|
|
Select Add to the Quick Access Toolbar from the
shortcut menu |
This trick works in Microsoft 2007 Word, Excel,
PowerPoint, and Access.
Microsoft Office Online offers a number of templates
specifically designed for the New Year which can be freely download.
These include greeting cards, postcards, shipping labels, address labels,
banners, invitations, menus, labels for CD's, email messages, and even one
for New Year's resolutions. You can find templates for Word, PowerPoint, Publisher,
OneNote and Outlook.
Click here to check it out!
The Office 2007 Ribbon can take up a lot of space on the screen.
But it doesn't have to! To Minimize the Ribbon
 |
Right click on the Ribbon |
|
|
Select Minimize the Ribbon |
There’s a lot of controversy
about whether the new way of doing things in Office 2007 is an improvement
or not. But the fact remains. It’s here to stay.
The former pull-down menus and toolbars have been
replaced by the Ribbon. Apparently there’s
no option to revert to the "classic" Office interface. So we're all just
going to have to accept it.
If you’re making the
transition to Office 2007 check out
Getting to know you...again: The Ribbon posted on
office.microsoft.com. This article is rich with links to training
guides, videos, and other learning resources. Or
An introduction to the Microsoft Office 2007 ribbon interface posted on
techrepublic.com.
Many people are wondering whether to upgrade to Office
2007. In an earlier tech tip we shared an article from PC World
Microsoft Office 2007: A Worthy Upgrade This redesigned productivity suite
is powerful and full featured, once you get used to the changes.
However, there are good reasons NOT to make the switch to the latest version
of Microsoft Office. In an article published on
www.itwire.com, the author discusses five of the most compelling reasons
NOT to switch, at least not yet. Read
Five
reasons not to upgrade to Office 2007 and decide for yourself.
It's easy to share information between Word, Excel and PowerPoint. For
example, if you want to use information from a PowerPoint slide in a Word
document, just insert a copy of the entire slide in your Word document.
|
|
Open your PowerPoint presentation |
|
|
Using Slide Sorter view, select the
slide you want to copy |
|
|
Click the Copy button (or press Ctrl + c)
to copy the slide to the clipboard |
|
|
Switch to your Word document |
|
|
Click where you want the slide to
appear |
|
|
Click the Paste button (or press
Ctrl + v) to paste the slide from the clipboard |
OR instead of pasting a copy of the slide, after copying the slide to the
clipboard:
|
|
In Word, choose Edit from the
pull-down menu and choose Paste Special |
|
|
From the Paste Special dialog box
select Paste Link and choose As Microsoft PowerPoint Slide Object
|
Choose Paste Link ONLY if you would like the slide to change in your Word
document if you change the slide in your PowerPoint presentation. If you do
NOT, use the first method and just copy the slide into your Word document.
Many people are wondering whether to upgrade to the new
Microsoft Office 2007. PC World recently tackled the issue in
Microsoft Office 2007: A Worthy Upgrade This redesigned productivity suite
is powerful and full featured, once you get used to the changes.
For complete details about Microsoft Office
Professional 2007, including: product guide, system requirements, frequently
asked questions, and a free download so you can test drive before you buy,
go to
office.microsoft.com.
One of my favorite resources is the Microsoft Knowledge Base. You can
search 100’s of thousands of articles by a specific product by clicking
Select a Product. Or do a more advanced keyword search by clicking
Advanced Search. If you’re having a problem that seems unsolvable,
give it a try. Go to
support.microsoft.com/search/
Introduced in the release of Office 2000 was the annoying delayed menus
feature. When you choose a pull-down menu the program only displays the
most recently used commands. If you wait three seconds or click on the
double arrow at the bottom of the list, it will display the rest of the
commands available under that menu item.
To turn this feature off:
 |
Choose
Tools from the pull-down menus. |
|
|
Select Customize. |
|
|
Click
the Options tab. |
|
|
Select
the Always show full menus check box. |
Note: Changing this setting affects all of your Microsoft Office
programs.
Office programs allow you to create hyperlinks to
external Web sites. Here's a quick way to insert a Web site address:
|
|
Select the text you want to link and press CTRL+ K |
|
|
In the Insert Hyperlink dialog box, make sure the
insertion point is in the Address box |
|
|
Start your browser, and open the Web site you want
to link to |
|
|
Select the Web site address and press Ctrl + C to
copy it to the clipboard |
|
|
Switch back to the Office document. Press Ctrl V to
copy the Web site address in the Address box of the Insert Hyperlink
dialog box |
|
|
Click OK |
Note: In some browsers the link may appear
automatically without the need to copy and paste from the clipboard. This
tip works in most Office programs.
Microsoft FrontPage, PowerPoint, Word and Excel provide a variety of
drawing tools. Use AutoShapes and Shadow Style to create effects for your
Web site, presentation or document. With the auto-shape "Callouts", you can
put dialog balloons together with photos to add interest to your pages.
To make a text balloon or "callout" like the one in the picture below,
select the Drawing icon from the main toolbar to start a new drawing then:
- In Page view, click on AutoShapes, then Callouts and select a choice.
- Place your cursor in the new drawing canvas on your page and click to
create your callout shape.
- Click on the callout shape to select it, then click the Fill Color
(paint bucket) icon in the Drawing Toolbar and select the color you want
to fill the shape with.
- Reselect your callout shape, click the Shadow Style icon on the
Drawing Toolbar and select a drop shadow choice.
- Reselect your callout shape and type or paste text.
|
