Course Contents for Office 2007

Welcome to Microsoft Office 2007
Overview of Word, Excel, PowerPoint and Outlook
Starting and Closing an application
Finding Files
Getting Help
Navigating in the New Office
Discoverability
The “Result Oriented” User Interface
Ribbon and Other Things
Title Bar and Tab Row
Ribbon
Quick Access Toolbar
Live Preview
Galleries
The Mini Toolbar
Shortcut or Contextual menus
Enhanced Screen Tips
Task Panes and Status Bar
The Office Button
Mastering Fundamental Operation
Working with Files
Using Office 2007 new File Formats
Handling Previous File Formats
Creating Documents with MS Word 2007
Creating and Working with Documents
Creating New Documents
Navigating in Word- Find & Replace and using Go To
Using Different Views Word’s Autocorrect features
Saving the Document
Working with Text
Entering, Editing and Selecting the text
Formatting Text-Characters, Paragraphs, Pages and Sections
Headers, Footers ,Page Numbers and Creating Footnotes
Printing the documents
Working with Tables
Creating, Editing and Formatting the Tables
Using Sort and Formulas
The Table’s and Border Toolbar
Using AutoSum
Forms, Fields and Merging
Inserting and Updating Fields
Inserting and Protecting Forms
Using Mail Merge
Outlines, Table of Contents, and Indexes
Creating and Modifying Outlines
Building a Table of Contents
Creating an Indexes
Styles and Templates
Applying Word Built in Styles
Creating and Modifying Styles
Attaching a Template
Creating and Modifying Templates
Getting Graphical
Using Bulleted and Numbered List
Using Columns
Adding Borders and Shading
Inserting Pictures- Pictures, Auto Shapes, Word Art and Drawing
Working with Others on Word Document
Collaborating with Many Users on a Single Documents – Inserting voice and Handwritten Comments
Tracking Changes in a Document
Using Versions
Protecting Your Document with Digital Signatures
Creating Master and Sub Documents
MS Excel 2007Level 1
Managing Workbooks and Worksheets
Renaming, Copying and moving data between sheets
Freezing the Titles
Modifying Page Setup Options
Insert and Delete, Copy and Move Sheets
Preview and Print Sheets
Working with Formulas, Functions and Referencing
Creating User Defined Formulas
Using Built in Functions such as Sum, Average, Max, Min, Product, If, And, Or, Not, Count, Counta, Countblank, CountIf , Sumif, Day, Month, Year, Left, Right, Search, Lower, Upper, Proper, Repeat, Len, Min, Max, Small, Large, Exact, Round, Roundup, Rounddown, Roman, Rank, Sumproduct, etc
Freezing a cell address in a formula (Absolute Referencing)
Linking various sheets and Workbooks in a formula (3D Referencing)
Formatting Worksheets and Workbooks
Formatting cells, rows, columns and numbers
Auto format, Conditional Formatting
Hiding and Protecting
Copy and Paste Special options
Working with Charts
Chart Terminology
Defining Major Chart Types and plotting chats on 2 axis
Formatting the Charts
Chart Titles, Location and linking them with other applications such as Word or PowerPoint
Printing the Charts
Working with Data
Creating Custom Lists and Sorting Data by using Advanced Techniques
Splitting the Data using Text to Columns
Extracting Data by using Filters and Advanced Filters
Smart Working
Linking Sheets with Hyperlinks
Making work faster by using Shortcut Keys
MS Excel 2007 Level 2
Working with Range and Naming Convention
Apply a Name to a cell or range of cells
Modify and Delete range names
Automatically creating the names to a range of cells by the headings
Using Advanced Functions
Lookup, Vlookup, Hlookup, Match and Index, PV, FV, PMT, PPMT, IPMT
Workdays and Networkdays
Working with Data
Importing the Data from External Sources & Removing Duplicate Records
Applying Subtotals
Data Validation and Consolidation
Grouping and Ungrouping
Pivot Tables and Pivot Charts
Creating a Pivot table
Modifying a Pivot table field Layout
Creating Groups and Inserting a calculated Field
Creating a Pivot Chart
Performing Spreadsheets What If Analysis
Creating Data Tables
Using Scenarios Manager
Analysing Data by using Goal Seek and Solver
Single Cell Goal Seeking
Using Solver
Macros
Recording the Macro
Assigning Macro to a Toolbar
Understanding VB Editor
Creating Presentations Using MS PowerPoint 2007
1 / Beginning a Presentation
Planning Great Presentation
Working with PowerPoint User Interface
Choosing Slide Layout
Using Outlines to Plan and Organize
Navigation through a Presentation
2 / Entering and Formatting Text
Entering Text in Outline and Slide Pane
Importing Text from Other applications
Formatting Text- Styles, Alignment, Bulleted and Numbered Lists, Spacing, Colors and other buttons on the Toolbar
3 / Using Templates and Wizards
Using the Auto Content Wizard
Using the Slide Layout Task pane
Using Masters – Slide Master, Handout Master and Notes Master
Using Design Templates
Creating and Saving Your Own Templates
4 / Creating Charts and Tables
Exploring Chart Types
Creating and Editing Charts
Formatting Charts- Data Series, Chart Area, Axis, Adding a Trendline, and many more
Creating an Organization Chart or Diagram
Creating and Editing Tables
Inserting Excel Worksheets and Word Tables
5 / Adding Graphics and Special Effects
Adding Pictures and Multimedia- Images, Photo Album, Sound and Movies
Selecting Slides and adding transitions
Applying an animation scheme and custom animations
Creating Action Buttons
6 / Finalizing the Slide Show
Rearranging the Slide show and hiding the slides
Adding Comment and Speaker Notes
Setting up Slide Shows
Custom Slide Shows
Recording a narration
Packaging the Presentation for a CD
Putting the Presentation on the Web
Printing the Slides
Broadcasting over the Internet or Intranet
Using MS Outlook 2007
1 / Outlook Overview
Creating New Folders
Using the Navigation Pane
Working with Customized Views
Configuring and Using Multiple Mail Accounts
Addressing, Sending and Reading Messages
Saving, Printing and Deleting Messages
2 / Advanced Message Management
Organizing Messages with Search Folders
Quick Flagging Messages
Creating Mail Filtering Rules
Archiving Messages
Exporting and Importing Messages
Sending Business Cards
Using Signatures and Receipts
Attaching Files to Messages
Finding the Message You Want
3 / Outlook Security
Dealing with Junk Email
Turning Off Web Beacons
Outlook Security Settings- Encrypted emails, Security Zones and Digital ID
Permissions
Email Safety Tips
4 / Creating and Maintaining a Contact List
Adding, Importing and Editing Contacts
Creating Distribution Lists
Associating Contacts with other Outlook Items
Mail Merging Outlook Contacts with Word
Business Contact Manager
5 / Managing Time with Calendar
Adding and Editing the Tasks
Assigning a Task to someone else
Using Calendar
Creating and Managing Appointments and Events
Importing Appointments and Events
Sending Calendar Information to Other Users

Productivity Expertz