 |
Summary of Office 2007 Training
Microsoft Office course teaches you how to effectively use the Office 2007 Suite through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the new office interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2007 edition. These courses will train you how to best meet your needs through the use of Word, Outlook, Excel, Powerpoint, and/or Access.
|
Outline summary
Microsoft Access 2007: Beginner
1.0 Getting Started
2.0 Working with an Existing Table
3.0 Working with an Existing Form
4.0 Sorting and Filtering
5.0 Designing Select Queries
6.0 Form Basics
7.0 Report Basics
8.0 Printing Database Objects
Microsoft Access 2007: Intermediate
1.0 Planning and Designing a Database
2.0 Building and Modifying Tables
3.0 Working with Relationships
4.0 Sharing Your Data
5.0 Enhancing Your Forms
6.0 Enhancing Your Reports
Microsoft Access 2007: Advanced
1.0 Preventing Data Entry Errors
2.0 Advanced Table Design
3.0 Advanced Query Design
4.0 Advanced Form Design
5.0 Advanced Report Design
6.0 Managing Databases
Microsoft Access 2007: Expert
1.0 Expertly Designed Select Queries
2.0 Action Queries
3.0 Expertly Designed Forms
4.0 Expertly Designed Reports
5.0 Data Access Pages
6.0 Macros
7.0 Database Security
Microsoft Excel 2007: Beginner
1.0 Getting Started
2.0 Entering Data
3.0 Changing Worksheet Layout
4.0 Entering Formulas
5.0 Formatting
6.0 Using Themes and Styles
7.0 Printing
8.0 Charts
Microsoft Excel 2007: Intermediate
1.0 Managing Workbooks
2.0 Tables and Data Management
3.0 Using Cell References
4.0 Auditing
5.0 Creating Web Pages from Workbooks
6.0 Using Excel with Other Applications
7.0 Customizing Excel
8.0 Using Scenarios and Watching Cells
9.0 PivotTables and PivotCharts
Microsoft Excel 2007: Advanced
1.0 Collaborating
2.0 Advanced Formulas and Functions
3.0 Data Consolidation
4.0 SmartArt
5.0 Track Revisions
6.0 Data Validation and Conditional Formatting
7.0 Creating Templates
8.0 Macros
Microsoft Outlook 2007: Beginner
1.0 Getting Started
2.0 Reading & Sending E-mail
3.0 Replying to & Forwarding Messages
4.0 Formatting Messages
5.0 Working with E-mail Addresses
6.0 Managing Mail
7.0 Printing E-mail Messages
Microsoft Outlook 2007: Intermediate
1.0 Using the Calendar
2.0 Planning Meetings & Appointments
3.0 Advanced Contact Options
4.0 Using Tasks
5.0 Using Notes
6.0 Advanced Mail Message Options
7.0 Working with Themes
Microsoft Outlook 2007: Advanced
1.0 Filtering, Finding & Flagging Messages
2.0 Archiving Outlook Data
3.0 Personal File Folders
4.0 Using the Journal
5.0 Organizing Your Outlook Items
6.0 Custom Forms
7.0 Working with Pictures and Shapes
8.0 Working with WordArt & SmartArt
9.0 Customizing Outlook
Microsoft PowerPoint 2007: Beginner
1.0 Getting Started
2.0 Creating a New Presentation
3.0 Viewing Presentations
4.0 Modifying an Existing Presentation
5.0 Preparing a Presentation for Delivery
Microsoft PowerPoint 2007: Intermediate
1.0 Outlines
2.0 Working with Pictures and Shapes
3.0 Working with Presentation Colors
4.0 Working with Animation
5.0 Organizing & Enhancing Your Presentation
6.0 Managing Presentations
7.0 Customizing PowerPoint
Microsoft PowerPoint 2007: Advanced
1.0 Working with Tables
2.0 Working with Charts
3.0 WordArt & SmartArt
4.0 Working with Templates, Masters & Custom Layouts
5.0 Saving Presentations for the Web
6.0 Collaboration
7.0 Advanced Presentation Delivery Options
Microsoft Word 2007: Beginner
1.0 Getting Started
2.0 Creating New Documents
3.0 Editing Existing Documents
4.0 Essential Word 2007 Skills
5.0 Formatting Text & Paragraphs
6.0 Proofing Tools
7.0 Changing Your Page Appearance
Microsoft Word 2007: Intermediate
1.0 Managing Documents
2.0 Additional Editing Tools
3.0 Paragraph Formatting
4.0 to Graphics
5.0 Document Formatting
6.0 Tables
7.0 Customizing Word
Microsoft Word 2007: Advanced
1.0 Working with Document Templates
2.0 Mail Merge
3.0 Macros
4.0 Working with Themes
5.0 SmartArt
6.0 Long or Complex Documents
7.0 Collaborating
8.0 Using Word with Other Programs
9.0 Using XML
|
Office Training Return Policy: You may open and view 1 DVD for "demo" purposes and still be able return the product within 15 days. Any Keystone Training Products that have more than 1 tape or 1 CD opened or unsealed, are no longer covered under the 15 Day Money Back Guarantee Policy.
DVD ROM'S: This Training set will only run on DVD ROM computer players only. These DVD's WILL NOT run on entertainment DVD players that are connected to TV's. An Internet connection is also required.
|
