Microsoft Office

Create Databases and Simple Tables

• Jul 15, 2010
• In this chapter from Microsoft Access 2010 Step by Step, you’ll create a database from a template and create a table manually. Then you’ll adjust the display of a data table to fit your needs.

Create Simple Reports in Microsoft Access 2010

• Jul 15, 2010
• In this chapter from Microsoft Access 2010 Step by Step, you’ll create a report in Access 2010 by using a wizard. After modifying the layout and content of the report, you’ll see how it will look when printed.

Enhance Message Content in Microsoft Outlook 2010

• Jun 29, 2010
• This chapter from Microsoft Outlook 2010 Step by Step reviews formatting techniques and shows how to set default fonts for new messages and message responses, and create an e-mail signature that’s automatically included in all new messages. It then describes how to insert and modify pictures, Clip Art, and shapes, and use the new Screenshot and Screen Clipping tools to capture images of content displayed on your screen.

How to Add Sound and Movies to Microsoft PowerPoint 2010

• Jun 29, 2010
• In this chapter from Microsoft PowerPoint 2010 Step by Step, you’ll insert a sound clip and a sound file and make various adjustments to their settings. You’ll also insert two video files, edit one of them, and format them both.

Working with Special Content in Word

• Jun 24, 2010
• This chapter from Microsoft Office 2010 Plain & Simple talks about cover letter templates, inserting equations, using text boxes to create sidebars and pull quotes, creating watermarks, and working with other special characters and content.

Creating Queries in Access 2010

• Jun 15, 2010
• This chapter from Microsoft Access 2010 Plain & Simple explains the concept and function of queries and shows how to create them using the Query Wizard or on your own. It also introduces more advanced concepts such as using queries to calculate values or find duplicate records.

Managing a Calendar in Microsoft Outlook 2010

• Jun 15, 2010
• This chapter from Microsoft Outlook 2010 Plain & Simple shows how to work with calendars in Outlook including creating appointments, events and meetings as well as working with objects and attachments, making changes, and sharing calendar information.

Using Formulas and Functions

• Jun 15, 2010
• This chapter from Microsoft Excel 2010 Plain & Simple explains the use of formulas and functions in Excel, including creating, editing, and debugging.

Creating Dynamic Worksheets by Using PivotTables in Microsoft Excel 2010

• Jun 2, 2010
• In this chapter from Microsoft Excel 2010 Step by Step, you’ll learn how to create and edit PivotTables from an existing worksheet, focus your PivotTable data using filters and Slicers, format PivotTables, and create a PivotTable with data imported from a text file.

Fine-Tuning Task Details in Microsoft Project 2010

• Jun 2, 2010
• In this chapter from Microsoft Project 2010 Step by Step, you examine and use a variety of advanced features in Microsoft Project 2010. These features focus on fine-tuning task details prior to saving a baseline, as well as commencing work on the project with the goal of developing the most accurate schedule representation of the tasks you anticipate for the plan.

How to Insert and Modify Diagrams in Microsoft Word 2010

• Jun 2, 2010
• In this chapter from Microsoft Word 2010 Step by Step, you’ll insert a diagram into a document and specify its size and position. Then you’ll change the diagram’s layout, visual style, and color theme. Finally, you’ll see how to use a diagram to arrange pictures in a document.

Organize Information in Columns and Tables in Microsoft Word 2010

• Jun 2, 2010
• In this chapter from Microsoft Word 2010 Step by Step, you’ll first create and modify columns of text. Then you’ll create a simple tabbed list. Finally, you’ll create tables from scratch and from existing text, and format a table in various ways.

Setting Up Resources in Microsoft Project 2010

• Jun 2, 2010
• Microsoft Project 2010 supports three types of resources. These are work resources, as well as two special-purpose resources: cost and material. In this chapter from Microsoft Project 2010 Step by Step, you will set up work and cost resources.

Building a Presentation Outline in PowerPoint 2010

• May 15, 2010
• This chapter from Microsoft PowerPoint 2010 Plain & Simple shows how to use PowerPoint's outline for organizing your thoughts and information to include in your presentations.

Dynamic Chart Presentation Solutions That Pack a Punch in Microsoft Office Excel 2007

• Dec 10, 2008
• This chapter from Create Dynamic Charts in Microsoft Office Excel 2007 and Beyond shows you how to create solutions in Microsoft Excel 2007 that have a powerful effect.

Control Visual Basic in Microsoft Office Excel 2007 Visual Basic for Applications

• May 16, 2007
• In this chapter from Microsoft Office Excel 2007 Visual Basic for Applications Step by Step, you’ll learn how to add loops to your macros. And to make those loops more effective, you’ll learn how to create conditional expressions that let the macro make decisions.

Adding Animation, Sound, and Movies to Microsoft® Office PowerPoint® 2007

• Jan 3, 2007
• The difference between an adequate presentation and a great presentation often lies in the judicious use of multimedia. In this chapter from Microsoft® Office PowerPoint® 2007 Step by Step, learn to apply predefined animations, change some of the animation settings, change the way slides move on and off the screen during a slide show, insert a sound clip and a sound file and make various adjustments to their settings, and insert a movie file, preview the movie, and modify its behavior.

Exploring Microsoft® Office PowerPoint® 2007

• Jan 3, 2007
• In this chapter from Microsoft® Office PowerPoint® 2007 Step by Step, learn the new features of the PowerPoint working environment, get familiar with how to open and move around in an existing PowerPoint presentation, explore various ways of viewing slides, and learn to save a new blank presentation and then save an existing presentation with a new name.

Handling E-Mail Messages in Microsoft® Office Outlook® 2007

• Jan 3, 2007
• In this chapter from Microsoft® Office Outlook® 2007 Step by Step, learn how to manage your e-mail messages, including viewing messages and attachments, replying to and forwarding messages, working with new mail notifications, creating a task or an appointment from a message, and printing messages.

Managing Appointments, Events, and Meetings in Microsoft® Office Outlook® 2007

• Jan 3, 2007
• In this chapter from Microsoft® Office Outlook® 2007 Step by Step, you will record different types of information in your Outlook calendar, scheduling an appointment and an event on your own calendar and then scheduling a meeting with another person. You will learn methods of determining meeting times during which other people are available. Then you will learn about responding to, updating, and canceling meeting requests.