call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Save up to 30%
Off Publishers Retail Prices

courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST, FREE UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted




Office 2007 Complete Training Bundle

 
Bookmark and Share
Microsoft Office 2007 Training CDs
CareerVision
Limited Time Offer
Save up to 30%
Office 2007 Complete Training Bundle
DVD-ROM Bundle £397.00  £198.00 + VAT
Buy Now
12 Month Online Bundle £397.00  £198.00 + VAT
Buy Now
Multi User DVD Course £794.00  £397.00 + VAT
Buy Now
 

More on Single User, Multi User & Network Licences

More on Online Training

 

PACKAGE INCLUDES

  • Word 2007 Beginner to Advanced Set of 3 DVDs
  • Excel 2007 Beginner to Advanced Set of 3 DVDs
  • Access 2007 Beginner to Advanced Set of 3 DVDs
  • PowerPoint 2007 Beginner to Advanced Set of 2 DVDs
  • Outlook 2007 Beginner to Advanced Set of 3 DVDs

  • 14 Multimedia Training DVD-ROMs featuring live instructor-led classroom sessions with full motion audio/video
  • Hands-on Lab Demonstrations
  • Testing Modules to insure that you fully understand the subject matter.
  • Proven technique- Actual Exam Secrets Review
  • Free 1 Year Upgrade Policy


    COURSE INTRODUCTION

    Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.

    Microsoft Office Professional 2007 is a complete suite of productivity and database software that will help you save time and stay organized. Powerful contact management features help you manage all customer and prospect information in one place. Develop professional marketing materials for print, e-mail, and the Web, and produce effective marketing campaigns in-house. Create dynamic business documents, spreadsheets, and presentations, and build databases with no prior experience or technical staff. You will learn new features rapidly using improved menus that present the right tools when you need them.

    Microsoft Excel 2007 Launch Video Demo

    SPECIAL FEATURES OF OUR TRAINING COURSES


    Comprehensive Menu Structure 
    Move through hours of in-depth content - quickly and easily with the time saving Main Menu and Sub-Menu structure. Search for a specific topic or go through the course step by step. The choice is yours.   


    Player Controls
    Move forward or back, repeat entire topics or just a section. A progress bar illuminates as you advance through the video tutorials and exercises. Play, pause rewind, fast forward or stop at any time


    Continue Where You Left Off 
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you were.


    Full Motion Video and Audio 
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.


    Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.


    Live Demonstrations
    Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.


    Interactive Labs
    This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software without the need for purchasing it or having it installed on your computer.


    PowerPoint Presentations 
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...


    Multi-User Licencing 
    All of our courses can be purchased with a standard Single User Licence, Multi User Library Licence or a Network Licence. Please contact us for more information and prices.


    Certificate of Completion 
    Our Training Courses are recognized worldwide for their technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a CareerVision Distance Education Certificate of Completion.




  • COURSE OUTLINE

    MS Word 2007 Level One

    Lesson 1 - Exploring the Word Environment
    Exploring the Word Environment
    Document
    Microsoft Office Word 2007
    Word Document
    Demo - Explore Word
    Lab - Exploring the User Interface Elements in a Word Environment
    The Microsoft Office Button
    The Ribbon
    Lab - Exploring the Various Elements on the Ribbon
    The Microsoft Office Window Frame
    The Home Tab
    The Insert Tab
    The Page Layout Tab
    The Review Tab
    The View Tab
    Dialog Box Launchers
    Galleries
    Live Preview
    Document Views
    Demo - View Document
    Lab - Viewing a Document
    Word Help
    Word Help Options
    Demo - Help
    Word Help Toolbar
    Lab - Searching for Information Using Microsoft Word Help
    Lesson 1 Review

    Lesson 2 - Creating a Document
    Creating a Document
    AutoCorrect Dialog Box
    Word Wrap
    Formatting Marks
    Saving Files
    Demo - Create Document and Save
    Save As Command
    Lab - Saving a Document
    Compatibility Checker
    Print Preview Options
    Demo - Preview and Print
    Print Dialog Box
    Lab - Previewing a Document
    Lab - Printing a Document
    Word Options Dialog Box
    Demo -Word Options
    Lab - Customizing the Microsoft Office User Interface
    Lab - Customize the Microsoft Office Window Frame
    Lesson 2 Review

    Lesson 3 - Editing a Document
    Editing a Document
    Scroll Bars
    Selection Bar
    Demo - Move Cursor and Selecting Text
    Mini Toolbar
    Clipboard Group
    Text Pasting Options
    Demo - Cut, Copy, and Paste
    Lab - Moving Text Within a Document
    Lab - Copying Text Between Documents
    Lab - Pasting Text in a Document
    Clipboard Task Pane
    Find And Replace Dialog Box
    Find Options
    Replace Options
    Demo - Search and Replace
    Go To Options
    Lesson 3 Review

    Lesson 4 - Formatting Text
    Formatting Text
    Styles
    Fonts
    Font Styles
    Font Case
    Demo - Change Font and Size
    Lab - Changing the Font and Font Size
    Effects
    Demo - Font Styles and Effects
    Lab - Applying Font Styles and Effects
    Lab - Change Text Color
    Lab - Highlighting Text in a Document
    Lab - Removing Text Highlights
    Reveal Formatting Task Pane
    Demo - Paste Formats
    Demo - Clear Formatting
    Lab - Clearing Text Formatting
    Lesson 4 Review

    Lesson 5 - Formatting Paragraphs
    Formatting Paragraphs
    Margins
    Rulers
    Tabs Dialog Box
    Demo - Tab Stops
    Indents
    Indentation Options
    Demo - Alignment
    Lab - Aligning Paragraphs
    Borders
    Shading
    Borders And Shading Dialog Box
    Demo - Indents and Borders
    Lab - Applying Borders and Shading to a Paragraph
    Quick Styles in Word
    Styles Task Pane
    Lab - Applying Paragraph Styles
    List
    Bulleted List
    Numbered List
    Demo - Styles, Bullets, and Numbers
    Text Spacing Options
    Lab - Changing the Space Between Lines of Text
    Lesson 5 Review

    Lesson 6 - Adding Tables
    Adding Tables
    Tables
    Contextual Tabs
    Table Tools Design Contextual Tab
    Table Properties Dialog Box
    Quick Tables
    Demo - Insert Columns and Rows
    Lab - Inserting a Table
    Table Styles
    Demo - Format a Table
    Table Style Options Group
    Convert Text To Table Dialog Box
    Convert Table To Text Dialog Box
    Demo - Creating a Table and Adding Text
    Demo - Convert Text to Table
    Lab - Converting Text to Table
    Lesson 6 Review

    Lesson 7 - Enhancing Visual Appeal Using Graphic Objects
    Enhancing Visual Appeal Using Graphic Objects
    Symbols
    Special Characters
    Illustrations
    Picture
    Clip Art
    Illustrations Group
    Clip Art Task Pane
    Sizing Handles
    Demo - Insert Graphics
    Lab - Inserting a Picture from Clip Art
    Picture Tools Format Contextual Tab
    Watermark
    Printed Watermark Dialog Box
    Demo -Watermarks
    Lab - Adding a Text Watermark
    Lesson 7 Review

    Lesson 8 - Proofing a Document
    Proofing a Document
    Research Task Pane
    Thesaurus
    Lab - Using a Thesaurus to Replace a Word
    Research Options Dialog Box
    Readability Statistics Dialog Box
    Spelling and Grammar Options
    Demo - Spelling and Grammar
    Lab - Checking a Documents Spelling and Grammar
    Custom Dictionary
    Custom Dictionaries Dialog Box
    Demo - Autocorrect
    Lab - Customizing the AutoCorrect Options
    Lab - Counting Words in a Document
    Lesson 8 Review

    Lesson 9 - Controlling Page Appearance
    Controlling Page Appearance
    Page Orientation
    Paper Size
    Page Setup Dialog Box
    Demo - Margins and Orientation
    Lab - Changing a Documents Page Orientation and Margin
    Page Border
    Border Types
    Demo - Borders and Art
    Lab - Applying an Art Page Border
    Page Color
    Headers and Footers
    Header & Footer Design Contextual Tab
    Demo - Headers and Footers
    Lab - Adding a Header and Footer
    Lab - Modifying Headers and Footers
    Demo - Page Breaks
    Lab - Inserting Manual Page Breaks
    Lab - Modifying a Document in Print Preview
    Lesson 9 Review
    Course Closure

    MS Word 2007 Level Two

    Lesson 1 - Managing Lists
    Managing Lists
    Sort Field
    Demo - Sorting a List
    Lab - Sorting a List
    Renumbering Options
    Demo - Renumbering Lists
    Lab - Renumbering Lists
    Multilevel Lists
    Multilevel List Gallery
    Demo - Multilevel Lists
    Lab - Structuring a List on Multiple Levels
    Lab - Customizing a List
    Lesson 1 Review

    Lesson 2 - Customizing Tables and Charts
    Customizing Tables and Charts
    Cell Merge
    Cell Split
    Text Positioning Options
    Cell Alignment
    Text Orientation
    Demo - Formatting a Table and Cell Alignment
    Lab - Modifying Cell Structure
    Lab - Positioning Text in a Cell
    Demo - Borders and Shading
    Lab - Applying Borders and Shading
    Lab - Sorting Data in a Table
    Equations
    Equation Tool
    Function
    Lab - Building an Equation
    Formulas in Word Table
    Demo - Typing Formulas
    Demo - Creating Formulas
    Lab - Performing Calculations in a Table
    Charts
    Chart In Microsoft Office Word Window
    Demo - Creating Charts
    Lab - Creating a Chart
    Lesson 2 Review

    Lesson 3 - Customizing Character and Paragraph Formats
    Customizing Character and Paragraph Formats
    Character Spacing
    Character Spacing Options
    Demo - Character Spacing
    Lab - Controlling Character Appearance
    Formatting Paragraphs
    Demo - Paragraph Spacing
    Lab - Controlling Paragraph Flow
    Lesson 3 Review

    Lesson 4 - Customizing Styles for Document Elements
    Customizing Styles for Document Elements
    Paragraph Styles
    Character Styles
    Custom Styles
    Lab - Creating a Custom Style
    Templates in Word
    Style Modification Options
    Lab - Modifying a Style
    List Style
    The Define New List Style Dialog Box
    Lab - Creating a List Style
    Table Style
    Lab - Creating a Table Style
    Demo - Styles
    Demo - Modifying Styles
    Lesson 4 Review

    Lesson 5 - Modifying Pictures
    Modifying Pictures
    Cropping
    Demo - Picture Cropping
    Lab - Resizing a Picture
    Picture Contrast
    Picture Brightness
    The Recolor Gallery
    Demo - Picture Properties
    Lab - Setting Picture Prominence
    Text Wrapping Style
    Lab - Setting the Text Wrapping Style for a Picture
    Lesson 5 Review

    Lesson 6 - Creating Customized Graphic Elements
    Creating Customized Graphic Elements
    Shapes in Word
    Drawing Canvas
    Demo - Adding Shapes
    Lab - Drawing a Shape
    WordArt
    WordArt Tools Format Contextual Tab
    Demo -WordArt
    Drop Caps
    Lab - Adding Special Effects to Text
    Text Box
    Text Box Tools Format Contextual Tab
    Lab - Displaying Text as Graphic Using Text Boxes
    SmartArt Graphics
    Demo - SmartArt
    Lab - Creating a Complex Illustration
    Lesson 6 Review

    Lesson 7 - Structuring Content Using Quick Parts
    Structuring Content Using Quick Parts
    Building Blocks
    Sidebars
    The Modify Building Block Dialog Box
    Demo - Viewing Building Blocks
    Demo - Create Quick Parts
    Lab - Creating a Quick Part
    Lab - Inserting a Building Block
    Lab - Modifying a Building Block
    Demo - Insert Field
    Lesson 7 Review

    Lesson 8 - Controlling Text Flow
    Controlling Text Flow
    Section Breaks
    Types of Section Breaks
    Demo - Section Breaks
    Lab - Inserting Section Breaks
    Demo - Headers and Footers
    Lab - Adding a Header and Footer for a Document Section
    Text Columns
    Text Columns Options
    Demo - Columns
    Lab - Inserting Columns
    Pull Quotes
    Demo - Pull Quotes
    Lab - Creating Pull Quotes
    Demo - Text Flow
    Lab - Linking Text Boxes
    Lesson 8 Review

    Lesson 9 - Automating Tasks
    Automating Tasks
    Macros
    Demo - Macros
    Lab - Performing a Task Automatically Using a Macro
    Lab - Recording a Macro
    Lab - Modifying a Macro
    Demo - Create Macros
    Visual Basic for Applications (VBA)
    Lesson 9 Review

    Lesson 10 - Automating Document Creation
    Automating Document Creation
    Template Categories
    Template Wizards
    Demo - Using Templates
    Demo - Creating Templates
    Lab - Creating a Document Using a Wizard
    Lab - Changing the Default Font of a Template
    Lab - Changing the Default Template Location
    Field Codes
    Document Themes
    Demo - Themes
    Lab - Applying a Customizing Document Themes
    Lab - Create a Custom Theme Lesson 10 Review

    Lesson 11 - Automating Mail Merges
    Automating Mail Merges
    Mail Merge
    Merge Fields
    Data Source
    The Mail Merge Process
    Demo - Mail Merge
    Demo - Mail Merge Labels
    Lab - Performing a Mail Merge
    Lab - Merging Labels
    Lab - Testing the Data Source
    Lesson 11 Review
    Course Closure

     

    MS Word 2007 Level Three

    Lesson 1 - Using Microsoft Office Word 2007 with Other Programs
    Using Microsoft Office Word 2007 with Other Programs
    Data Linking
    Linking to a Worksheet
    Break an Obsolete Link
    Demo - Linked XL File
    Outline View
    Send Document Outline to PowerPoint
    Demo - Outline View and Export to Outline
    Microsoft Office Document Imaging
    Extract Text from File
    Demo - Extracting Text from a Fax
    Demo - Sending Document as Email Message
    Lesson 1 Review

    Lesson 2 - Collaborating on Documents
    Collaborating on Documents
    The Collaboration Process
    The Document Information Panel
    Demo - The Document Information Panel
    Document Review
    The Track Changes Options Dialog Box
    Demo - The Track Changes Options Dialog Box
    Demo - Delete Comments
    Comparing Documents
    The Compare Documents Dialog Box
    The Combine Documents Dialog Box
    Demo - The Compare and Merge Documents Dialog Box
    Full Screen Reading View
    Lesson 2 Review

    Lesson 3 - Managing Document Versions
    Managing Document Versions
    Create New Version of a Document
    Demo - Create New Version of a Document
    Demo - Version of a Document
    Procedure Reference
    Lesson 3 Review

    Lesson 4 - Adding Reference Marks
    Adding Reference Marks
    The Bookmark Dialog Box
    Demo - The Bookmark Dialog Box
    Footnotes and Endnotes
    The Footnote And Endnote Dialog Box
    Demo - The Footnote And Endnote Dialog Box
    Captions
    Caption Dialog Box
    Demo - Caption Dialog Box
    Hyperlink
    The Insert Hyperlink Dialog Box
    Demo - The Insert Hyperlink Dialog Box
    Cross-References
    The Cross-Reference Dialog Box
    Demo - The Cross-Reference Dialog Box
    Bibliographies
    Demo - Bibliographies
    Lesson 4 Review

    Lesson 5 - Making Long Documents Easier to Use
    Making Long Documents Easier to Use
    Insert Blank and Cover Pages
    Demo - Insert Blank and Cover Pages
    The Mark Index Entry Dialog Box
    Concordance File
    The Index Dialog Box
    Demo - The Index Dialog Box
    The Style Dialog Box
    The Modify Style Dialog Box
    The Table Of Figures Dialog Box
    Demo - The Table Of Figures Dialog Box
    The Mark Citation Dialog Box
    The Table Of Authorities Dialog Box
    The Table Of Contents Dialog Box
    Demo - The Table Of Contents Dialog Box
    The Mark Table Of Contents Entry Dialog Box
    Master Documents
    Demo - Master Documents
    The Outlining Tab
    The AutoSummarize Dialog Box
    Demo - The AutoSummarize Dialog Box
    Lesson 5 Review

    Lesson 6 - Securing a Document
    Securing a Document
    Update a Document?s Properties
    Demo - Update a Document?s Properties
    Demo - The Document Inspector Dialog Box
    The Document Inspector Dialog Box
    Hide Text
    How to Hide Text
    The Restrict Formatting And Editing Task Pane
    Demo - The Restrict Formatting And Editing Task Pane
    Digital Signature
    The Signature Line
    The Signatures Task Pane
    Set a Password for a Document
    The Mark As Final Option
    Lesson 6 Review
    Course Closure



     

    MS Excel 2007 Level One

    Lesson 1 - Exploring the Excel Environment
    Exploring the Excel Environment
    Spreadsheets
    Microsoft Office Excel 2007
    The Excel Application Window
    Worksheets
    Workbooks
    The Microsoft Office Button
    Demo - Explore User Interface
    Lab - Explore User Interface
    The Ribbon
    Demo - Ribbon
    Lab - Exploring the Ribbon
    The Quick Access Toolbar
    Demo - Quick Access Toolbar
    The Microsoft Office Window Frame
    The Home Tab
    The Insert Tab
    The Page Layout Tab
    The Formulas Tab
    The Data Tab
    The Review Tab
    The View Tab
    Dialog Box Launchers
    The Excel Help Window
    Demo - Help
    Lab - Obtaining Help
    The Excel Help Toolbar
    Customization Options
    Lab - Customizing the Quick Access Toolbar
    Lesson 1 Review

    Lesson 2 - Working with an Excel Worksheet
    Working with an Excel Worksheet
    Mouse Navigation Options
    Demo - Navigation
    Lab - Navigation in Excel
    The New Workbook Dialog Box
    The Mini Toolbar
    Demo - Enter Data
    Lab - Selecting an Entering Data
    File Formats
    Demo - Saving
    Lab - Saving a Workbook
    Lab - Converting an XLS Workbook to an XLSX Workbook
    Lab - Saving a Workbook in XLS Format
    Lesson 2 Review

    Lesson 3 - Modify a Worksheet
    Modify a Worksheet
    Undo and Redo
    Demo - Editing
    Auto Fill
    Demo - Auto Fill
    The Find Command
    The Replace Command
    Demo - Find and Replace
    Lab - Searching for Data in a Worksheet
    Cell References
    Cell Names
    Demo - Insert cells
    The Go To Command
    Lab - Locating a Cell in a Worksheet
    The Spelling Dialog Box
    Demo - Spell Check
    Lab - Spell Checking a Worksheet
    Lesson 3 Review

    Lesson 4 - Performing Calculations
    Performing Calculations
    Excel Formulas
    The Formula Bar
    Demo - Formula
    Lab - Creating Basic Formulas
    The Order of Operations
    Functions
    Formula AutoComplete
    Demo - Functions Lab - Calculating with other Basic Functions
    Relative References
    Demo - Coping Formulas and Functions
    Lab - Coping Formulas and Functions
    Absolute Reference
    Demo - Absolute
    Lab - Creating an Absolute Reference
    Mixed References
    Lab - Creating a Mixed Reference
    Lesson 4 Review

    Lesson 5 - Formatting a Worksheet
    Formatting a Worksheet
    Fonts
    Demo - Text to Column
    Lab - Converting Text to Columns
    Demo - Fonts
    Lab - Modifying Fonts
    The Format Cells Dialog Box
    Lab - Adding Borders and Colors to Cells
    Lab - Transposing Data While Pasting Content
    Demo - Column Widths and Row Height
    Lab - Changing Column Width and Row Height
    Live Preview
    Number Formats
    Lab - Applying Number Formats
    Lab - Aligning Cell Contents
    Demo - Merge and Split Cells
    Lab - Merging Cells
    Demo - Format Number
    Demo - Find and Replace Formats
    Lab - Replacing Formats
    Autoformats
    Lab - Applying an AutoFormat
    Cell Styles
    Demo - Styles
    Lab - Applying Cell Styles
    Themes
    Lab - Applying Themes
    Lesson 5 Review

    Lesson 6 - Developing a Workbook
    Developing a Workbook
    Worksheet Tabs
    Demo - Format Worksheet Tabs
    Lab - Formatting Worksheet Tabs
    Insert and Delete Worksheets
    Demo - Insert and Delete Sheets
    Lab - Inserting and Deleting Worksheets
    Lab - Copying and Pasting Worksheet
    Lesson 6 Review

    Lesson 7 - Printing Workbook Contents
    Printing Workbook Contents
    Headers
    Demo - Print Titles
    Footers
    Demo - Headers and Footers
    Lab - Creating a Header and Footer Header Dialog Box
    Page Margins
    Lab - Setting Page Margins
    Page Orientation
    Demo - Margins Orientation
    Lab - Changing Page Orientation
    Page Breaks
    Demo - Page Breaks
    Lab - Setting Page Breaks
    Lesson 7 Review

    Lesson 8 - Customizing Layout
    Customizing Layout
    Split Worksheet
    Demo - Window Split
    Lab - Splitting a Worksheet
    Freeze and Unfreeze
    Lab - Freezing and Unfreezing Rows and Columns
    Demo - Arrange
    Lab - Arranging Worksheets in New Windows
    Lab - Hiding and Unhiding Worksheet
    Lesson 8 Review
    Closure

    MS Excel 2007 Level Two

    Lesson 1 - Enhancing Workbooks
    Enhancing Workbooks Personalize Options
    Demo - Excel Options
    Lab - Customizing the Excel Interface
    Color Scheme
    Modified Excel Environment in Windows Vistas (Black)
    Built-In Theme Options
    Create New Theme Colors Options
    Create New Theme Fonts Options
    Demo - Custom Worksheet
    Lab - Customizing an Excel Worksheet
    Lab - Enhancing Worksheets using Themes
    Comments
    Demo - Comments
    Lab - Manipulating Comments
    Hyperlinks
    Demo - Creating Hyperlinks
    Lab - Creating a Hyperlink to an Existing File
    Lab - Editing and Removing Hyperlinks
    Research Task Pane
    Demo - Research
    Lab - Using Web-Based Research Tools
    Lesson 1 Review

    Lesson 2 - Creating Workbooks Using Templates
    Creating Workbooks Using Templates The Expense Template
    Demo - Using Templates
    Lab - Creating a Workbook from a Template
    Types of Excel Templates
    An Example of a Custom Template
    Demo - Creating Templates
    Lab - Creating a Custom Template
    Lesson 2 Review

    Lesson 3 - Organizing Data Using Tables
    Organizing Data Using Table sAn Excel Table
    Demo - Create Table
    Lab - Creating a Table Using the Default Table Style
    Demo - Table Styles
    Lab - Creating a Table Using the Desired Table Style
    Lab - Modifying a Table
    Lab - Formatting a Table
    Lab - Creating a Custom Table Style
    Lesson 3 Review

    Lesson 4 - Presenting Data Using Charts
    Presenting Data Using Charts Create A Chart
    Demo - Create A Chart
    Lab - Modifying a Table
    Modify Charts
    Lab - Modify a Chart
    Demo - Changing a Chart Type
    Format Charts
    Lab - Formatting a Chart
    Lab - Creating a Chart Template
    Share Charts
    Demo - Move Chart
    Lab - Sharing a Chart
    Lesson 4 Review

    Lesson 5 - Analyzing Data Using PivotTables and PivotCharts
    Analyzing Data Using PivotTables and PivotChartsSource Data for a PivotTable
    Summarizing Data with a PivotTable
    A PivotTable Report
    Demo - Create Pivot
    Lab - Performing Calculations Using a PivotTable
    A PivotChart
    Demo - Pivot Chart
    Lab - Creating a Pivot Chart
    An Existing PivotTable and Corresponding PivotChart
    Demo - Modify Pivot
    Lesson 5 Review

    Lesson 6 - Enhancing Visual Appeal Using Graphic Objects
    Enhancing Visual Appeal Using Graphic Objects
    Graphic Objects
    Demo - Insert and Modify Picture
    Lab - Inserting a Picture in a Worksheet
    Lab - Modifying Pictures
    Lab - Applying Picture Shape to a Graphic
    Lab - Drawing and Modifying Shapes
    Lab - Rotating Shapes
    Layering
    Lab - Layering Graphics
    Demo - Smart Art
    Lab - Inserting a SmartArt Graphic
    Lab - Modifying a SmartArt Graphic
    Grouping
    Lab - Grouping Objects
    Demo - Clipart
    Lesson 6 Review

    Lesson 7 - Calculating Data with Advanced Formulas
    Calculating Data with Advanced Formulas Range Names
    Demo - Create Name
    Lab - Naming a Range
    Lab - Renaming a Range
    Lab - Using Named Regions in Formula Calculations
    Lab - Adding Columns to a Worksheet Containing Page Names
    Three-Dimensional Cell References
    Demo - Calculate Data Across
    Lab - Comparing a 360-Day vs. 365-Day Date Calculation System
    Date and Time Function
    Demo - Dates
    Financial Function
    Demo - Convert Text To Columns
    Lab - Using Formulas to convert text data to individual columns
    Demo - Statistical Function
    Demo - Upper and Lower
    Lab - Using the UPPER, LOWER, and PROPER Text Functions
    Lookup and Reference Function
    Demo - Hlookup
    Lab - Looking up Part Numbers with the HLOOKUP Function
    Lab - Looking up Part Numbers with the VLOOKUP Function
    Logical Function
    Demo - If Statement
    Lab - Performing Conditional Calculations with SUMIFS, COUNTIFS, and AVGIFS Functions
    Lab - Performing Conditional Calculations with SUMIF, COUNTIF, and AVERAGIF Functions
    Lab - Calculating Sales Honors with IF Function and the AND Function
    Lab - Calculating Sales Honors with IF Function and the OR Function
    Lab - Eliminating Calculation Errors with the IFERROR Function
    Demo - View and Print Formulas
    Lab - Printing a Worksheet with the Formulas Displayed
    Lesson 7 Review

    Lesson 8 - Sorting and Filtering Data Sorting and Filtering Data Single-Level Sort in Ascending Order
    Multiple-Level Sort in Both Ascending and Descending Order
    Demo - Sort Data
    Lab - Sorting Data
    Filter
    Lab - Filtering Data
    Lab - Calculating Sums, Counts, and Averages on Filtered Data
    Database Function
    Subtotals
    Demo - Subtotals
    Lab - Applying Subtotals to a Sorted List
    Lesson 8 Review
    Course Closure

    MS Excel 2007 Level Three

    Lesson 1 - Steamlining Workflow
    Steamlining Workflow
    Macro
    Record Macro Procedure Reference
    Demo - Macros
    Editing Macros
    Macro Settings
    Demo - Edit Macros
    Conditional Formatting
    Conditional Formats
    Conditional Formatting Procedure Reference
    Demo - Conditional Formats
    Data Validation
    Data Validation Procedure Reference br /> Workbook Properties
    Demo - Data Validation
    Lesson 1 Review

    Lesson 2 - Collaborating with Others
    Collaborating with Others
    The Collaboration Process
    File Protection
    The Changes Group
    The Protect Workbook Options
    Demo - Protection
    Sharing Workbooks
    Shared Workbooks
    Sharing Workbooks Procedure Reference
    Demo - Share Workbook
    Revision Tracking
    Revision Tracking Procedure Reference
    The Highlight Changes Dialog Box
    The Accept/Reject Changes Option
    Demo - Changes
    Merge Workbooks
    Demo - Merge Workbooks
    Digital Certificates
    Digital Signatures
    Demo - Digital Signature
    Demo - Mark As Final
    Lesson 2 Review
    Lesson 3 - Auditing Worksheets
    Auditing Worksheets
    Tracer Arrows
    Cell Precedents
    Cell Dependents
    Demo - Tracing
    Invalid Data
    Error Checking
    Demo - Invalid Formulas
    The Watch Window
    Demo - Watch and Evaluate
    Formula Evaluation
    Outline
    Demo - Group and Subtotals
    Lesson 3 Review
    Lesson 4 - Analyzing Data
    Analyzing Data
    Trendlines
    Trendline Procedure Reference
    Demo - Trendline
    Scenarios
    The Scenario Manager Dialog Box
    Demo - Scenario
    The Solver Parameters Dialog Box
    Demo - Solver
    Analysis ToolPak
    Demo - Data Analysis
    Lesson 4 Review
    Lesson 5 - Working with Multiple Workbooks
    Working with Multiple Workbooks
    Workspaces
    Demo - Workspace
    Data Consolidation
    The Consolidate Dialog Box
    Link Cells
    Demo - Consolidate Data
    Demo - Edit Links
    Lesson 5 Review
    Lesson 6 - Importing and Exporting Data
    Importing and Exporting Data
    File Export
    Demo - Export to Word
    File Import
    The Get External Data Group
    Demo - Import Delimited Text File
    Delimited Text Files
    Lesson 6 Review
    Lesson 7 - Using Excel with the Web
    Using Excel with the Web
    File Publish
    The Publish As Web Page Dialog Box
    Demo - Publish Data
    Import Data From Web
    Demo - Import Data from Web
    The New Web Query Dialog Box
    Lesson 7 Review
    Lesson 8 - Structuring Workbooks with XML
    Structuring Workbooks with XML
    XML
    XML Uses
    XML Components
    XML Schema
    XML Schemas
    XML Map
    XML Maps
    The XML Source Task Pane
    The XML Group
    Demo - XML Map
    Demo - XML Data
    Lesson 8 Review
    Course Closure


    MS Access 2007 Level One

    Lesson 1 - Exploring the Access Environment
    Exploring the Access Environment
    Database
    Database Terminology
    Relational Databases
    Getting Started With Microsoft Office Access Window
    The Microsoft Office Button
    The Ribbon
    ScreenTips
    The Quick Access Toolbar
    The Navigation Pane
    The Tabbed Document Window Viewing Feature
    The Microsoft Office Window Frame
    The Home Tab
    The Create Tab
    The External Data Tab
    The Database Tools Tab
    Contextual Tabs
    Dialog Box Launchers
    Galleries
    The Access Options Dialog Box
    Customize Options
    Access Help 2007
    Access Help Toolbar Options
    Table
    Query
    Recordset
    Form
    Report
    Demo - Navigation
    Demo - Customize Access
    Demo - Help
    Lesson 1 Review

    Lesson 2 - Designing a Database
    Designing a Database
    The Relational Database Design Process
    Statement of Purpose-Example
    Statement of Purpose-Non-Example
    Existing Data-Paper Format
    Existing Data-Electronic Format
    How to determine Additional Fields
    Field and Table Names
    How to Group Fields into Tables
    Normalization
    Denormalization
    Primary Keys-Example
    Primary Keys-Non-Example
    Composite Keys
    Foreign Keys
    Table Relationships
    One-to-One Relationship
    One-to-Many Relationship
    Lesson 2 Review

    Lesson 3 - Building a Database
    Building a Database
    Access Database Templates
    Table Views
    The Field Insertion Feature
    Field Templates Task Pane
    Data Types
    Rich Text Memo Field
    Auto Calendar
    Multi-valued Fields
    File Types
    Table Properties
    Table Design Options
    Referential Integrity
    The Relationships Window
    The Edit Relationships Dialog Box
    Relationship Report
    Demo - Create Database
    Demo - Create Table
    Demo - Manage Table and Relationship
    Lesson 3 Review

    Lesson 4 - Managing Data in a Table
    Managing Data in a Table
    The Search and Replace Commands
    The Totals Feature
    Records Sorting
    Subdatasheet
    Subdatasheets
    Demo - Managing Data
    Demo - Sorting
    Lesson 4 Review

    Lesson 5 - Querying a Database
    Querying a Database
    Filter Data
    Simple Queries - The Query Wizard
    The Query Wizard
    The Query Design Feature
    Query Criteria
    Comparison Operators
    Conditional Operators
    Arithmetic Operators
    Expressions
    The Expression Builder
    The Zoom Dialog Box
    The Property Sheet Pane
    Demo -filter
    Demo - Create Query
    Demo - Calculations
    Lesson 5 Review

    Lesson 6 - Designing Forms
    Designing Forms
    Form Sections
    The Record Navigation Bar
    The Form Wizard
    Controls
    Demo - Use Form
    Demo - Create a Form
    Demo - Modify Forms
    Lesson 6 Review

    Lesson 7 - Generating Reports
    Generating Reports
    Report Sections
    The Report Wizard
    Summary Options
    Control Properties
    AutoFormat
    Page Setup Options
    Print Preview
    Proofing Options
    Demo - Create Reports
    Demo - Modify Reports and Math
    Lesson 7 Review
    Course Closure

    MS Access Level Two

    Lesson 1 - Controlling Data Entry
    Controlling Data Entry
    Field Properties
    Input Masks
    Input Mask Wizard
    Lookup List Fields
    Lookup Wizard
    Demo - Field Properties
    Demo - Input Mask
    Demo - Lookup Fields
    Lesson 1 Review

    Lesson 2 - Joining Tables
    Joining Tables
    Query Joins
    Inner Join
    Left Outer Join
    Right Outer Join
    The Join Properties Dialog Box
    Self Joins
    The Alias Property
    Demo - Inner and Outer join
    Demo - Join
    Lesson 2 Review

    Lesson 3 - Creating Flexible Queries
    Creating Flexible Queries
    Select Query Properties
    Parameter Queries
    The Like Operator and Wildcards
    Common Wildcards
    Other wildcards
    Append Query
    Action Queries
    Update Query
    Delete Query
    Make Table Query
    Demo - Query Properties
    Demo - Parameter Queries
    Demo - Action Query
    Lesson 3 Review

    Lesson 4 - Improving Forms
    Improving Forms
    Design Tools
    Layouts
    Types of Layouts
    Control Padding - Narrow, Medium or Wide
    Sort Data Within Forms
    Anchor & Form Controls
    Control Grouping and Ungrouping
    Conditional Formatting
    Control Wizards
    Combo Box Control
    List Box Control
    Option Group Control
    Command Buttons
    Subforms
    Demo - Modify Form
    Demo - Sorting and Filtering
    Demo - Format Form
    Demo - Option Buttons
    Demo - Subforms
    Lesson 4 Review

    Lesson 5 - Customizing Reports
    Customizing Reports
    Report Design
    The Group, Sort and Total Pane
    The Totals Feature
    The Field List Pane
    The Rich Text Support Feature
    Report Pagination
    Summarize Report Information
    Subreports
    Demo - Create a Report
    Demo - Group Sort
    Demo - Format Report
    Demo - Pagination
    Demo - Subreports
    Lesson 5 Review

    Lesson 6 - Sharing Data Across Applications
    Sharing Data Across Applications
    Options for Importing Data
    Delimiters
    Exporting Data
    Mail Merge Task Pane
    Demo - Import Excel
    Demo - Import Export CSV File
    Lesson 6 Review
    Course Closure

    MS Access Level Three

    Lesson 1 - Structure Existing Data
    Structure Existing Data
    First Normal Form
    Demo - Table Analyzer
    Second Normal Form
    Functional Dependency
    Third Normal Form
    Transitive Dependency
    Many-to-Many Relationships
    Junction Tables
    Demo - Junction Table
    Demo - Modify Tables
    Lesson 1 Review

    Lesson 2 - Writing Advanced Queries
    Writing Advanced Queries
    Subqueries
    Subqueries: Process
    Demo - Subquery
    SQL
    Steps: Create a Subquery in SQL view
    Unmatched Queries
    Steps: Unmatched Queries
    Find Duplicates Queries
    Steps: Duplicate Query
    Demo - Unmatched and Find Duplicates
    Summarize Records using Criteria
    Demo - Summarizing Records
    Crosstab Query
    Demo - Crosstab
    PivotTable and PivotChart
    PivotChart
    Demo - PivotChart
    Lesson 2 Review

    Lesson 3 - Simplifying Tasks with Macros
    Simplifying Tasks with Macros
    Macro
    Macros
    Demo - Macro Form
    The Macro Builder Window
    Macro Actions
    Action Arguments
    Demo - Command Buttons and Expressions
    Object Events
    Macro Conditions
    Steps: Restrict Records Using a Condition
    Plan a Macro
    Embedded Macros
    Demo - Mandatory Data Entry and Message Box
    Demo - Automate Data Entry
    Lesson 3 Review

    Lesson 4 - Making Effective Use of Forms
    Making Effective Use of Forms
    Active X Controls
    Form Format Properties
    Demo - Calendar Form
    Tab Control
    Demo - Tab Control
    Demo - Pivot
    Lesson 4 Review

    Lesson 5 - Making Reports More Effective
    Making Reports More Effective
    Chart
    Chart Types
    Demo - Chart in Report
    Demo - Column Report
    Demo - Cancel Printing
    Report Snapshot
    Demo - Snapshot
    Lesson 5 Review

    Lesson 6 - Maintaining an Access Database
    Maintaining an Access Database
    Links to External Data Sources
    Linked Table Manager
    Demo - Link Tables
    Managing a Database
    Object Dependencies Task Pane
    Demo - Compact and Repair Object Dependencies
    Database Documenter
    Performance Analyzer
    Demo - Performance
    Lesson 6 Review
    Course Closure



    MS PowerPoint 2007 Level One

    Lesson 1 - Exploring the PowerPoint Environment
    Exploring the PowerPoint Environment
    Presentations
    PowerPoint Presentations
    The Microsoft Office Button
    Demo - Exploring the Interface
    The Quick Access Toolbar
    Demo - The Quick Access Toolbar
    The Microsoft Office Window Frame
    The Ribbon
    The Home Tab
    The Insert Tab
    The Design Tab
    The Animations Tab
    The Slide Show Tab
    The Review Tab
    The View Tab
    The Dialog Box Launchers
    Contextual Tabs
    PowerPoint Help Feature
    PowerPoint Help Toolbar Options
    Demo - Using Help
    The PowerPoint Options Dialog Box
    Lesson 1 Review

    Lesson 2 - Creating a Presentation
    Creating a Presentation
    Presentation Guidelines
    Saving Presentations
    Demo - Saving a Presentation
    Templates
    Demo - Creating a Presentation Using a Template
    Demo - Creating a Presentation from a Word Outline
    Compatibility Checker
    Slide Layouts
    Galleries
    Themes
    Components of Themes
    Demo - Themes
    Live Preview
    Background Styles
    Text Placeholders
    Demo - Add Text
    The Paste Special Command
    Demo - Edit Text
    The Slides Tab
    Demo - Views
    Lesson 2 Review

    Lesson 3 - Formatting Text on Slides
    Formatting Text on Slides
    Character Formats
    Demo - Applying Character Formats
    Demo - Paragraph Formats
    The Mini Toolbar
    Format Painter
    Replace Font Dialog Box
    Text Styles
    Demo - Format Text Placeholders
    Bulleted List
    Numbered List
    Indent Markers
    Typography Effects
    Lesson 3 Review

    Lesson 4 - Adding Graphical Objects to a Presentation
    Adding Graphical Objects to a Presentation
    Clip Art
    Demo - Insert Clip Art
    Shapes
    Demo - Shapes
    Drawing Tools
    WordArt
    Demo - Insert Word Art
    Lesson 4 Review

    Lesson 5 - Modifying Objects
    Modifying Objects
    Object Selection
    Object Scaling
    Demo - Modify Objects
    Picture Tools
    Image Compression
    Orientation
    Demo - Orientation of Objects
    The Set Transparent Color Option
    Grouping and Ungrouping Objects
    Order of Objects
    Guides and Gridlines
    Demo - Layering Objects
    Lesson 5 Review

    Lesson 6 - Adding Tables to a Presentation
    Adding Tables to a Presentation
    Tables
    Table Creation
    Demo - Insert a Table
    Demo - Insert a Table from Word
    Table Tools
    Table Fill Options
    Table Styles
    Lesson 6 Review

    Lesson 7 - Inserting Charts in a Presentation
    Inserting Charts in a Presentation
    Charts
    Demo - Insert a Chart
    Chart Data
    The Chart Window
    Chart Tools
    Chart Types
    Chart Layouts
    Chart Styles
    Demo - Modify a Chart
    Demo - Paste a Chart from Excel
    Leson 7 Review

    Lesson 8 - Preparing to Deliver a Presentation
    Preparing to Deliver a Presentation
    AutoCorrect
    The Spell Checker
    Demo - Spell Check
    Transitions
    Demo - Add Transitions
    Animation Effects
    Demo - Add Animations
    Speaker Notes
    Handouts
    Outlines
    The Page Setup Dialog Box
    The Package For CD Option
    Demo - Preparing for a Presentation
    Lesson 8 Review
    Course Closure

    MS PowerPoint 2007 Level Two

    Lesson 1 - Customizing the PowerPoint Environment
    Customizing the PowerPoint Environment
    Default Color Scheme
    Color Scheme Applied
    The PowerPoint Options Dialog Box
    Demo - Customize the Powerpoint Interface
    Lesson 1 Review

    Lesson 2 - Customizing a Design Template
    Customizing a Design Template
    Custom Template
    Demo - Adding a Background Graphic to a Slide Master
    Slide Master
    Demo - Slide Master
    The Reuse Slides Pane
    Slide Masters
    Custom Themes
    Demo - Custom Layouts
    Custom Bullets
    The Bullets And Numbering Dialog Box
    Demo - Customize Bullets
    Common Slide Information
    The Header And Footer Dialog Box
    The Notes Master
    The Handout Master
    Demo - Master Notes and Handouts
    Lesson 2 Review

    Lesson 3 - Adding Diagrams to a Presentation
    Adding Diagrams to a Presentation
    SmartArt Graphics
    Demo - Add Diagrams
    The Choose A SmartArt Graphic Dialog Box
    SmartArt Tools
    Demo - Modify Diagrams
    Lesson 3 Review

    Lesson 4 - Adding Special Effects to Presentations
    Adding Special Effects to Presentations
    The Movie Options Group
    Demo - Movies and Sound
    The Clip Art Task Pane
    Custom Animation Task Pane
    The Entrance Custom Animation Effect
    The Emphasis Custom Animation Effect
    The Motion Paths Custom Animation Effect
    The Exit Custom Animation Effect
    Ordering
    Demo - Applying Effects to Text
    Demo - Custom Animation
    Lesson 4 Review

    Lesson 5 - Customizing a Slide Show Presentation
    Customizing a Slide Show Presentation
    Custom Slide Shows
    Slide Show Options
    The Custom Show Dialog Box
    Demo - Custom Slide Show
    Hyperlinks
    Demo - Hyperlinks
    The Action Settings Dialog Box
    Action Buttons
    Demo - Hyperlinks and Action Buttons
    Annotation
    Demo - Annotate a Slide
    Recording Quality
    Record Narration
    The Rehearse Timings Feature
    Information Kiosks
    Lesson 5 Review

    Lesson 6 - Collaborating on a Presentation
    Collaborating on a Presentation
    Some Definitions..
    The Publish Slides Dialog Box
    Information Rights Management
    Rights-Protected Presentation
    Demo - Limit Editing of Slide Content
    Lesson 6 Review

    Lesson 7 - Finalizing a Presentation
    Finalizing a Presentation
    Review Tab: Comments
    Review Tab: Research Task Pane
    Review Tab: Thesaurus
    Password-Protected Presentation
    Standard File Properties
    Advanced File Properties
    Digital Signatures
    Get A Digital ID Dialog Box
    The Document Inspector Dialog Box
    The Mark As Final Feature
    The Publish As Web Page Dialog Box
    Demo - Finalizing a Presentation
    Demo - Publish a Presentation as a Web Page
    Lesson 7 Review
    Course Closure



    MS Outlook 2007 Level One

    Lesson 1 - Getting Started with Outlook
    Microsoft Office Outlook 2007
    The Microsoft Office Outlook 2007 Window
    Item
    Folder
    The To-Do Bar
    Demo - Exploring the Interface
    Email Address
    The New Message Window
    Demo - Sending a Message
    Demo - Resend and Reply
    The Microsoft Office Button
    The Quick Access Toolbar
    The Ribbon
    The AutoPreview Feature
    The Infobar
    Print Dialog Box
    The Auto Empty Feature
    Demo - Print and Delete
    Lesson 1 Review

    Lesson 2 - Composing Messages
    Address Book
    Global Address List
    The Mini Toolbar
    Dialog Box Launcher
    Gallery
    AutoCorrect
    Demo - New Message Formatting and Spellcheck
    Attachment
    Demo - Attachments
    Forward
    Demo - Forwarding
    Lesson 2 Review

    Lesson 3 - Organizing Messages
    Organizing Messages
    Attachment Preview
    Message Flagging
    Demo - Attachment Flags
    Demo - Attachments - Pictures
    Demo -Word Attachment Preview
    Demo - Folders
    Lesson 3 Review

    Lesson 4 - Managing Contacts
    Managing Contacts
    Contact
    Demo - Adding a Contact
    The Contact Form
    Electronic Business Card
    The Outlook Address Book
    Contact Views
    Demo - Contact Views and Sending Contacts
    Color Category
    Sort Order
    The Map Button
    Demo - Adding a Contact from a Message Header
    Lesson 4 Review

    Lesson 5 - Scheduling Appointments
    Scheduling Appointments
    Outlook Calendar
    The Appointment Form
    Private Appointment
    Demo - Add, Modify, and Categorize Appointments
    Demo - Reoccurring Appointments
    Lesson 5 Review

    Lesson 6 - Scheduling Meetings
    Scheduling Meetings
    The Meeting Scheduling Process
    Meeting Form
    Meeting Resources
    Group Schedule
    Responses
    Demo - Inviting Attendees
    Lesson 6 Review

    Lesson 7 - Managing Simple Tasks
    Managing Simple Tasks
    Task
    The Task Form
    Demo - New Tasks
    Demo - Updating Tasks
    Lesson 7 Review

    Lesson 8 - Using Notes
    Using Notes
    Notes
    Demo - Notes
    Lesson 8 Review
    Course Closure

     

    MS Outlook 2007 Level Two

    Lesson 1 - Setting Calendar Options
    Setting Calendar Options
    Tools - Options
    Calendar Options
    Demo - Calendar Options
    Time Zones
    The Free/Busy Options Dialog Box
    Lesson 1 Review

    Lesson 2 - Setting Message Options
    Setting Message Options
    Demo - Message Options
    Demo - Message Options Read Receipt
    Message Settings
    Voting and Tracking Options
    Delivery Options
    Message Formats
    Demo - Message Formats
    Rules
    The Out Of Office Assistant Dialog Box
    Demo - The Out Of Office Assistant
    Distribution Lists
    Demo - Distribution Lists
    Hyperlinks
    Demo - Hyperlink
    Lesson 2 Review

    Lesson 3 - Tracking Work Activities Using the Journal
    Tracking Work Activities Using the Journal
    The Journal
    Demo - Journal
    The Journal (Cont.)
    Journal Views
    Journal Entry Form: Manual Entry
    Demo - Journal Add
    Lesson 3 Review

    Lesson 4 - Managing Tasks
    Managing Tasks
    Assign Task
    Demo - Assign Task
    Task Request Form
    Demo - Accept and Decline Tasks
    Status Report
    Lesson 4 Review

    Lesson 5 - Sharing Folder Information
    Sharing Folder Information
    Outlook Folders
    Additional Default Folders
    Permission Roles
    Demo - Mailbox Permissions
    Overlay Mode
    The Send A Calendar Via E-mail Dialog Box
    Delegate Access to Folders
    Lesson 5 Review

    Lesson 6 - Customizing the Outlook Environment
    Customizing the Outlook Environment
    Toolbar Options
    Demo - Custom Toolbar
    Customization
    Demo - Custom Menus and Quick Access
    Outlook Today Page
    Folder Home Page
    Lesson 6 Review

    Lesson 7 - Locating Outlook Items
    Locating Outlook Items
    Sort Criteria
    Demo - Sorting
    Instant Search
    Demo - Search
    The Query Builder Feature
    The Advanced Find Window
    The Filter Dialog Box
    The Ways To Organize Panel
    Demo - Organize
    Automatic Formatting
    Rules Wizard
    Rules Wizard - Predefined Templates
    Junk Email Filter
    Blocked Senders List
    Safe Senders List
    Lesson 7 Review

    Lesson 8 - Working with Public Folders
    Working with Public Folders
    Public Folders
    Demo - Public Folders
    Public Folder Permissions
    Sending Messages to Public Folder
    Lesson 8 Review
    Course Closure

    MS Outlook 2007 Level Three

    Lesson 1 - Personalizing Your Email
    Personalizing Your Email
    Stationary
    Themes
    How to Apply Themes and Stationary
    Demo - Themes
    Create Custom Theme
    Demo - Custom Themes
    Signatures
    How to Create Signatures
    Demo - Create Signature
    Demo - Business Card Create Signature
    Encryption
    Digital Signatures
    Demo - Digital Signature
    Email Message Security Settings
    Demo - Encrypt Digital Signature
    Lesson 1 Review

    Lesson 2 - Organizing Outlook Items
    Organizing Outlook Items
    Group Items
    Group Outlook Items
    Demo - Grouping
    Search Folders
    How to Create Search Folders
    Demo - Search Folders
    Conditional Formatting
    Lesson 2 Review

    Lesson 3 - Managing Outlook Data Files
    Managing Outlook Data Files
    Managing Outlook Data Files
    Store Outlook Items
    Outlook Data Files
    Data File
    Data File Settings
    Demo - Outlook Data File
    Lesson 3 Review

    Lesson 4 - Working with Contacts
    Working with Contacts
    Forwarding Contacts
    Demo - Forward Contact
    The Edit Business Card Dialog Box
    How to Edit Electronic Business Card
    Demo - Business Card
    Export Contact Information
    Export Contacts
    Demo - Export Contacts
    Fields
    Perform Mail Merge
    Mail Merge
    Demo - Mail Merge
    Merge Field Types
    Data Sources
    The Mail Merge Recipients Dialog Box
    The Filter And Sort Dialog Box
    Business Contact Manager
    Lesson 4 Review

    Lesson 5 - Saving and Archiving Email
    Saving and Archiving Email
    Saving Messages in Alternate Formats
    Demo - Save Alternate Formats
    Archive Items
    How to Archive
    Demo - Archive
    Protect Personal Folders
    Lesson 5 Review

    Lesson 6 - Creating a Custom Form
    Creating a Custom Form
    Adding Form Fields
    Saving Form As Template
    Testing a Form
    Demo - Message Form
    Demo - Form Templates
    Lesson 6 Review

    Lesson 7 - Working Offline and Remotely
    Working Offline and Remotely
    Offline Folder File
    Send/Receive Groups
    Create Send and Receive Groups
    Create Custom Send/Receive Group
    RPC Over HTTP
    How to Configure RPC Over HTTP
    Demo - Send Receive and Work Offline
    Lesson 7 Review
    Course Closure



     
     
    Print Image Printer friendly version   
    Top of page
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CONTACT US   SITEMAP  

    MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
    MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk


    red arrow Website design by Aimpro UK red arrow Terms