Office 2007 Essentials Training Bundle

INCLUDED IN THE BUNDLE

Microsoft Office 2007: Getting up to Speed
Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 7: MANAGING DATA WITH ACCESST (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

Lesson 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
 

Excel 2007: Essentials

Lesson 1: WORKING WITH THE USER INTERFACE (25 min)
1. Introducing the Ribbon User Interface
2. Introducing Workbooks & Worksheets
3. Introducing the Formula Bar
4. Saving with Different File Extensions
5. Customizing the User Interface

Lesson 2: ENTERING & MANAGING DATA (47 min)
1. Getting Data into Excel
2. Importing Text Files
3. Using the Freeze Panes Functionality
4. Using the Zoom Functionality
5. Using Hot Keys
6. Managing Rows & Columns
7. Finding Data
8. Matching Case & Entire Cell Contents
9. Replacing Data
10. Finding & Replacing Empty Values
11. Sorting Data
12. Sorting Multiple Columns
13. Filtering Data

Lesson 3: USING FORMATTING TECHNIQUES (23 min)
1. Formatting Numbers & Dates
2. Formatting Cells
3. Setting the Font Type, Color & Size
4. Using Borders & Cell Styles
5. Adding Shapes & Pictures
6. Creating WordArt

Lesson 4: Formula Basics (34 min)
1. Constants, Formulas & Cell References
2. Understanding the Order of Operations
3. Using Formulas with Dates & Text
4. Linking Cells & Using Comparison Operators
5. Creating an Absolute Reference
6. Defining Named Ranges
7. Exploring the Function Library
8. Using the AutoSum Function

Lesson 5: USEFUL FUNCTIONS (40 min)
1. Using the INT Function
2. Using the Rounding Function
3. Using the ABS Function
4. Using the SUBTotal Function
5. Using Logical Functions
6. Using the AND & the OR Function
7. Using LEFT, RIGHT & MID Functions
8. Using the UPPER, LOWER, PROPER & TRIM Functions
9. Using COUNT Functions
10. Using the VLOOKUP Function

Lesson 6: CREATING REPORTS (33 min)
1. Creating a Subtotal Report
2. Using Conditional Formatting
3. Creating & Managing Conditions
4. Creating a Chart
5. Refining Charts
6. Using Basic Chart Types

Lesson 7: SHARING & DISTRIBUTING YOUR WORK (25 min)
1. Inserting Headers & Footers
2. Adding Comments
3. Adjusting Page Layout
4. Distributing Your Worksheets
5. Protecting Your Worksheets
6. Understanding Compatibility

Lesson 8: TIPS & TRICKS (53 min)
1. Using the Fill Handle
2. Filling in a Series of Numbers
3. Typing in Multiple Cells at Once
4. Leveraging a Custom List & Transposing a Range
5. Deleting & Inserting Blank Cells
6. Filling Holes in Your Data
7. Getting a List of Unique Records & Parsing Text
8. Rearranging Columns & Linking to Multiple Cells
9. Using Right Mouse Button Drag Options
10. Make Format Painter Persist & Paste Special Formats
11. Formatting Portions of Text & Multiple Sheets
12. Creating Cell Border Effects & Sorting on Color
13. Turning Formulas into Hard Data
14. Copy Formula References & Highlight Formulas
15. Creating Dynamic Charts & Combination Charts
16. Add a Secondary Axis, Average Line & Smooth Line
17. Comparing Data Dynamically with Charts
18. Final Comments & Credits

Access 2007: Essentials
Chapter 1: INTRODUCING ACCESS 2007 (17 min)
1. Defning a Database
2. Knowing When to Use Access?
3. Working with Database Objects
4. Converting Older Databases

Chapter 2: EXPLORING THE NEW USER INTERFACE (84 min)
1. Exploring the Getting Started Screen
2. Opening a Microsoft Template
3. Using the Navigation Pane
4. Using the Home Tab, Part 1
5. Using the Home Tab, Part 2
6. Using the Create Tab
7. Using the External Data Tab
8. Using the Database Tools Tab
9. Using the Office Menu
10. Explaining the Access Options
11. Using the Quick Access Toolbar
12. Adding Custom Commands to the Quick Access Toolbar
13. Using the Help Menu
14. Understanding the Message Bar
15. Creating Trusted Locations
16. Working in the Object Window

Chapter 3: WORKING IN THE NAVIGATION PANE (45 min)
1. Displaying Categories
2. Showing Views
3. Sorting the Objects
4. Searching for Objects
5. Collapsing Groups
6. Creating Custom Groups
7. Adding Object Shortcuts
8. Hiding Custom Groups
9. Changing the Interface Mode
10. Final Comments & Credits
 

PowerPoint 2007: Essentials

Chapter 1: SEEING POWERPOINT WITH NEW EYES (17 min)
1. Navigating the Ribbon
2. The Quick Access Toolbar
3. The Oce File Button
4. PowerPoint Options
5. Examining the Different Views
Chapter 2: UNDERSTANDING THE BASICS (20 min)
1. Dening Themes
2. Creating Color Schemes
3. Specifying Theme Fonts & Effects
4. Modifying Slide Masters & Layouts
5. Choosing Background Styles
6. Creating Custom Slide Layouts

Chapter 3: STARTING YOUR PRESENTATION (17 min)
1. Starting the Presentation
2. Adding Slides
3. Working with the Outline Pane
4. Adding Slides from Text Files
5. The Reuse Slides Pane
6. Editing Slides Using Copy & Paste

Chapter 4: FORMATTING TEXT (14 min)
1. The Font Dialog Box
2. Applying Text Fills & Effects
3. Paragraph Settings
4. Using Tabs & Indent Markers

Chapter 5: USING DRAWING TOOLS (16 min)
1. Inserting & Modifying Shapes
2. Using the Picture Fill
3. Using the Gradient Fill
4. Applying Shape Effects
5. Arranging Your Shapes

Chapter 6: USING PICTURES 19 min)
1. Inserting Pictures
2. Using the Clip Art Pane
3. Formatting & Arranging Images
4. Creating a Photo Album

Chapter 7: WORKING WITH SMARTART? 10 min)
1. Converting Text to SmartArt
2. Formatting SmartArt Diagrams
3. Modifying SmartArt Diagrams

Chapter 8: CREATING TABLES & CHARTS 28 min)
1. Creating a Table
2. Formatting a Table
3. Creating a Chart
4. Adjusting the Design & Layout of a Chart
5. Additional Formatting Options for Charts

Chapter 9: USING ANIMATION (41 min)
1. Types of Animations
2. Animating Text
3. Animating AutoShapes
4. Animating Charts
5. Animating Tables
6. Animating SmartArt
7. Combining Animations
8. Creating Trigger Animations
9. Applying Slide Transitions

Chapter 10: ADDING MULTIMEDIA (17 min)
1. Adding Sound to a Presentation
2. Playing Sound across Slides
3. Adding Video to the Presentation
4. Adding Adobe? Flash? SWFs

Chapter 11: MAKING YOUR PRESENTATION (12 min)
1. Opening in Slide Show View
2. Navigating with the Keyboard
3. Using Presenter View
4. Printing Handouts & Speaker Notes

Chapter 12: SHARING YOUR PRESENTATION (22 min)
1. Adding Action Buttons & Links
2. Recording Narrations
3. Checking Compatibility
4. Using the File Inspector
5. Using the Package for CD Command

Chapter 13: TIPS & TRICKS (11 min)
1. Pinning Files to the Open Panel
2. Using Connectors & Edit Points
3. Using the Freeform, Scribble & Curve Tools
4. Animating Master Slides
5. Exploring the Save As Options
6. Final Comments & Credits