Header
spacer   spacer
To help you get the most from Microsoft Office, we’ve gathered answers to the ten most frequently asked questions for the most commonly used applications and put them in one convenient location. With these tips and operation techniques, plus links to other additional resources, you’ll be on your way to increased productivity.
spacer
       
       
  Nav Header    
 
Excel
Word
PowerPoint
Outlook
 

 
Excel
Find new features, tips on formatting charts, numbers, and style outlines, plus other helpful descriptions to help you maximize this powerful spreadsheet program.
spacer
microsoft office excel - top 10 questions
How do I format text in Excel?...[more]
How do I format numbers?...[more]
How do I add styles?...[more]
How do I create and format charts?...[more]
How do I sort and filter data?...[more]
How do I set up pages, margins, and print area?...[more]
How do I use the Function Library?...[more]
How do I show gridlines and rulers?...[more]
How do I create a chart from existing Excel file data?...[more]
How do I copy a chart from Excel to PowerPoint and Word?...[more]
Additional Excel Resources
Webcast: A "First Look" at Five Important Features in Microsoft Office Word 2007, Excel 2007, and PowerPoint 2007 [Link]
Webcast: Advanced Tips and Tricks for Fast and Fabulous Excel Charts.[Link]
Webcast: Advanced Tips and Trick for the 2007 Office System: Customize Your Word, Excel, and PowerPoint Documents in No Time [Link]
Webcast: Top 5 New Features of the 2007 Microsoft Office Release (Excel) [Link]
Course 4623: What's New in Microsoft Office Excel 2007 [Link]
More Microsoft Office Excel 2007 Courses [Link]
Keyboard Shortcuts [Link]
Demo: Up to speed with Excel 2007 [Link]
Microsoft Office Excel 2007 Product Guide [Link]
2007 Microsoft Office System Learning Portal [Link]

If you are running the 2007 Microsoft Office system, push F1 on your keyboard at any time to go directly to Office Online Help.

Back To Top

 
Excel
Add illustrations to your Word documents, format page numbers, styles, and tables, and easily change page backgrounds. Make your communications speak for you with these helpful tips and more.
spacer
microsoft office Word - top 10 questions
How do I format text?...[more]
How do I change margins and indents?...[more]
How do I add and change styles?...[more]
How do I add an illustration?...[more]
How do I create and format a table?...[more]
How do I change a page background?...[more]
How do I add page numbers?...[more]
How do I add and edit headers and footers?...[more]
How do I insert bullets and numbering?...[more]
How do I proof and edit?...[more]
Additional Word Resources
Webcast: Top 5 New Features of the 2007 Microsoft Office Release (Word)...[more]
Webcast: A "First Look" at Five Important Features in Microsoft Office Word 2007, Excel 2007, and PowerPoint 2007 [Link]
Course 4628: What's New in Microsoft Office Word 2007? [Link]
Overview of Word 2007 [Link]
Advanced Tips and Tricks for Creating Custom Documents with Word 2007 [Link]
Interactive: Word 2003 to Word 2007 Command Reference Guide [Link]
Demo: Up to speed with Word 2007 [Link]
Microsoft Office Word 2007 Product Guide [Link]
Quiz: Word 2007 Basics [Link]
2007 Microsoft Office System Learning Portal [Link]

If you are running the 2007 Microsoft Office system, push F1 on your keyboard at any time to go directly to Office Online Help.

Back To Top

 
Excel
From creating a custom template to learning to add themes and insert files and pictures, everything you need to know about PowerPoint is here.
spacer
microsoft office Powerpoint - top 10 questions
How do I format text?...[more]
How do I create and format a table?...[more]
How do I insert files and pictures?...[more]
How do I create charts from data?...[more]
What is SmartArt and how do I create it?...[more]
What is the Format Painter and how do I use it?...[more]
How do I add themes to my slides?...[more]
How do I insert bullets and numbering?...[more]
How do I change the look of a document?...[more]
How do I create a template from a custom layout?...[more]
Additional PowerPoint Resources
Top 5 New Features of the 2007 Microsoft Office Release (PowerPoint) [Link]
Webcast: A "First Look" at Five Important Features in Microsoft Office Word 2007, Excel 2007, and PowerPoint 2007 [Link]
Course 4627: What's New in Microsoft Office PowerPoint 2007? [Link]
Training: Create your first presentation [Link]
Webcast: Advanced Tips and Tricks for Incredible PowerPoint 2007 Presentations in No Time [Link]
Microsoft Office PowerPoint Product Guide [Link]
2007 Microsoft Office System Learning Portal [Link]

If you are running the 2007 Microsoft Office system, push F1 on your keyboard at any time to go directly to Office Online Help.

Back To Top

 
Excel
Find simple ways to make every day easier with these organizational shortcuts and numerous formatting suggestions, all designed to help you get the most from your busy day with Outlook.
spacer
microsoft office Outlook - top 10 questions
How do I enable and use Instant Search?...[more]
How do I set rules and alerts?...[more]
How do I manage my junk e-mail?...[more]
How do I format text?...[more]
How do I attach a file to my e-mail messages?...[more]
How do I create and add a signature to my e-mail messages?...[more]
How do I create new folders?...[more]
How do I add other e-mail accounts to Outlook?...[more]
How do I create Address Books items?...[more]
How do I create Calendering items?...[more]
Additional Outlook Resources
Webcast: Top 5 New Features of the 2007 Microsoft Office Release (Outlook) [Link]
Webcast: A First Look at Microsoft Office Outlook [Link]
Webcast: A "First Look" at Five New E-Mail and Collaboration Features in the 2007 Microsoft Office System [Link]
Training presentation: Outlook 2007—Get up to speed [Link]
Course 4626: What's New in Microsoft Office Outlook 2007 [Link]
2007 Microsoft Office System Learning Portal [Link]
Microsoft Office Outlook 2007 Product Guide [Link]

If you are running the 2007 Microsoft Office system, push F1 on your keyboard at any time to go directly to Office Online Help.

Back To Top


 
     
     
     
     
Footer
corner
spacer corner
arrow
Defining conditional formats in Excel
Using the Ribbon to format
Add formatting to your document by using the Mini toolbar
Wrap text in a cell
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Available number formats
Combine text and numbers
Display numbers as currency
Display numbers as fractions
Display numbers as percentages
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Apply, create, or remove cell style
Apply or customize a document theme
Add or delete a fill, outline, or effect for text or WordArt
Add or delete arrowheads
Format a table
Change the color, style, or weight of a line
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Making changes to an existing chart
Create an Excel Chart
Overview of Charting
Charting tools
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Filter data in a range or table
Filter for unique values or remove duplicate values
Sort data in a range or table
Filter by using advanced criteria
Add, change, or clear conditional formats
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add, delete, or move page breaks
Set page margins in Page Layout View
Change page orientation in Page Layout View
Print a worksheet or a workbook
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Create or delete a formula
Overview of formulas
Examples of commonly used formulas
List of worksheet functions by category
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Hide or display gridlines, row headings and colum headings in Page Layout View
Use rulers in Page Layout View
Print with or without cell gridlines
Display or hide chart gridlines
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Tips and tricks for creating dynamic diagrams
DEMO: Create charts in Excel 2007
Training: Creating charts in Excel 2007
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Copy and paste multiple items by using the Office Clipboard
Move or copy cells or cell contents
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Adding formatting to your document by using the Mini toolbar
Make text superscript or subscript
Use automatic formatting as you type
Change the bullet or number formatting
Demo: Make documents look great in Word 2007
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Indent paragraphs
Change or set page margins
Adjust spacing between a list bullet or number and the text
Set tab stops
Change the layout or formatting in one section of your document
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Change the layout or formatting in one section of your document
Add and remove styles from the Quick Styles gallery
Create a new Quick Style
Apply a style
Apply or change a Quick Style for shapes
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add a drawing to a document
Demo: Spice up your test with SmartArt graphics
Scan and insert an image in Clip Organizer
Insert a picture or clip art
What happened to the From Scanner Camera option for adding pictures to a document?
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Insert or create a table
Demo: Make documents look great in Word 2007
Draw a table
Format a table
Move or copy a table
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Brand a document with a watermark or background
Format the background of your SmartArt grapic
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Insert page numbers
Remove page numbers
Remove the page number from the first page
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Insert or delete a footnote or an endnote
Insert headers or footers
My header or footer is missing
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add bullets to a shape
Change the bullet or number formatting
Convert bullets to numbers and vice versa
Restart footnote or endnote numbering from 1
Turn on or off automatic bullets or numbering
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Turn on or off change tracking
Track changes while you edit
Prevent changes to a final version of a document
Review tracked changes and comments
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Adding formatting to your document by using the Mini toolbar
Use automatic formatting as you type
Apply bold, italic, or underline formatting to text
Save a presentation in Rich Text Format (RTF)
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add a table to a slide
Change the look of a table
Add or delete table rows, columns, or cells
Move or resize a table
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Scan and insert an image in Clip Organizer
Insert a picture or clip art
Add or move a file
Insert outline text from another program into your PowerPoint presentation
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Create, apply, or remove a chart or template
Available chart types
Change the chart type of an existing chart
Overview of charting
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Creating a SmartArt graphic
Moving a SmartArt graphic
Keyboard shortcuts for SmartArt graphics
Resizing a shape or an entrie SmartArt graphic
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add formatting to your document using the Mini toolbar
Use the Format Painter to copy the look and style of text
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Apply a built-in theme to a slide master
Apply or customize a document theme
Delete a custom theme
Demo: Apply your office brand to Office documents with themes
All about themes, Quick styles, cell styles, and background styles
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add bullets to a shape
Add formatting to your document by using the Mini toolbar
Use automatic formatting as you type
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
All about themes, Quick Styles, cell styles, and background styles
Apply or customize a document theme
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Create a template
Apply or customize a document theme
Overview of layouts
Add a layout
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Demo: Using Instant search to find items quickly
Configure Instant Search options in Outlook 2007
Find a message or item by using Instant Search
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Demo: How to set-up inbox rules and alerts
Turn on or off Desktop alerts
Turn a rule on or off
Turn an Out of Office Assistant rule on or off
Manage messages by using rules
Create a backup copy of your rules
Turn sound effects on or off
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Updating junk e-mail filters in Outlook 2007
Overview of the Junk E-mail Filter
10 tips on how to reduce spam
Change the level of protection in the Junk E-mail Filter
Include my contacts as Safe Senders
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Format your e-mail messages for clarity
Add formatting to your document by using the Mini toolbar
Change the font, font size, or font color
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Preview, open, change, and save attachments
Attaching a file or other item to an e-mail message
Insert or attach items to your e-mail message
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Create Electronic Business Cards
Create a signature for outgoing messages
Stop using an automatic signature
Sample signatures for Outlook
Training: Create great-looking signatures for your e-mail
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Creating a search folder
Add or remove folders in Favorite Folders
Create a new folder
Set or rename a default working folder
Move an item to another folder
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Add or remove an e-mail account
Introduction to e-mail account types
Choose which e-mail account to use to send a message
Review or change e-mail account settings
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Create a contact
Add names to Contacts from an open message
Add or remove an address book
Forward a contact
spacer
Bottom Left Corner spacer Right Bottom Corner
corner
spacer corner
arrow
Schedule an appointment
Set or remove reminders
Schedule a meeting
Make an appointment or meeting private
Create an all-day event
spacer
Bottom Left Corner spacer Right Bottom Corner