Office 2007: Getting Up to Speed

Office 2007: Getting Up to Speed


Total Run Time: 6 hrs

Learn how to use Microsoft Office 2007 efficiently and effectively with minimal effort now! You'll learn tips for using each product as well as how to create an integrative workflow amongst all the applications.


Microsoft Word

  1. Get to know Word's new Ribbon-based interface and streamline common edits by learning shortcuts for selecting, moving, copying, and replacing text
  2. Learn how easy it is to standardize page layouts with indents, spacing, and tabs.
  3. Harness the power of Word's styles to quickly format and control the look of your overall document; then use 2007's latest Style features to go even further.

Microsoft Excel

  1. Find out how to use Excel to create a new spreadsheet and add a new worksheet within the same file.
  2. Get up to speed on how to work with and format cell contents and worksheets for easy reading.
  3. Learn how to build lists, sort, and filter for quick access to important data; e.g., sales leads.

Microsoft PowerPoint

  1. Manage Layouts, Themes, and Colors to save time with each new project.
  2. See how to insert Smart Art objects, graphs, and organizational charts, plus add animation effects to make your presentations come to life.
  3. Sit back and watch as your presentation runs itself with the numerous options and timing settings. You can even convert your presentation to a website or a PDF.


  1. Get better at using charts and similar content taken from an Excel spreadsheet.
  2. Find out tricks for sharing content between Word, Excel, and PowerPoint.
  3. Share your work via Outlook with your newly created address book of contacts; then setup meetings and appointments in multiple calendars.


This title is available in the
Total Training All-Access library.

Subscribe Now

SKU: tt_TOFWF07 Categories: , , ,


These tutorials make all programs in Microsoft Office 2007 a breeze to use. You are introduced to the new interfaces and taught how to use each application’s key features. This includes how to save time creating shortcuts for formatting Word documents, spreadsheets, and presentations. Plus, see how to manage your email, calendar, and list of contacts.

Sample clip

Course outline


  1. Touring the New Office 2007 Interface
  2. Formatting Basic Text
  3. Applying Formatting to a Paragraph
  4. Creating Bulleted & Numbered Lists
  5. Working with Styles
  6. Making Changes to the Styles
  7. Saving & Removing Formatting
  8. Changing Style Sets
  9. Proofing Your Work
Chapter 2: REFINING WORD® DOCUMENTS (45 min)

  1. Adding Headers & Footers
  2. Inserting Watermarks
  3. Formatting the Overall Document
  4. Inserting Graphical Elements
  5. Inserting Clip Art
  6. Using SmartArt
  7. Inserting Tables
  8. Formatting Tables
  9. Creating a Cover Page with Themes
  10. Saving a Document
  11. Outputting to PDF
Chapter 3: EXPLORING EXCEL® (77 min)

  1. Touring the Excel Interface
  2. Inserting, Moving & Selecting Content
  3. Format Numerical Data & Reference Cells
  4. Building a Table & Using AutoFill
  5. Inserting & Deleting Rows & Columns
  6. Introducing Formulas
  7. Introducing Functions
  8. Using the Insert Function Dialog Box
  9. Using Statistical Functions & the Status Bar
  10. Using Auditing Commands
  11. Exploring Absolute Cell Referencing
  12. Naming Cell Ranges & Using Name Manager
  13. Pasting Data & Using the Clipboard

  1. Formatting Cells
  2. Using Format Painter
  3. Number Formatting
  4. Using Cell Styles
  5. Creating Cell Styles
  6. Changing Styles
  7. Using & Creating Table Styles
  8. Filtering a Table Layout
  9. Using Conditional Formatting
  10. Formatting Worksheets with Themes
  11. Inserting Graphical Elements
  12. Managing Multiple Worksheets
  13. Outputting a Document
  14. Saving a Document

  1. Touring the PowerPoint Interface
  2. Formatting Text
  3. Changing the Slide Layout
  4. Adding Additional Slides
  5. Creating a Slide Design
  6. Customizing Slides
  7. Inserting Objects
  8. Using SmartArt
  9. Creating & Formatting Charts
  10. Using WordArt Styles
  11. Changing Chart Types
  12. Applying Themes
  13. Setting Animation Effects
  14. Working with Different Views
  15. Setting Up a Slide Show
  16. Running a Slide Show
  17. Outputting a Presentation

  1. Touring the Outlook Interface
  2. Using E-mail
  3. Creating Signatures & New Folders
  4. Using a Calendar & Adding Events
  5. Working with Multiple Calendars
  6. Sharing Calendars
  7. Adding & Viewing Contacts
  8. Creating, Viewing & Flagging Tasks
Chapter 7: MANAGING DATA WITH ACCESS™ (21 min)

  1. Introducing Access & Touring the Interface
  2. Adding & Deleting Contacts
  3. Filtering Data
  4. Creating & Exporting Forms
  5. Creating Reports
  6. Exporting Data
Chapter 8: A SEAMLESS OFFICE 2007 WORKFLOW (50 min)

  1. Formatting & Sorting Data
  2. Using Freeze Panes
  3. Grouping Data into Outlines
  4. Creating Charts in Excel
  5. Sharing Workbooks
  6. Using Excel with Word
  7. Protecting a Document
  8. Using Cross-References
  9. Inserting Objects
  10. Using Excel with PowerPoint
  11. Publishing Handouts to Word
  12. Going from Word to Outlook
  13. Sending Invites with Outlook
  14. Sending Meeting Requests
  15. Final Comments & Credits

Presenter Info

Geoff BlakeGeoff Blake is a Toronto-based author, trainer, designer, and artist. For the past ten years, he’s provided a wide range of graphic design, artwork, consulting, in-class training, and web design services.

A professional public speaker since 1997, Geoff has taught desktop publishing, web design ,and graphics courses in both the corporate and post-secondary environments, working closely with some of the largest training providers and colleges in the Toronto area. His appearances, in-class training, and consulting have taken him throughout North America, where he’s built a solid reputation for delivering otherwise jargony material in a fun, enjoyable, and entertaining way. With his diverse print and web experience, he regularly contributes to magazines and web sites, and is currently working on a series of print, web, and design books—penning Ten Ton Dreamweaver in 2006 with Peachpit Press, and following up with Ten Ton Flash, which is in current production.

Geoff is very comfortable with modern digital and pre-press print preparation, cutting edge web design techniques, and software/hardware troubleshooting. Throughout his career, he’s provided expert training and support for a variety of applications, including Microsoft Office, Dreamweaver, Flash, Photoshop, Acrobat, InDesign, Illustrator.

You can visit Geoff online at, where he posts his latest tricks, techniques, reviews, and other discoveries in the ever-expanding world of technology.