OFFICE. |
|
|
Chapter 1: Office Basics. |
|
|
|
Start and Exit Office Applications. |
|
|
|
Navigate the Program Windows. |
|
|
|
|
|
Work with Menus and Toolbars. |
|
|
|
Display and Hide Toolbars. |
|
|
|
|
|
|
|
Add and Remove Office Components. |
|
|
|
Chapter 2: Working with Files. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cut, Copy, and Paste Data. |
|
|
|
|
|
Assign a Password to a File. |
|
|
WORD. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chapter 4: Formatting Text. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Create Bulleted or Numbered Lists. |
|
|
|
|
|
|
|
|
|
Chapter 5: Working with Tables. |
|
|
|
|
|
|
|
|
|
Adjust the Column Width or Row Height. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chapter 6: Adding Extra Touches. |
|
|
|
Add Borders and Shading to Text. |
|
|
|
|
|
|
|
|
|
Insert Footnotes and Endnotes. |
|
|
|
Insert Page Numbers and Page Breaks. |
|
|
|
|
|
|
|
Chapter 7: Previewing and Printing Documents. |
|
|
|
|
|
Check Spelling and Grammar. |
|
|
|
|
|
|
|
|
|
Track and Review Document Changes. |
|
|
|
|
|
|
|
|
EXCEL. |
|
|
Chapter 8: Building Spreadsheets. |
|
|
|
|
|
|
|
Faster Data Entry with AutoFill. |
|
|
|
|
|
|
|
|
|
|
|
Center Data Across Columns. |
|
|
|
|
|
|
|
Chapter 9: Worksheet Basics. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Format the Worksheet Tab Color. |
|
|
|
|
|
|
|
Filter Data with AutoFilter. |
|
|
|
|
|
Track and Review Workbook Changes. |
|
|
|
Chapter 10: Working with Formulas and Functions. |
|
|
|
|
|
|
|
|
|
Reference Ranges in Formulas. |
|
|
|
Reference Cells from Other Worksheets. |
|
|
|
Apply Absolute and Relative Cell References. |
|
|
|
|
|
|
|
Total Cells with AutoSum. |
|
|
|
Audit a Worksheet for Errors. |
|
|
|
Chapter 11: Formatting Worksheets. |
|
|
|
|
|
Change the Font and Size. |
|
|
|
Increase or Decrease Decimals. |
|
|
|
|
|
Adjust the Cell Alignment. |
|
|
|
|
|
|
|
|
|
Format Data with AutoFormat. |
|
|
|
Assign Conditional Formatting. |
|
|
|
Chapter 12: Working with Charts. |
|
|
|
Create a Chart with Chart Wizard. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
POWERPOINT. |
|
|
Chapter 13: Presentation Basics. |
|
|
|
Create a Presentation with the AutoContent Wizard. |
|
|
|
Start a Presentation with a Design Template. |
|
|
|
Build a Blank Presentation. |
|
|
|
|
|
Chapter 14: Creating Slides. |
|
|
|
Understanding Slide Elements. |
|
|
|
|
|
Change the Font and Size. |
|
|
|
|
|
|
|
Change the Text Alignment. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change the Slide Background Color. |
|
|
|
|
|
|
|
Chapter 15: Assembling a Slide Show. |
|
|
|
Insert and Delete Slides. |
|
|
|
|
|
|
|
Define Slide Transitions. |
|
|
|
|
|
Animate Individual Slide Elements. |
|
|
|
|
|
Chapter 16: Presenting a Slide Show. |
|
|
|
|
|
|
|
|
|
Package Your Presentation on a CD. |
|
|
ACCESS. |
|
|
Chapter 17: Database Basics. |
|
|
|
Understanding Database Basics. |
|
|
|
|
|
Create a Database Based on a Template. |
|
|
|
Chapter 18: Adding Data Using Tables. |
|
|
|
|
|
Create a Table with a Wizard. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chapter 19: Adding Data Using Forms. |
|
|
|
Create a Form Using a Wizard. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Change the Field Formatting. |
|
|
|
Change the Form Background. |
|
|
|
Chapter 20: Finding and Querying Data. |
|
|
|
|
|
|
|
|
|
|
OUTLOOK. |
|
|
Chapter 21: Organizing with Outlook. |
|
|
|
|
|
|
|
Schedule a Recurring Appointment. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Chapter 22: E-Mailing with Outlook. |
|
|
|
Compose and Send a Message. |
|
|
|
Read an Incoming Message. |
|
|
|
Turn Off the Reading Pane. |
|
|
|
Reply to or Forward a Message. |
|
|
|
Add a Sender to Your Address Book. |
|
|
|
|
|
Attach a File to a Message. |
|
|
|
|
|
|
|
|
PUBLISHER. |
|
|
Chapter 23: Publisher Basics. |
|
|
|
|
|
Create a Blank Publication. |
|
|
|
|
|
|
|
|
|
Add a Picture to a Publication. |
|
|
|
Add Clip Art to a Publication. |
|
|
|
Chapter 24: Fine-Tuning a Publication. |
|
|
|
Change the Text Font and Size. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Move a Publication Object. |
|
|
|
Resize a Publication Object. |
|
|
|
|
|
Edit the Background Page. |
|
|
|
Add a Design Gallery Object. |
|
|
OFFICE INTERNET AND GRAPHIC TOOLS. |
|
|
Chapter 25: Using the Office Internet Tools. |
|
|
|
|
|
Preview a File as a Web Page. |
|
|
|
|
|
|
|
|
|
Chapter 26: Using the Office Graphics Tools. |
|
|
|
|
|
|
|
|
|
View Clip Art with the Clip Organizer. |
|
|
|
Download Clip Art from the Web. |
|
|
|
|
|
|
|
Move and Resize an Object. |
|
|
|
|
|
|
|
Add Shadow and 3-D Effects. |
|
|
|
|
|
Group and Ungroup Objects. |
|
|
|
|