LearnKey Training

Excel 2002
Excel 2002


Excel 2002

3 Sessions –
9 Hours of Interactive Training
With the Excel 2002 training course from LearnKey, you can learn both spreadsheet basics and advanced features of Excel. LearnKey expert Reed Jacobson’s energetic instruction begins with fundamentals like charts and graphs, moves step-by-step through intermediate topics such as building formulas, and concludes with expert level features including database links and macros. At the conclusion of this course, you’ll feel confident using Excel 2002 and understand how to use it to maximize productivity. This course covers all the objectives for the Microsoft Office Specialist exams.

Benefits
  • Gain valuable skills and improve personal productivity.
  • Acquire knowledge that will add credibility for future career opportunities.
  • Increase marketability by using the latest information technology.
    • Also Available:
    · Study Guide
    About The Author
    As an author and independent consultant specializing in creative training, consulting, and custom development services, Reed Jacobson is one of the top experts in the country on Microsoft products. Reed is the author of the best selling Microsoft Press book Excel Visual Basics Step by Step, which has been published in over 20 languages worldwide. He has been a featured presenter at Microsoft conferences in Orlando, New Orleans, Buenos Aires, and Kuala Lampur. Before becoming an author and consultant, Reed worked for ten years as a programmer for Hewlett-Packard. His years of training experience and programming background bring a profound insight to his training sessions.
    Session 1

    Section A: Introduction & Simple Lists
    · Introduction
    · Cell Reference
    · Creating Lists
    · Simple Formatting
    · AutoFill Values
    · Format Painter

    Section B: Workbooks & Worksheets
    · Save a Workbook
    · File Properties
    · Rename & Delete Worksheets
    · Move & Copy Worksheet
    · Printing a Workbook

    Section C: Manipulating Values
    · Editing Values
    · Insert, Delete & Move Cells
    · Copy Cells
    · Comments
    · AutoFilter
    · Find & Replace

    Section D: Charts
    · Create a Chart
    · Chart Options
    · Manipulate Values
    · Chart Type
    · Secondary Axis
    · Add Values

    Section E: Summarizing Values
    · New Worksheet
    · Add Values
    · AutoSum
    · AutoFormat
    · Modifying Format Styles

    Section F: Formatting & Graphics
    · Create a Grid
    · Create a Border
    · WordArt
    · Add Text
    · Merge & Center
    · Insert Clip Art
    · Drawing Object
    · Rotated Text
    · Print Preview

    Section G: Using Help
    · Tool Tips
    · Office Assistant
    · Ask a Question Box
    · Context Sensitive Help
    · Comprehensive Help

    		Session 2

    Section A: Financial Functions
    · Loan Calculation
    · Insert Function
    · Name Ranges
    · Amortization Table
    · Future Value
    · Date Functions
    · Dynamic Dates

    Section B: What-If Analysis
    · Goal Seek Command
    · Create Scenarios
    · View Scenarios
    · Single-input Data Table
    · Two-input Data Table

    Section C: Relative & Absolute References
    · Expense Allocation
    · Formula Auditing
    · Trace Precedents
    · Finding Errors
    · References
    · Evaluate Formulas

    Section D: Protection
    · Protect Worksheet
    · Unlock Cells
    · Protection Options
    · Protect Workbook
    · Control Input

    Section E: Lookups
    · Named Range
    · Exact Lookup
    · Bonus Amount
    · Range Lookup
    · Moving Ranges
    · External References
    · Update & Repair Links
    · Hyperlinks

    Section F: Advanced Formatting
    · Custom Number Formats
    · Conditional Formatting

    Section G: Consolidating Values
    · Budget Template
    · Save As Template
    · Enter Values
    · Consolidate: Sum
    · Consolidate: Link
    · Create Workspace
    · 3D Formulas

    Section H: Sharing Workbooks
    · Share a Workbook
    · Track Changes
    · Merge Workbooks

    		Session 3

    Section A: Creating Sample Data
    · Sample Database
    · Replicate Ranges
    · Sort Command
    · Random Numbers

    Section B: Exporting & Importing Data
    · Export to Text
    · Export to Database
    · Import from Database
    · Import from Text
    · Import Text Wizard

    Section C: Advanced Filters
    · Custom AutoFilter
    · Advanced Filter
    · Extract a List

    Section D: Subtotals & Outlines
    · Subtotal
    · Outline
    · Nesting Subtotals
    · Manual Grouping

    Section E: Summarizing with a PivotTable
    · Create a PivotTable
    · PivotTable Field List
    · Manipulate a PivotTable
    · Format
    · Group Data
    · Create a PivotChart
    · Manipulate a PivotChart
    · AutoFormat

    Section F: Publishing Workbooks
    · Preview Large Document
    · Freeze Headings
    · Header
    · Footer
    · Preview a Chart
    · Print a Chart
    · Static HTML Page
    · PivotTable Interactivity
    · Spreadsheet Interactivity
    · Web Queries

    Section G: Creating Macros
    · Record Macros
    · Play Macros
    · Visual Basic
    · Edit a Macro
    · Toggle Macro

    Section H: Adding User Interface
    · Custom Toolbar
    · Menu Command
    · Security Level
    · Workbook Button