MS Office 2007 Professional Course
MS Office 2007 Professional Course
Best for Advance Office Working as Office Assistant.
MS Office 2007 has many new features which are very attractive and helpfully in official Crosspondance, many new templates are introduced in Ms office 2007. and easy to use.
Course Outline
Chapter 1: GETTING STARTED WITH WORD
1. Touring the New Office 2007 Interface
2. Formatting Basic Text
3. Applying Formatting to a Paragraph
4. Creating Bulleted and 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
1. Adding Headers and Footers
2. Inserting Watermarks
3. Formatting the Overall Document
4. Inserting Graphical Elements
5. Inserting Clip Art
6. Using Smart Art
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®
1. Touring the Excel Interface
2. Inserting, Moving and Selecting Content
3. Format Numerical Data and Reference Cells
4. Building a Table and Using Auto Fill
5. Inserting and Deleting Rows and Columns
6. Introducing Formulas
7. Introducing Functions
8. Using the Insert Function Dialog Box
9. Using Statistical Functions and the Status Bar
10. Using Auditing Commands
11. Exploring Absolute Cell Referencing
12. Naming Cell Ranges and Using Name Manager
13. Pasting Data and Using the Clipboard
Chapter 4: FORMATTING and STYLIZING IN EXCEL®
1. Formatting Cells
2. Using Format Painter
3. Number Formatting
4. Using Cell Styles
5. Creating Cell Styles
6. Changing Styles
7. Using and 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®
1. Touring the Power Point 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 Smart Art
9. Creating and Formatting Charts
10. Using Word Art 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®
1. Touring the Outlook Interface
2. Using E-mail
3. Creating Signatures and New Folders
4. Using a Calendar and Adding Events
5. Working with Multiple Calendars
6. Sharing Calendars
7. Adding and Viewing Contacts
8. Creating, Viewing and Flagging Tasks
Chapter 7: MANAGING DATA WITH ACCESS™
1. Introducing Access and Touring the Interface
2. Adding and Deleting Contacts
3. Filtering Data
4. Creating and Exporting Forms
5. Creating Reports
6. Exporting Data
Chapter 8: A SEAMLESS OFFICE 2007 WORKFLOW
1. Formatting and 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 Power Point
11. Publishing Handouts to Word
12. Going from Word to Outlook
13. Sending Invites with Outlook
14. Sending Meeting Requests
15. Final Comments and Credits
Course End
1. Touring the New Office 2007 Interface
2. Formatting Basic Text
3. Applying Formatting to a Paragraph
4. Creating Bulleted and 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
1. Adding Headers and Footers
2. Inserting Watermarks
3. Formatting the Overall Document
4. Inserting Graphical Elements
5. Inserting Clip Art
6. Using Smart Art
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®
1. Touring the Excel Interface
2. Inserting, Moving and Selecting Content
3. Format Numerical Data and Reference Cells
4. Building a Table and Using Auto Fill
5. Inserting and Deleting Rows and Columns
6. Introducing Formulas
7. Introducing Functions
8. Using the Insert Function Dialog Box
9. Using Statistical Functions and the Status Bar
10. Using Auditing Commands
11. Exploring Absolute Cell Referencing
12. Naming Cell Ranges and Using Name Manager
13. Pasting Data and Using the Clipboard
Chapter 4: FORMATTING and STYLIZING IN EXCEL®
1. Formatting Cells
2. Using Format Painter
3. Number Formatting
4. Using Cell Styles
5. Creating Cell Styles
6. Changing Styles
7. Using and 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®
1. Touring the Power Point 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 Smart Art
9. Creating and Formatting Charts
10. Using Word Art 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®
1. Touring the Outlook Interface
2. Using E-mail
3. Creating Signatures and New Folders
4. Using a Calendar and Adding Events
5. Working with Multiple Calendars
6. Sharing Calendars
7. Adding and Viewing Contacts
8. Creating, Viewing and Flagging Tasks
Chapter 7: MANAGING DATA WITH ACCESS™
1. Introducing Access and Touring the Interface
2. Adding and Deleting Contacts
3. Filtering Data
4. Creating and Exporting Forms
5. Creating Reports
6. Exporting Data
Chapter 8: A SEAMLESS OFFICE 2007 WORKFLOW
1. Formatting and 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 Power Point
11. Publishing Handouts to Word
12. Going from Word to Outlook
13. Sending Invites with Outlook
14. Sending Meeting Requests
15. Final Comments and Credits
Course End
