LearnKey Training

Excel 2003


Excel 2003

3 Sessions –
9 Hours of Interactive Training
Nearly every organization today, regardless of size, uses spreadsheets to analyze data and do “what if” projections of future scenarios. Whether you’re a spreadsheet novice or have some experience, the Excel 2003 course from LearnKey can help you quickly get up to speed. Expert instructor Erin Olsen uses practical examples to show you Excel fundamentals before moving step-by-step into more advanced topics like graphs, charts, formulas and macros. At the conclusion of this course, you’ll feel confident in your ability to use Excel 2003 for powerful business applications.

Benefits
  • Gain valuable skills using the professional standard for spreadsheet programs.
  • Produce powerful business charts and graphs with advanced Excel capabilities.
  • Enhance personal productivity and technical credibility.
    • Includes:
    · eSupport
    About The Author
    Since founding PCKeys Technology Solutions in 1995, Erin Olsen has personally trained more than 10,000 people worldwide in a wide variety of applications and technologies, and she has helped many organizations transition to using Microsoft, Adobe and Macromedia software tools. A Microsoft Office Specialist Master Instructor, Erin enjoys a reputation for providing solid foundations in skills applicable to real-world needs in an easy-to-understand and fun manner. She combines technical knowledge with real-world experience allowing her to provide a wealth of practical examples and inside tips to help her audience learn, retain and actually apply their skills.
    Session 1

    Section A: Introduction
    · Exploring Excel
    · Exploring Excel
    · Data Types
    · Navigating
    · Selecting Data
    · Noncontiguous Selection

    Section B: Workbook Basics
    · Entering Data
    · Dates
    · Numbers
    · Fill Handles
    · Fill Options
    · Save

    Section C: Editing Worksheets
    · Replace/Edit Data
    · Cut, Copy & Paste
    · Drag & Drop
    · Delete Data
    · Rows & Columns
    · Change Width & Height
    · AutoFit
    · Data Validation

    Section D: Formatting Data
    · Format Toolbar
    · Font Format
    · Merge & Center
    · Format Cells
    · Indent
    · Borders & Shading
    · Layout Options
    · Add Graphics

    Section E: Advanced Formatting
    · Number Formats
    · Decimals
    · Special Features
    · Dates
    · Custom Formats
    · Create Custom Format
    · Conditional Format
    · AutoFormat

    Section F: Reusable Formats
    · Using Templates
    · Creating Styles
    · Modifying Styles
    · Creating Template
    · Use/Save Worksheet

    		Session 2

    Section A: Basic Formulas
    · Formula Syntax
    · Create Formula
    · Create & Edit Formulas
    · Relative Reference
    · Absolute Reference
    · Complex Formulas
    · Formula Rules

    Section B: Formula Auditing
    · Tracing
    · Evaluate Formula
    · Circle Invalid Data
    · Watch Window

    Section C: Basic Functions
    · Function Syntax
    · Common Functions
    · Building Functions
    · Paste Function Box
    · Paste Function Button
    · AutoCalculate
    · Date & Time Functions
    · Logical Functions

    Section D: Working with Names
    · Create Names
    · Range Names
    · 3-D Names
    · Use Names
    · Range Functions
    · Paste References
    · Edit Range

    Section E: Organization
    · Worksheets
    · Copy Worksheets
    · Consolidate Data
    · Tab Naming

    Section F: Charts
    · Chart Wizard
    · Define Data
    · Layout Options
    · Position Options
    · Charting Toolbar
    · Format Options
    · 3-D Charts
    · Modify Data

    Section G: Save & Print
    · Save Options
    · Save As Web Page
    · View Saved Files
    · Print Setup
    · Page Setup Options
    · Print Area

    		Session 3

    Section A: Protecting Data
    · Worksheet View
    · Cell Protection
    · Allow Range Editing
    · Protect Sheet
    · Protect Workbook

    Section B: Sharing Workbook
    · Set Up for Sharing
    · Comments
    · Email for Review
    · View Changes
    · Track Changes
    · Compare Side by Side

    Section C: Database
    · Defining Databases
    · Database Components
    · Using Forms
    · Filtering with Forms

    Section D: Sorting Database
    · Freeze Panes
    · Sort Buttons
    · Sort Columns
    · Sort Order

    Section E: Database Function
    · DFunction Syntax
    · Modify Function
    · And vs. Or
    · Record Count
    · VLookup

    Section F: Filtering
    · AutoFilter
    · Multiple Filters
    · Custom Filters
    · Advanced Filters
    · Copy to Location

    Section G: Subtotals
    · Working with Subtotals
    · Count Subtotal
    · Average Subtotal
    · Grouping
    · Linking Workbooks