Table of Contents

Microsoft Office 2010 LiveLessons:
Word:
How to perform a mail merge.
How to convert a document to PDF or XPS
How to inspect a document and remove personal metadata.
How to encrypt a document
How to add a digital signature to a document.
How to work with Themes between Office applications.
How to include SmartArt.
Changing Word Options
Using the Track Changes features in Word 2007.
Adding Comments into a document.
Navigating through a Word document (with the keyboard or mouse)
Understanding Formatting (character and paragraph formatting)
Paragraph Formatting (alignment, spacing, page breaks, tabs)
Bullets, Numbering and Multilevel Lists
Spelling, Contextual Spelling and Grammar check.
Printing Documents
Working with Themes, Styles and Templates
Working with Tables
Inserting Graphics (clipart, shapes, SmartArt, WordArt)
Headers and Footers
Using Academic Tools (footnotes, endnotes, citations, bibliographies)
Sharing Documents (tracking revisions, using comments)

Excel:
Working with Workbooks
Working with Worksheets
Enter Data into your Worksheets
Formatting Cells
Excel Styles and Themes
Conditional Formatting
Basic Excel Formulas and Functions
Troubleshoot Function Errors
Sorting Data and Filtering Data with Tables
Creating Pivot Tables
Protecting Your Workbook and Worksheets
Working With Excel Views
Illustrations and SmartArt
Basic Charting (How to create a simple bar or pie chart)
Advanced Chart Formatting
Printing Worksheets
Sharing Your Documents (although some of this material would duplicate Word information

PowerPoint:
Animating Text and Shapes in PowerPoint
Using Quick Layouts and Styles to Make Your Presentation Shine
Getting Familiar with the Presenter View
Managing Slide Shows
Creating a Presentation
Altering the Slide Master
Slide Transitions
Animations of Text and Objects on a Slie
Adding Music, Sounds and Video

Outlook 2007
Navigating Outlook 2007
Email
Contacts
Calendar
Tasks and To Do
Notes
Journal
Really Simple Syndication (RSS)

Microsoft Office 2010 In Depth
Part I Office 2010 Interface and Common Features
1. Getting Oriented to the Office 2010 Applications
2. Navigating and Customizing the Office Interface and Tools
3. Managing and Sharing Office Files
4. Using and Creating Graphics
5. Working with the Microsoft Office Web Apps
Part II Word
6. Requisite Word: Essential Features
7. Advanced Formatting Options
8. Using Tables and Columns
9. Creating and Applying Styles
10. Understanding Document Sections
11. Working with Mail Merges and Forms
12. Managing Larger Documents and Special Document Features
Part III Excel
13.  Requisite Excel: Essential Features
14.  Advanced Worksheet Formatting
15.  Using Formulas and Functions
16.  Working with Date and Time Functions
17.  Creating Charts
18. Advanced Excel Tools and Features
19.  Using Excel Tables and PivotTables
Part IV PowerPoint
20. Requisite PowerPoint: Essential Features
21. Advanced Formatting, Themes and Masters
22. Using Tables and Charts
23. Working with Diagrams, Clipart and Pictures
24. Enhancing Slides with Animation, Transitions and Objects
25. Delivering a Presentation and Support Materials
Part V Outlook
26. Outlook Configuration and Email Essentials
27. Advanced Email Features
28. Using the Calendar for Appointments and Tasks
29. Working with Contacts and Planning Meetings
30. Using the Journal and Notes
31. Securing Outlook
Part VI Publisher
32. Requisite Publisher: Essential Features
33. Advanced Publication Features
34. Creating Online Publications
Part VII OneNote
35. OneNote Essentials
36. Working with To Do Lists and Tasks
37. Customizing, Organizing and Sharing Notes
38. OneNote Audio and Video Features
39. Using OneNote with the Office Suite Applications
Appendix I
Office Application Integration
Office Macros

About the Author

J. Peter Bruzzese, an independent consultant, trainer, and author, has worked with clients ranging from Goldman Sachs to Microsoft, and instructed for leading trainers such as CBT Nuggets, New Horizons, and ONLC.com. Bruzzese contributes to Redmond and WindowsITPro Magazines, and speaks regularly at MCP's TechMentor Conferences. Joe Habraken is a computer technology professional and best-selling author with more than 15 years of experience in the information technology field. His recent publications include Microsoft Office 2003 8-in-1, 0789729369, and The Absolute Beginner's Guide to Networking, 4/e, 0789729113.