We know your productivity can have a lot to do with how you work with your Microsoft Office software. We’ve gathered answers to the ten most frequently asked questions—for the ten most commonly used Office applications—and made them easier than ever to access. Use these tips, techniques, and additional resources to get the most out of the Microsoft Office programs you depend on every day.

View the top 10 questions for each of the products below.

• Excel
• PowerPoint
• SharePoint
• Groove
• OneNote
• Outlook
• Word
• Access
• InfoPath
• Publisher

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

View your information like never before.

Take advantage of this powerful application for creating and formatting spreadsheets with a look at the new features and interface, hints on formatting, and tips on how you can analyze and share information to make more informed decisions.

• How do I format text?
• How do I format numbers?
• How do I create cell styles?
• How do I create and format charts?
• How do I sort and filter data?
• How do I set up pages, margins, and print area?
• How do I use functions?
• How do I show gridlines and rulers?
• How do I create a chart from existing Excel file data?
• How do I copy a chart from Excel to PowerPoint and Word?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I format text?

  • Format text as bold, italic, or underlined
  • Use automatic formatting as you type
  • Change the font or font size in Excel
  • Add formatting to your document by using the Mini toolbar
  • Copy the formatting of an object, worksheet cell, or text by using Format Painter

   

• How do I format numbers?

  • Available number formats
  • Use automatic formatting as you type
  • Convert numbers stored as text to numbers
  • Add, change, or clear conditional formats
  • Combine text and numbers

   

• How do I create cell styles?

  • Apply, create, or remove a cell style
  • Design effective cell styles in Excel 2007
  • All about themes, Quick Styles, cell styles, and background styles
  • Ways to format a worksheet

   

• How do I create and format charts?

  • Training: How to create charts in Excel 2007
  • Create a chart
  • Create, apply, or remove a chart template
  • Demo: Create charts in Excel 2007
  • Change the chart type of an existing chart

   

• How do I sort and filter data?

  • Sort data in a range or table
  • Reapply a filter and sort, or clear a filter
  • Filter data in a range or table
  • Filter by using advanced criteria
  • Guidelines and examples for sorting and filtering data by color

   

• How do I set up pages, margins, and print area?

  • Define or clear a print area on a worksheet
  • Set page margins or center a worksheet on a printed page
  • Preview a page before printing
  • Add, delete, or move page breaks
  • Preview worksheet pages before printing

   

• How do I use functions?

  • Summing up ways to add and count Excel data
  • List of worksheet functions (by category)
  • Summary functions available in PivotTable reports
  • Create or delete a formula
  • Create conditional formulas

   

• How do I show gridlines and rulers?

  • Hide or display cell gridlines on a worksheet
  • Print with or without cell gridlines
  • Display or hide chart gridlines
  • Use Page Layout view to fine-tune pages before printing

   

• How do I create a chart from existing Excel file data?

  • Web cast: Tips and tricks for creating dynamic diagrams
  • Demo: Create charts in Excel 2007
  • Training: How to create a chart in Excel 2007
  • Create a chart
  • Create, apply, or remove a chart template

   

• How do I copy a chart from Excel to PowerPoint and Word?

  • Copy Excel data or charts to Word
  • Copy Excel data or charts to PowerPoint

   

• More Resources

  • Excel Add-in
  • Course 5444: What's New in Microsoft Office Excel 2007
  • Excel 2007 Course list
  • Excel shortcut and function keys
  • Demo: Up to speed with Excel 2007
  • Microsoft Office Excel 2007 product guide
  • Top Ten Ways to Clean your Data
  • Interactive: Excel 2003 to Excel 2007 command reference guide
  • Web casts: Tips and Tricks for Office 2007
  • Locate the Product ID for your Office Program
  • Test drive the 2007 Microsoft Office release
  • Collection 5259: Core training for Microsoft Office Excel 2007
  • Collection 5265: What's New in the Microsoft Office 2007 System
  • Excel 2003 to Excel 2007 interactive command reference guide
  • Mini Web cast: Top 5 New Excel Features
  • Mini Web cast: Excel side by side: What's New & Different
  • Mini Web cast: Tables and Charts in Excel
  • Data Sheet: Top 10 benefits of Microsoft Office Excel 2007
  • Podcast: Top 10 tips for Microsoft Office Excel 2007

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Give them the presentation they’ve been waiting for.

Discover how custom layouts, powerful diagrams and graphics, and professional-looking themes make it easy to create high-impact, dynamic presentations—then learn how simple it is to share your information with those who need it.

• How do I format text?
• How do I create and format a table?
• How do I insert files and pictures?
• How do I create charts from data?
• What is SmartArt and how do I create it?
• What is the Format Painter and how do I use it?
• How do I add themes to my slides?
• How do I insert bullets and numbers?
• How do I change the look of a document?
• How do I create a template from a custom layout?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I format text?

  • Adding formatting to your document by using the Mini toolbar
  • Apply bold, italic, or underline formatting to text
  • Copy the formatting of an object, worksheet cell, or text by using Format Painter
  • Use automatic formatting as you type
  • Clear all text formatting

   

• How do I create and format a table?

  • Add a table to a slide
  • Add or delete table rows, columns, or cells
  • Move or resize a table
  • Change the look of a table
  • Demo: Work with tables in a document, presentation, or message

   

• How do I insert files and pictures?

  • Insert outline text from another program into your PowerPoint presentation
  • Add a slide from a file
  • Add a picture to a SmartArt graphic
  • Add a background to your presentation

   

• How do I create charts from data?

  • Create, apply, or remove a chart template
  • Overview of charting
  • Available chart types
  • Change the chart type of an existing chart

   

• What is SmartArt and how do I create it?

  • Training: Get visual with SmartArt graphics
  • Demo: Spice up your text with SmartArt graphics
  • Create a SmartArt graphic
  • Save a SmartArt graphic
  • When should I use a SmartArt graphic and when should I use a chart?

   

• What is the Format Painter and how do I use it?

  • Copy the formatting of an object, worksheet cell, or text by using Format Painter
  • Clear all text formatting
  • Use automatic formatting as you type

   

• How do I add themes to my slides?

  • Apply a built-in theme to a slide master
  • Apply or customize a document theme
  • Delete a custom theme
  • Demo: Apply your brand to Office documents with themes
  • Training: Personalize your slide design

   

• How do I insert bullets and numbers?

  • Add formatting to your document by using the Mini toolbar
  • Use automatic formatting as you type
  • Adjust the indent in a bulleted or numbered list on the ruler
  • Change the starting slide number
  • Training presentation: Bullets, numbers, and lists

   

• How do I change the look of a document?

  • All about themes, Quick Styles, cell styles, and background styles
  • Change a style
  • Apply a style
  • Demo: Apply your brand to Office Documents
  • Apply a template to a new presentation

   

• How do I create a template from a custom layout?

  • Create a new file from a template
  • Apply or customize a document theme
  • Create, apply, or remove a chart template

   

• More Resources

  • PowerPoint Add-in
  • Course 5448: What's New in Microsoft Office PowerPoint 2007
  • Training: Create your first presentation
  • Microsoft Office PowerPoint product guide
  • Locate the Product ID for your Office Programs
  • Roadmap to building a PowerPoint 2007 presentation
  • Create a basic presentation in PowerPoint 2007
  • Test drive the 2007 Microsoft Office release
  • Collection 5260: Core Training for Microsoft Office PowerPoint 2007
  • PowerPoint 2003 to PowerPoint 2007 interactive command reference guide
  • Microsoft Office 2007 tips and tricks Web casts
  • Mini Web cast: Top 5 New PowerPoint features
  • Mini Web cast: PowerPoint side by side: What's New & Different
  • Mini Web cast: Working with Microsoft Visio and Microsoft PowerPoint Diagrams
  • Data Sheet: Top 10 Benefits of Microsoft Office PowerPoint 2007
  • Podcast: Top 10 Tips for Microsoft Office PowerPoint 2007

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Get a clearer view of your business.

Explore how this integrated suite of server capabilities can help improve organizational effectiveness, with suggestions on managing content, sharing critical business information, and extending the ways you work with colleagues, partners, and customers.

• What is Office SharePoint Designer?
• How do I create a SharePoint site?
• How do I customize my SharePoint site?
• How do I create a Master Page?
• What is My Site?
• How do I use the Library?
• What is a content type?
• How do I organize meetings with SharePoint?
• How can I effectively search for information on SharePoint sites?
• How do I use Group Approval?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• What is Office SharePoint Designer?

  • Introducing Microsoft Office SharePoint Designer 2007
  • Micorosft Office SharePoint Designer 2007 product overview
  • SharePoint Designer Demo
  • Microsoft Office SharePoint Designer 2007 version comparison

   

• How do I create a SharePoint site?

  • Create a SharePoint site
  • Add a page to a SharePoint site
  • Open a SharePoint site
  • Get started with basic site customizations
  • View your contributor settings
  • Add another SharePoint site to the Data Source Library

   

• How do I customize my SharePoint site?

  • Get started with basic site customizations
  • Apply a custom sheet to a SharePoint site
  • Track customized master pages
  • Create a site content type
  • Create a page layout

 

• How do I create a Master Page?

  • Sample Master pages overview
  • Create a site Master page
  • Create or edit a Master page
  • Save a site as a site template

   

• What is My Site?

  • Introduction to My Site
  • Information privacy on My Site
  • Work with the colleagues list on My Site
  • Manage your documents and tasks on your My Site
  • Set or change your default My Site

   

• How do I use the Library?

  • Introduction to libraries
  • Set up a template for a library
  • Create a form library
  • Organize files in a library
  • Types of files that cannot be added to a library

   

• What is a content type?

  • Introduction to content types
  • Create a site content type
  • Add an existing content type to a list or library
  • Change a content type for a list or library
  • Turn on support for multiple content types in a list or library

   

• How do I organize meetings with SharePoint?

  • Create a Meeting Workspace site
  • Customize a Meeting Workspace site
  • Add, change, and delete pages in a Meeting Workspace site
  • Manage the attendees in a Meeting Workspace site
  • Assign and track tasks in a Meeting Workspace site

   

• How can I effectively search for information on SharePoint sites?

  • Search for content
  • Tips for effective searches
  • Search for text and files on a site
  • Specify a unique search results page
  • Add search keywords and Best Bets

   

• How do I use Group Approval?

  • Activate Group Approval
  • Deactivate Group Approval
  • Admin help for Group Approval
  • Create approval roles
  • Frequently asked questions and answers

   

• More Resources

  • SharePoint team blog
  • SharePoint Books
  • SharePoint Community Portal
  • SharePoint Discussion Forums
  • Introduction to Office SharePoint Server 2007
  • Discussions in SharePoint Portal Server General Questions
  • SharePoint Server 2007 Help and How-to
  • SharePoint Server 2007 Trial Version
  • How to buy Microsoft Office SharePoint Server 2007
  • Microsoft Office SharePoint Server 2007 top 10 Benefits
  • Compare features of Office SharePoint 2007 to SharePoint Portal Server 2003
  • Office SharePoint Server 2007 Virtual Labs
  • Collection 3376: Implementing Enterprise Search Using SharePoint Technologies
  • Collection 5404: Implementing Microsoft Office SharePoint Server 2007
  • Mini Web cast: Top 5 New Features—SharePoint
  • Mini Web cast: Windows SharePoint Services side by side: What's New & Different
  • Mini Web cast: Using SharePoint Designer for your SharePoint Sites

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Work better together.

Learn how to effectively use this new solution for better team collaboration and information sharing, with tips on creating workspaces, adding tools for file sharing, meetings, and forms, and easily integrating with other Microsoft programs.

• How can I manage my contacts?
• How do I create a workspace?
• How do I invite other computers to a workspace?
• How do I use Groove messages?
• How do I chat with others?
• How do I get started with Groove?
• How can I format text in Groove?
• How do I change my account preferences?
• How do I use my account on another computer?
• How do I create custom tools?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How can I manage my contacts?

  • Managing contacts
  • Managing your Groove contact
  • Viewing your Known Groove Contacts list
  • Starting Messenger activities with your contacts

   

• How do I create a workspace?

  • Creating a new workspace
  • Deleting a workspace
  • Duplicating a workspace
  • Viewing or changing workspace properties

   

• How do I invite other computers to a workspace?

  • Inviting other computers to a workspace
  • Managing workspaces
  • Revoking membership to a workspace

   

• How do I use Groove messages?

  • Sending a Groove message
  • Opening a Groove message
  • Reading a Groove message
  • Replying to a message
  • Forwarding a Groove message

   

• How do I chat with others?

  • Chatting in a file sharing workspace
  • Chatting in a standard workspace
  • Groove discussion tool
  • Starting Messenger activities with your contacts
  • Setting startup, messaging, and other preferences

   

• How do I get started with Groove?

  • Setting up a Groove account
  • Starting Groove
  • Logging into Groove

   

• How can I format text in Groove?

  • Using Rich text features in Groove
  • Adding and editing text in sketches
  • Text field

   

• How do I change my account preferences?

  • Managing your account
  • Changing or resetting log-in password or smart card log-in certificate
  • About log-in passwords

   

• How do I use my account on another computer?

  • Using your account on another computer
  • Managing a Groove account on multiple computers

   

• How do I create custom tools?

  • About creating custom tools
  • Saving a custom tool as a template
  • Locking the design of a custom tool
  • Disabling features in a custom tool
  • Adding "About" information to a custom tool

   

• More Resources

  • Read an overview of Groove 2007
  • Microsoft Office Groove 2007 Product Guide
  • Microsoft Office Groove 2007 Demo
  • Groove 2007 User Guide
  • Groove 2007 Glossary
  • Course 4698: Getting Started with Microsoft Office Groove 2007

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Get all your information in one place.

Leave your paper-based systems behind with hints on gathering and organizing your notes, images, and files, suggestions for using drawing tools and tables, and tips on easily locating your information and sharing your knowledge with others.

• How do I find important information later?
• How do I create and use a template?
• How do I share my notes with others?
• How do I insert or attach items into notes?
• How do I back up my notes?
• How can Outlook and OneNote work together?
• How do I organize information from my notes?
• How do I add a table to my notes?
• How do I format text in my notes?
• How do I save or print my notes?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I find important information later?

  • Search and find notes
  • Flag important notes with note tags
  • Search for tagged notes
  • Remove note tags

   

• How do I create and use a template?

  • Create a new page template
  • Customize a page template
  • Apply a template to new pages
  • Create or customize page templates
  • Create a new file from a template

   

• How do I share my notes with others?

  • Demo: Which way do you want to share a notebook?
  • Send notes in an Outlook e-mail message
  • Distribute notes to other people
  • Share notes by using a SharePoint site
  • Take notes together with other people
  • Publish notes to shared location

   

• How do I insert or attach items into notes?

  • Insert documents or files into notes
  • Attach a document or file to your notes
  • Insert a document or file to your notes as a printout
  • Insert meeting details from Outlook into notes

   

• How do I back up my notes?

  • Back up and restore your notes
  • Manually back up all notebooks
  • Restore notes from a back up file
  • Turn automatic notebook backups on or off
  • Change the default storage location for backup files

   

• How can Outlook and OneNote work together?

  • Send a document in an e-mail message
  • Create an Outlook task in OneNote
  • Create an Outlook meeting request in OneNote
  • Create an Outlook contact in OneNote
  • Create an Outlook appointment in OneNote
  • Copy information from Outlook into your notes

   

• How do I organize information from my notes?

  • Demo: Organize, search, and find information in a OneNote notebook
  • Organize your notes
  • Organize multiple page tabs, section tabs, and notebooks
  • Use tables to organize information in your notes
  • Find and organize unfiled notes

   

• How do I add a table to my notes?

  • Create a table
  • Delete a table
  • Add rows or columns to a table
  • Use tables to organize information in your notes

   

• How do I format text in my notes?

  • Take and format notes
  • Apply bold, italic, or underline formatting to text
  • Change the font, font size, or font color
  • Show the Standard and Formatting toolbars in one or two rows
  • Apply or remove text highlighting

   

• How do I save or print my notes?

  • Save a file
  • Save a file in PDF format
  • Save a file in XPS format
  • Publish as PDF or XPS
  • Preview a page before printing
  • Print a file

   

• More Resources

  • Microsoft Office OneNote 2007 product overview
  • Demo: Microsoft Office OneNote
  • Microsoft Office OneNote 2007 product guide
  • Download trial version
  • Find answers from other users in the OneNote community
  • Demo: What is OneNote
  • Course 5446: What's New in Microsoft Office OneNote 2007
  • OneNote 2007 templates
  • Office OnLine: OneNote 2007 Help and how-to

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Make the most of your time.

Manage your schedules, find and share the information you need—when you need it—and communicate more easily and safely with these tips for organizing and customizing Outlook to fit your day.

• How do I enable and use Instant Search?
• How do I set rules and alerts?
• How do I manage my junk e-mail?
• How do I format text?
• How do I attach a file to my e-mail messages?
• How do I create and add a signature to my e-mail messages?
• How do I create new folders?
• How do I add other e-mail accounts to Outlook?
• How do I create Address Book items?
• How do I create Calendaring items?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I enable and use Instant Search?

  • Lesson: Find any message, fast
  • Configure Instant Search options in Outlook 2007
  • Find a message or item by using Instant Search
  • Create a Search Folder
  • Instant Search is not finding all the items I expect

   

• How do I set 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

 

• How do I manage my junk e-mail?

  • Overview of the Junk E-mail Filter
  • Update junk e-mail filters in Outlook
  • 10 tips on how to reduce spam
  • Change the level of protection in the Junk E-mail Filter
  • Include my contacts as Safe Senders

   

• How do I format text?

  • Format e-mail messages with Quick Styles
  • Add formatting to your document by using the Mini toolbar
  • Use automatic formatting as you type
  • Change the font, font size, or font color
  • Apply bold, italic, or underline formatting to text

   

• How do I attach a file to my e-mail messages?

  • Attach a file or other item to an e-mail message
  • Insert or attach items to your e-mail message
  • Print an e-mail message and attachment
  • Remove unsafe attachments before sending a message

   

• How do I create and add a signature to my e-mail messages?

  • Demo: Create and use an e-mail signature
  • Training: Create and use your own Electronic Business Card
  • Training: Create great-looking signatures for your e-mail
  • Create a signature for outgoing messages
  • Include or change a signature in outgoing messages
  • Stop using an automatic signature

   

• How do I create new folders?

  • Create a new folder
  • Set or rename a default working folder
  • Move an item to another folder
  • Create a Search Folder

   

• How do I add other e-mail accounts to Outlook?

  • Add or remove an e-mail account
  • Add an MSN Hotmail or Windows Live Hotmail account
  • Review or change e-mail account settings
  • Choose which e-mail account to use to send a message

   

• How do I create Address Book items?

  • Create a contact
  • Add names to Contacts from an open message
  • Add or remove an address book
  • Forward a contact
  • Create a message from a contact or Electronic Business Card

   

• How do I create Calendaring items?

  • Schedule a meeting
  • Schedule an appointment
  • Change an appointment, event, or meeting
  • Make an appointment or meeting private
  • Set or remove reminders

   

• More Resources

  • Course 5447: What's New in Microsoft Office Outlook 2007
  • Microsoft Office Outlook 2007 product guide
  • Demo: Up to speed with Outlook 2007
  • Locate the Product ID for your Office Programs
  • Test drive the 2007 Microsoft Office release
  • Collection 5261: Core Training for Microsoft Office Outlook 2007
  • Keyboard shortcuts for Outlook
  • Microsoft Office 2007 Tips and Tricks Web casts
  • Mini Web cast: Top 5 New Outlook Features
  • Mini Web cast: Outlook side by side—What's New & Different
  • Mini Web cast: Sharing Outlook content with Others
  • Data Sheet: Top 10 Benefits of Microsoft Office Outlook 2007
  • Podcast: Top 10 Tips for Microsoft Office 2007 E-mail

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Make every document a professional statement.

Use these tips on applying styles to text and tables, adding illustrations, using writing tools, and even composing and publishing blogs directly from the application to help you turn a simple document into a powerful piece of communication.

• How do I format text?
• How do I change margins and indents?
• How do I add and change styles?
• How do I add an illustration?
• How do I create and format a table?
• How do I change a page background?
• How do I add page numbers?
• How do I add and edit headers and footers?
• How do I insert bullets and numbering?
• How do I proof and edit?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I format text?

  • Adding formatting to your document by using the Mini toolbar
  • Clear all text formatting
  • Make text superscript or subscript
  • Use automatic formatting as you type
  • Change the bullet or numbering formatting
  • Demo: Make documents look great in Word 2007
  • Create a large dropped initial capital letter

   

• How do I change margins and indents?

  • Indent paragraphs
  • Change or set page margins
  • Adjust spacing between a list bullet or number and the text
  • Add formatting to your document by using the Mini toolbar
  • Set tab stops
  • Select page orientation
  • My top margin is missing

   

• How do I add and change styles?

  • Change a style
  • 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
  • Choose a Quick Style set for a document

   

• How do I add an illustration?

  • 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
  • Add, change, or delete shapes
  • What uses of photos, clip art, and font images are prohibited?

   

• How do I create and format a table?

  • Insert a table by using Quick tables
  • Insert or create a table
  • Draw a table
  • Format a table
  • Move or copy a table
  • Add a cell, row, or column to a table
  • Demo: Work with tables in a document, presentation, or message

   

• How do I change a page background?

  • Brand a document with a watermark or background
  • Decorate documents with pictures or borders
  • Copy and paste multiple items by using Office Clipboard
  • Show or hide drawing gridlines

   

• How do I add page numbers?

  • Insert page numbers
  • Remove page numbers
  • Remove the page number from the first page
  • Restart footnote or endnote numbering from 1

   

• How do I add and edit headers and footers?

  • Insert or delete a footnote or an endnote
  • Convert footnotes to endnotes and vice versa
  • Insert headers or footers
  • My header or footer is missing

   

• How do I insert bullets and numbering?

  • Add bullets to a shape in a SmartArt graphic
  • Add picture bullets or symbols to a list
  • Training: Bullets, numbers, and lists
  • Turn on or off automatic bullets or numbering
  • Create a bulleted or numbered list
  • Change the bullet or number formatting

   

• How do I proof and edit?

  • Turn on or off change tracking
  • Track changes while you edit
  • Merge comments and changes from several documents into one document
  • Review tracked changes and comments
  • Test your document’s readability

   

• More Resources

  • Word Add-in
  • Training: Up to speed with Word 2007
  • Course 5449: What's New in Microsoft Office Word 2007
  • Interactive: Word 2003 to Word 2007 command reference guide
  • Microsoft Office Word 2007 product guide
  • Quiz: Word 2007 basics
  • Web casts: Tips and Tricks for Office 2007
  • Locate the Product ID for your Office Programs
  • Test drive the 2007 Microsoft Office release
  • Collection 5258: Core Training for Microsoft Office Word 2007
  • Word 2003 to Word 2007 interactive command reference guide
  • Microsoft Office 2007 Tips and Tricks Web casts
  • Mini Web cast: Top 5 New Word Features
  • Mini Web cast: Word side by side—What's New & Different
  • Mini Web cast: Large Documents Support in Word
  • Top 10 Benefits of Microsoft Office Word 2007

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Bring your information to life.

Track, report, and share your information more effectively with formatting hints for making your reports and forms stronger, tips on using prebuilt database solutions, and suggestions for managing and auditing sensitive information.

• When and how do I use data collection?
• How do I create a database?
• How do I sort or filter records?
• How do I create a report?
• How do I format my report?
• How do I work with SharePoint sites?
• How do I link to data from other sources?
• How do I import and export data?
• What is a macro and how do I use it?
• How do I create an expression?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• When and how do I use data collection?

  • Collect data by using e-mail messages
  • Data collection e-mail options
  • Manage data collection replies
  • Resend data collection message
  • My data collection replies are not getting automatically processed

   

• How do I create a database?

  • Database design basics
  • Create a table
  • Add a field to a table
  • Add, set, or change a primary key
  • Guide to table relationships

   

• How do I sort or filter records?

  • Filter: Limit the number of items in a view
  • Sort records in a case sensitive view
  • Sort records in a custom order
  • Sort records based on partial values in a field
  • Sort records on numeric values stored in a text field
  • Sort records on text, numeric, or date values

   

• How do I create a report?

  • Create a simple report
  • Create and use subreports
  • Add a field to a form or report
  • Modify, edit, or change a report

   

• How do I format my report?

  • Modify, edit, or change a report
  • Insert a logo into a report
  • Insert a title into a report
  • Insert page numbers into form or report
  • Insert the date or time into a form or report

   

• How do I work with SharePoint sites?

  • Introduction to integrating data between Access and SharePoint site
  • Import from or link to a SharePoint list
  • Export a table or query to a SharePoint site
  • Publish a database to a SharePoint site

   

• How do I link to data from other sources?

  • Learn how to import or link data
  • Introduction to integrating data between Access and SharePoint
  • Import or link to data in another Access database
  • Import or link to data in Excel workbook
  • Import or link to SQL Server data
  • Import or link to data in a text file

   

• How do I import and export data?

  • Schedule an import or export operation
  • Save the details of an import or export operation as a specification
  • Run a saved import or export operation
  • Manage data tasks

   

• What is a macro and how do I use it?

  • What is a macro and why you should care
  • Get to know Macros: A Guide
  • Macros demystified: What are they and why to use them
  • Create a macro
  • Macro basics in Access 2007

   

• How do I create an expression?

  • Create an expression
  • Examples of expressions
  • Guide to expression syntax
  • Create conditional (Boolean) expressions

   

• More Resources

  • Training: Up to speed with Access 2007
  • Free Access 2007 Trial
  • Demo: Up to speed with Access 2007
  • What's new in Microsoft Office Access 2007
  • Guide to the Access 2007 user interface
  • Getting Started with Access 2007
  • Microsoft Office Access 2007 Product Guide
  • Microsoft Office Access 2007 top 10 benefits
  • Microsoft Office Access 2007 demo
  • Microsoft Office Access 2007 product overview

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Extend the reach of your information.

Find tips on generating powerful, easy-to-use forms, using design and development tools to streamline complex processes, and many more features that help you collect, manage, and distribute your data with ease.

• How do I create a form?
• How can I preview or test my form template?
• How do I use InfoPath controls?
• How do I merge forms?
• How do I submit data?
• How do I work with user roles?
• How do I program my form template?
• How do I format my form template?
• How do I publish a form template?
• How do I set up security on my form template?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I create a form?

  • Introduction to form templates and forms
  • Convert a Word document into an InfoPath form template
  • Introduction to laying out a form template
  • Design a form template for offline use

   

• How can I preview or test my form template?

  • Introduction to testing form templates
  • Preview a form template
  • Check your form template for problems
  • Introduction to the Design Checker task pane
  • Web browser compatibility in InfoPath Forms Services

   

• How do I use InfoPath controls?

  • Introduction to controls
  • Make a control required
  • Change the binding of a control
  • Change one type of control to another type of control
  • Set a control as read-only

   

• How do I merge forms?

  • Design a form for merging
  • Enable or disable form merging
  • Merge actions for fields and groups

   

• How do I submit data?

  • Introduction to submitting form data
  • Submit form data in an e-mail message
  • Submit form data to a Microsoft Access database
  • Submit form from a Microsoft SQL Server database
  • Submit form data to several locations

   

• How do I work with user roles?

  • Introduction to customizing form templates by using programming code
  • Introduction to InfoPath programming environments
  • Set the scripting language for a form template
  • Change the programming language of a form template
  • Customize a form template by using a script

   

• How do I program my form template?

  • Introduction to customizing form templates by using programming code
  • Introduction to InfoPath programming environments
  • Set the scripting language for a form template
  • Change the programming language of a form template
  • Customize a form template by using a script

   

• How do I format my form template?

  • Change the font, font size, or font color
  • Format a date, time, or number
  • Change the line spacing of a paragraph
  • Apply bold, italic, or underline formatting to text
  • Align or center text

   

• How do I publish a form template?

  • Introduction to publishing a form template
  • Publish a form template to a list of e-mail message recipients
  • Publish a form template to a server running InfoPath Forms Services
  • Publish an updated version of a form template
  • Modify a published form template

   

• How do I set up security on my form template?

  • Set the required security level for a form template
  • Security levels of InfoPath forms
  • Add, remove, or view a trusted publisher
  • View my security settings in the Trust Center

   

• More Resources

  • Introduction to Microsoft Office InfoPath 2007
  • What's new in Microsoft Office InfoPath 2007
  • Microsoft Office InfoPath 2007 Demo
  • Ask the InfoPath Community
  • Microsoft Office InfoPath 2007 Product Guide
  • InfoPath 2007 Glossary
  • Office Online: InfoPath 2007 Help and How-to
  • Course 5445: What's New in Microsoft Office InfoPath 2007

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use

Take control of your own publishing.

Use these tips on creating personalized identities, combining and editing mailing lists, using templates, and more to help you generate and distribute your own high-quality publications and marketing materials in print, Web, and e-mail.

• How do I save my publication in other file formats?
• How do I create a Publisher Web site?
• How can I format pages on my Publisher Web site?
• How do I print my publication?
• How do I create a master page?
• How do I create and use a mail merge?
• How do I create and format borders?
• How do I add images to my publication?
• How do I create or modify a text box?
• How do I format graphics or objects?
• More Resources

Running the 2007 Microsoft Office system? Just push the F1 key on your keyboard to go directly to Office Online Help.

• How do I save my publication in other file formats?

  • Save a publication as a PDF file or an XPS file
  • Demo: Distribute publications the best way for you
  • Enable support for other file formats, such as PDF and XPS
  • View or change the properties for an Office document
  • Save a publication as a Word document

   

• How do I create a Publisher Web site?

  • Plan your Web site
  • Add a page to your Web site
  • Prepare, publish, and maintain your Publisher website

   

• How can I format pages on my Publisher Web site?

  • Add or remove a background on a Web page or site
  • Add a color or pattern behind a group of objects, entire page, or all pages
  • Add a background sound to a Web page
  • Add an animated picture to a Web page
  • Add alternative text to a Web page graphic

   

• How do I print my publication?

  • Tips for printing your publication
  • Find the right printing professionals for your budget
  • Tips for preparing your publication for commercial printing
  • Preview a page before printing
  • Print a file

   

• How do I create a master page?

  • Create, edit, or delete a master page
  • Duplication of a master page
  • Apply master pages to publication pages
  • Hide master page objects
  • Move between master pages and publication pages

   

• How do I create and use a mail merge?

  • Create a mail merge
  • Create an address list for a mail merge
  • Create a data source for a mail merge
  • Demo: Personalize newsletters with E-mail Merge in Publisher 2007
  • Tips for preparing your e-mail mailing list

   

• How do I create and format borders?

  • Add or remove a border in Publisher
  • Add borders, fills, and effects to a table
  • Change the color of fills, lines, and borders

   

• How do I add images to my publication?

  • Tips for working with images
  • Add pictures and other graphics
  • Manage pictures with the Graphics Manager task pane
  • Insert a picture into an AutoShape
  • Add a shape

   

• How do I create or modify a text box?

  • Create a text box
  • Change the margins around the text in text box or shape
  • Align text within a text box
  • Create columns within a text box
  • Add a line between text columns

   

• How do I format graphics or objects?

  • Change the color, style, or weight of a line
  • Change the way pictures, WordArt, and OLE objects are displayed
  • Add or delete a shape fill or shape effect
  • Add or delete Adjust handles so you can change the shape of a picture's outline

   

• More Resources

  • Get Publisher Product Support
  • Join Publisher discussion groups
  • What's new in Microsoft Office Publisher 2007
  • Getting started with Microsoft Office Publisher 2007
  • Download a free trial of Microsoft Office Publisher 2007
  • Microsoft Office Publisher 2007 Product Guide
  • Microsoft Office Publisher 2007 version comparison
  • Microsoft Office Publisher 2007: Online Demo

   

 

 

© 2007 Microsoft Corporation. All rights reserverd. Terms of Use