LearnKey Training

Excel 2000
Excel 2000


Excel 2000

3 Sessions –
9 Hours of Interactive Training
In LearnKey’s Excel 2000 course, expert Reed Jacobson, guides you through spreadsheet fundamentals and provides inside tips for powerful business applications. You’ll learn valuable features such as, formatting, summarizing, and charting methods, along with some little-known techniques that will help you get up to speed and working efficiently. At the conclusion of this course, you will be confident in your ability to create meaningful spreadsheets.

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:
    · Test Prep
    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
    · Uses for a Spreadsheet
    · Understanding the Excel Workspace
    · Selecting a Range of Cells

    Section B: Entering Values
    · Entering Text, Numbers & Dates
    · Formatting Dates & Editing Values
    · Sorting a List

    Section C: Managing Workbooks
    · Saving a Workbook
    · Opening & Closing Workbooks
    · Workbook Add, Delete, Rename & Move

    Section D: Creating a Form or Document
    · Creating a Form or Document
    · Changing Fonts, Color & Alignment
    · Formatting Dates
    · Resizing Columns & Rows
    · Creating Backgrounds & Borders
    · Inserting Columns
    · Merging Cells

    Section E: Summarizing Numbers
    · Using Auto Fill
    · Using Tab to Enter Values
    · Creating Totals Automatically
    · Understanding the SUM Function
    · Creating & Validating Formulas

    Section F: Formatting Numbers
    · Currency Style
    · Auto Formatting Regions & Moving Cells

    Section G: Creating Charts
    · Adding a Chart
    · Adding New Values to a Chart
    · Creating a Custom Chart
    · Using the Chart Toolbar & Menu
    · Chart Location

    Section H: Creating Charts
    · Print Preview & Page Setup Options
    · Preview Color in Black & White
    · Selecting Multiple Sheets
    · Printing

    Section I: Customizing Excel
    · Changing Workbook Options
    · Using Adaptive Menus & Toolbars
    · Context Sensitive Toolbars

    Section J: Discovering More
    · Screen Tips
    · Use Help in Dialogue Boxes
    · Using the Office Assistant
    · Help Context

    		Session 2

    Section A: Managing References
    · Relative References
    · Using Auditing Toolbar
    · Mixed & Absolute References
    · Saving Workbooks

    Section B: Named Ranges
    · Naming Cells
    · Naming Ranges
    · Applying Names

    Section C: Manipulating Ranges
    · Importing Files
    · Special Formatting Features
    · Find/Replace

    Section D: Basic Functions
    · Summarizing Functions
    · 3D Formulas
    · Logical Functions
    · Date Functions

    Section E: Look-up Functions
    · Types of Look-ups
    · Vertical Look-up
    · Applying Names to Vertical Look-up

    Section F: Financial Functions
    · Types of Financial Functions
    · Calculating Payments

    Section G: Considering Alternatives
    · Using Scenarios
    · Report Manager
    · Using Goal Seek
    · Using the Solver

    Section H: Enhanced Formatting
    · Formatting Numbers
    · Formatting Text
    · Applying Styles

    Section I: Dynamic Formatting
    · Applying Conditional Formats
    · Using Data Validation

    Section J: Graphical Objects
    · Using the Drawing Toolbar
    · Adding Comments
    · Inserting Pictures

    		Session 3

    Section A: Managing Workbooks
    · Introduction
    · Adding a File Password
    · Protecting a Workbook
    · Freezing Row & Column Headers
    · Changing Page Breaks
    · Printing Portions of a Worksheet
    · Setting Workbook Properties
    · Creating a Workspace

    Section B: Using Templates
    · Saving & Editing a Template
    · Changing the Default Template
    · Changing the Default Worksheet Template

    Section C: Sharing a Workbook
    · Sharing a Workbook
    · Editing a Shared Workbook
    · Tracking Changes to a Shared Workbook
    · Merging Workbooks

    Section D: Query a Database
    · Retrieving Data from a Database
    · Filtering the Data using Microsoft Query

    Section E: Working with Lists
    · Sorting Lists
    · Using a Form to View/Search a List
    · Using AutoFilter
    · Using the Advanced Filter
    · Adding Subtotals to a List
    · Tracing Errors

    Section F: Working with PivotTables
    · Creating a PivotTable
    · Formatting a PivotTable
    · Creating a PivotChart

    Section G: Excel & the Internet
    · Saving a Workbook as HTML
    · Saving HTML with Interactivity
    · Saving an Interactive PivotTable as HTML
    · Importing Values from a Web Site
    · Creating Hyperlinks in a Worksheet
    · Using the Office Clipboard
    · Round Tripping to HTML & Back Again

    Section H: Creating Macros
    · Creating & Running a Macro
    · Looking at a Macro's Code
    · Creating Another Macro
    · Editing the Macro
    · Creating a Button to Run a Macro

    Section I: Preparing for Certification
    · The Testing Method
    · Tips for the Exam