Presenter: Geoff Blake (For the past ten years, Geoff Blake has provided a wide range of graphic design, artwork, consulting, training, and web design services to numerous industry-leading clients. He works closely with some of the largest training providers and colleges in the Toronto area, providing expert training and support for many programs. He also writes articles, and books, including his latest book, Ten Ton Dreamweaver.)
Platform: Windows
Format: DVD-ROM
Running Time: 6 Hrs, 1 DVD
Level: Beginner to Intermediate
Project Files: Included
***************
Description:
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. Learn how to use Office 2007 efficiently and effectively with minimal effort now!
Highlights
Microsoft Word
Get to know Word's new Ribbon-based interface and streamline common edits by learning shortcuts for selecting, moving, copying, and replacing text
Learn how easy it is to standardize page layouts with indents, spacing, and tabs.
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
Find out how to use Excel to create a new spreadsheet and add a new worksheet within the same file.
Get up to speed on how to work with and format cell contents and worksheets for easy reading.
Learn how to build lists, sort, and filter for quick access to important data; e.g., sales leads.
Microsoft PowerPoint
Manage Layouts, Themes, and Colors to save time with each new project.
See how to insert Smart Art objects, graphs, and organizational charts, plus add animation effects to make your presentations come to life.
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.
Workflow
Get better at using charts and similar content taken from an Excel spreadsheet.
Find out tricks for sharing content between Word, Excel, and PowerPoint.
Share your work via Outlook with your newly created address book of contacts; then setup meetings and appointments in multiple calendars.
**************
Course Outline
Chapter 1: GETTING STARTED WITH WORD (33 min)
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
Chapter 4: FORMATTING & STYLIZING IN EXCEL® (68 min)
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
Chapter 5: POWERING UP WITH POWERPOINT® (60 min)
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
Chapter 6: STAYING CONNECTED IN OUTLOOK® (25 min)
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
|
