Excel XP, 2000, 97 Training at The Learning Center

Currently Not Logged In (Click here to login to E-Learning)

The Learning Center of Las Vegas, Nevada offers Computer Professional and Certification training and testing for Microsoft, MCSE, MCAD, MCDBA, MCSD, .Net, CISCO, A+, Network+, and many applications including Microsoft Office.


Serving Your Training Needs Since 1985
Click on the links for the course you need information for: *Excel XP Beginning* *Excel XP Intermediate* *Excel XP Advanced* *Excel XP Expert* Microsoft Excel Module *Excel 2000 Beginning* *Excel 2000 Intermediate* *Excel 2000 Advanced* *Excel 2000 Macros* *Excel 2000 Upgrade* Excel 97 Beginning Excel 97 Intermediate Excel 97 Advanced If a link doesn’t contain the information you require now, please check back soon or call 702-320-8885 for more details.

Excel XP Beginning

Length of Course:	1 day
Prerequisites:	Windows 95/98/NT Beginning
Course Objective:	This course teaches students how to create a new workbook, add numbers and text, format numbers and text, work with the options for columns and rows, customize the cells, set up printing options, preview and print your document.

Course Outline:

Exploring Excel

Starting Excel

Working With Excel Windows and Worksheets

Using Menu Commands

Displaying and Hiding Toolbars

Displaying Hidden Toolbar Buttons

Moving and Resizing Toolbars

Changing Menu and Toolbar Options

Using the Task Pane

Office Assistant and Help

Displaying or Hiding the Office Assistant

Using the Office Assistant

Finding an Answer

Using Ask a Question

Using Basic Workbook Skills

Selecting a Cell Using the Keyboard

Scrolling Using the Mouse

Using the Go To dialog box

Entering Text and Numbers into Cells

Saving a New Workbook

Closing a Workbook

Creating a New Workbook

Using a Template

Opening an Existing Workbook

Using Data Entry Shortcuts

Editing Cell Entries

Checking Worksheet Spelling

Creating a New Folder

Renaming an Existing Workbook

Working With Ranges

Working With Ranges

Selecting Ranges With the Keyboard and the Mouse

Selecting Non-adjacent Ranges

Entering Values Into a Range

Using the Auto Fill Feature

Creating Simple Formulas

Using and Entering Formulas

Using Functions

Using the AutoSum Button and List

Entering and Editing Basic Functions

Inserting Functions in Formulas

Using the AutoCalculate Feature

Using Range Borders to Modify Formulas

Checking Errors

Working With Columns and Rows

Selecting Columns and Rows

Changing the Width of Columns and the Height of Rows

Adjusting Columns Automatically

Hiding and Unhiding Columns and Rows

Inserting or Deleting a Column

Inserting or Deleting a Row

Copying and Moving Data

Copying or Cutting and Pasting Data

Using the Paste List and the Paste Options Button

Using the Clipboard Task Pane

Creating an Absolute Preference

Filling Cells

Using Drag-and-Drop Editing

Using Redo and Undo

Formatting Numbers

Using Number Formats

Using the Currency or the Percent Style

Using the Comma Style

Changing Decimal Places

Formatting Text

Formatting Cell Text

Changing an Existing Font

Modifying the Font Size

Using Bold and Italics and Underlining Text

Changing the Font Color

Rotating and Wrapping Text in a Cell

Shrinking Text in a Cell

Changing Cell Alignment and Text Indentation

Formatting Cells

Using the Merge and Center Button

Changing the Vertical Alignment

Splitting Cells

Using the Borders Button

Drawing Cell Borders

Using the Fill Color Button

Pasting Formats

Using the Format Painter Button

Copying Formats to Non-Adjacent Cells

Clearing Formats

Inserting Selected Cells or Cut or Copied Cells

Deleting Selected Cells

Using Page Setup

Setting Margin and Centering Options

Changing the Page Orientation

Creating and Customizing Headers and Footers

Changing Print Gridlines

Repeating Row and Column Labels

Scaling a Worksheet

Using Page Break Review

Setting or Removing a Print Area

Printing

Previewing a Worksheet

Printing the Current Worksheet

Printing Multiple Copies or a Selected Range

Printing a Page Range

Return to the Top of the Page

Excel XP Intermediate

Length of Course:	1 day
Prerequisites:	See Excel 2000 Intermediate Course Outline
Course Objective:	See Excel 2000 Intermediate Course Outline

Course Outline:

Using Automatic Format and Styles

Using Automatic Formatting Features

Applying an AutoFormat and Changing its Options

Extending List Formats and Formulas

Creating a Style by Example

Applying a Style and Creating a New Style

Editing an Existing Style

Merging Styles

Using Large Worksheets

Increasing or Decreasing the magnification

Changing the Magnification of a Range

Switching to a Full Screen View

Splitting the Window

Removing the Split Window

Freezing and Unfreezing the Panes

Working With Multiple Worksheets

Using Multiple Worksheets and Navigating Between Each

Selecting or Renaming Worksheets

Selecting Multiple Worksheets

Coloring Worksheet Tabs

Inserting or Deleting Worksheets

Printing Selected Worksheets

Managing Worksheets

Copying or Moving Worksheets

Using Grouped Worksheets

Moving or Copying Data Between Worksheets

Creating 3-D Formulas

Using 3-D Ranges in Functions

Using Multiple Workbooks

Opening Multiple Workbook Windows

Cascading Open Workbook Windows

Activating Cascaded Workbook Windows

Tiling Open Workbook Windows

Activating Tiled Workbook Windows

Copying Data Between Workbooks

Saving or Opening a Workspace

Closing All Open Workbooks

Linking Workbooks and Opening Linked Workbooks

Using Templates

Working With Templates

Saving a Template as a Workbook

Using or Editing a Template

Inserting a New Worksheet

Deleting a Template

Creating Default Templates

Creating Charts

Using Charts

Creating Charts with the Chart Wizard

Moving and Resizing Charts

Identifying Chart Objects

Changing the Chart Type and Sub-Type

Changing the Plot Direction

Removing or Adding a Legend

Moving the Legend

Changing Non-Adjacent Ranges

Changing the Chart Range or the Data Source

Changing the Chart Location

Printing a Chart

Formatting Charts

Adding Chart Titles

Formatting Chart Objects

Changing the Text Orientation

Adding a Data Table

Creating an Exploded Pie Chart

Adjusting the 3-D View

Deleting a Chart

Advanced Charting

Adding and Removing Gridlines

Formatting Gridlines or an Axis

Changing the Axis Scaling

Formatting the Data Series

Adding Data – Different Worksheets

Using a Secondary Axis

Changing Data Series Chart Types

Adding a Trendline

Creating and Applying User-Defined Charts

Drawing Objects

Working With Drawing Objects

Drawing Enclosed Objects and Lines

Selecting Filled and Unfilled Objects

Moving an Object

Adding or Selecting Text to an Object

Resizing an Object

Formatting Lines

Changing and Removing Fill Color

Changing the Font Color

Deleting an Object

Using Additional Effects and Objects

Applying a 3-D Effect or Setting \Adding a Shadow

Drawing a Text Box or an Arrow

Inserting Pictures

Formatting Graphics

Using AutoShapes and Diagrams

Working With AutoShapes

Drawing a Callout or a Basic Shape

Drawing a Connector or a Flowchart Shape

Drawing a Block Arrow

Inserting or Working With a Diagram

Using Paste Special

Working With Paste Special

Copying Values Between Worksheets

Copying Formulas Between Worksheets

Performing Mathematical Operations

Working With Data Series

Using the Series Command

Creating a Linear Series or a Date Series

Using a Stop Value

Creating a Growth Trend Series

Return to the Top of the Page

Excel XP Advanced

Length of Course:	1 day
Prerequisites:	See Excel 2000 Advanced Course Outline
Course Objective:	See Excel 2000 Advanced Course Outline

Course Outline:

Using Conditional And Custom Formats

Applying or Changing Conditional Formats

Adding or Deleting a Conditional Format

Creating a Custom Format

Using Range Names

Working With Range Names

Jumping to a Range Name

Assigning Names

Using Range Names in Formulas

Creating Range Names From Headings

Applying or Deleting Range Names

Using Range Names in 3-D Formulas

Creating 3-D Range Names

Using 3-D Range Names in Formulas

Using Other Functions

Using Function Arguments and Logical Functions

Using Date Functions

Formatting Dates or Revising Formulas

Managing Data

Sorting Lists

Sorting in Ascending or Descending Order

Finding or Replacing Data

Finding and Replacing Cell Formats

Using AutoFilter

Enabling AutoFilter

Using AutoFilter to a List

Clearing AutoFilter Criteria

Creating a Custom AutoFilter

Disabling AutoFilter

Managing Files

Changing Workbook Properties

Using the Basic or Advanced Search Task Pane

Clearing Query Clauses

Selecting File Views

Sorting Excel Files

Using HTML Files

Previewing a Web Page

Creating or Editing a Hyperlink

Saving a Worksheet as a Web Page

Using Publishing Options

Opening an Html File

Working With Comments

Applying an Outline

Collapsing or Expanding a Outline

Modifying Outline Settings

Clearing an Outline

Using Auto Outline

Working With Databases

Using and Creating a Database

Modifying a Database

Sorting Records by Multiple Fields

Using Data Validation

Validating Data Using a List

Creating a Custom Error Message

Removing Data Validation

Creating or Removing Subtotals in a List

Working With Data Form

Viewing the Data Form and its Records

Editing or Adding Data Form Records

Deleting Criteria

Clearing Data Form Criteria

Deleting Data Form Records

Working With Advanced Filters

Creating and Using a Criteria Range

Showing All Records

Using Comparison Criteria

Using an Advanced And Condition

Using an Advanced Or Condition

Copying Filtered Records

Using Database Functions

Using Worksheet Protection

Unlocking Cells in a Worksheet

Protecting or Unprotecting a Worksheet

Creating or Deleting Allow-Editing Ranges

Protecting Workbook Windows

Assigning a Password and Opening a Password-Protected File

Removing a Password

Setting Manual Calculation

Resetting Automatic Calculation

Using the Document Recovery Pane

Return to the Top of the Page

Excel XP Expert

Length of Course:

1 day

Course Outline:

Customizing Excel Preferences

Setting View and Edit Options

Setting General Options

Using Advanced Functions

Using Lookup Functions

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the IF Function

Using Nested IF Function

Using the ISERROR Function

Using an AND Condition with IF

Using an OR Function with IF

Using the ROUND Function

Limiting the Precision of Numbers

Using Scenarios and Goal Seeking

Using the Scenario Manager

Creating and Displaying a Scenario

Editing a Scenario

Creating a Scenario Summary Report

Using Goal Seek

Using Data Tables

Using Data Tables

Placing Formulas in Data Tables

Creating a One or Two-Variable Table

Using Macros

Defining Macros

Opening a Workbook Containing Macros

Running a Macro

Using a Shortcut Key and the Visual Basic Toolbar

Opening and Using the Visual Basic Editor Window

Recording Macros

Recording a Macro

Assigning a Shortcut Key

Using Relative References

Assigning a Macro to a Menu

Removing a Custom Menu Item

Deleting a Macro

Editing Macros

Writing a New Macro

Entering and Copying Macro Commands

Editing and Typing Macro Commands

Running a Macro from the Code Window

Using Custom Toolbars and Windows

Creating a Custom Toolbar

Adding or Removing Custom Toolbar Buttons

Adding the Custom Button to a Toolbar

Assigning a Macro to a Button

Changing a Button Image

Displaying Button Text and Image

Attaching or Deleting a Custom Toolbar

Creating a Custom Menu

Adding Custom Menu Commands

Creating And Revising Tables

Creating and Refreshing a PivotTable Report

Adding PivotTable Report Fields

Selecting a Page Field Item

Changing the Summary Function

Adding New Fields to a PivotTable Report

Moving or Deleting PivotTable Report Fields

Hiding or Unhiding PivotTable Report Items

Creating a Page Field Report

Formatting a PivotTable Report

Creating a PivotChart Report

Publishing PivotTable Charts to the Web

Adding Fields to a PivotTable – Browser

Using a PivotTable List

Return to the Top of the Page

Microsoft Excel Module

Length of Course: 5 Days (4 Hours Per Day)

Prerequisites: Business Applications 1 and 2

Course Objectives: To learn advanced Microsoft Excel features including: charts, graphics, database capabilities, macros and pivot tables.

Course Outline:

Using Labels in Formulas

Using Range Names

Using Paste Special

Working With Data Series

Creating Charts

Editing Charts

Drawing an Object

Drawing Additional Objects

Working with Databases

Sorting Data

Working With The Data Form

Using AutoFilter

Working With Advanced Filters

Using Database Functions

Using Lookup Functions

Using Logical Functions

Using Styles and Custom Formats

Using Templates

Using Macros

Recording Macros

Editing Macros

Creating/Revising Pivot Tables

Adding Pivot Table Fields

Changing Pivot Table Layout

Using Worksheet Protection

Return to the Top of the Page

Excel 2000 Beginning

Length of Course:	1 day
Prerequisites:	Windows 95/98/NT Beginning
Course Objective:	This course teaches students how to create a new workbook, add numbers and text, format numbers and text, work with the options for columns and rows, customize the cells, set up printing options, preview and print your document.

Course Outline:

Exploring Excel

Working with Excel Windows

Working with Toolbars

Exiting Excel

Working with the Office Assistant

Using the Office Assistant

Finding an Answer

Office Assistant Options

Using Basic Workbook Skills

Entering text into a cell

Saving, Closing, and Opening Workbooks

Working with Ranges

Selecting Ranges

Entering Values in a Range

Using AutoFill

Creating Simple Formulas

Entering Formulas

Using the AutoSum

Basic Functions

Using AutoCalculate

Using Range Finder Feature

Copying and Moving Data

Copying/Cutting and Pasting Data

Creating an Absolute Reference

Using Drag and Drop

Undoing and Redoing

Formatting Numbers

Using Numbers Styles

Customizing Number Styles

Formatting Text

Changing Text Appearance

Formatting with the Toolbar

Working with Columns and Rows

Selecting Columns and Rows

Changing Height and Width

Hiding and Unhiding

Inserting/Deleting a Row/Column

Formatting Cells

Changing Cell Alignment

Centering Text across Cells

Formatting using the Toolbar

Clearing Formats

Inserting/Deleting Cells

Using Page Setup

Setting Margins

Editing Headers and Footers

Repeating Labels

Setting/Removing a Print Area

Printing

Previewing a Worksheet

Printing a Selected Range

Return to the Top of the Page

Excel 2000 Intermediate

Length of Course:	1 day
Prerequisites:	Excel 2000 Beginning
Course Objective:	This course teaches the student how to use and manage large multiple worksheets. Creating and working with charts and editing charts with the use of several tools.

Course Outline:

Using Automatic Formatting and Styles

Working with formats

Using styles

Using Large Worksheet

Working with magnifications

Splitting windows

Working with panes

Working with Multiple Worksheets

Using multiple worksheets

Selecting worksheets

Managing Worksheets

Copying Worksheets

Copying Data between worksheets

Creating 3-D formulas

Using Paste Special

Copying formats and values between worksheets

Performing mathematical operations

Using Range Names

Working with ranges

Creating Charts

Using chart wizard

Adding a table to a chart

Working with ranges

Editing Charts

Changing chart type

Adding chart titles

Changing chart location

Printing a chart

Drawing and Object

Working with drawing objects

Working with colors

Using Additional Effects and Objects

Working with 3-D effects

Shadowing

Inserting pictures

Formatting graphics

Using Autoshapes

Drawing basic shapes

Drawing Flowchart shape

Drawing block arrow

Return to the Top of the Page

Excel 2000 Advanced

Length of Course:	1 day
Prerequisites:	Excel 2000 Intermediate
Course Objective:	This course teaches the student how to use templates. It also teaches them to manage and work with databases, autofilter, data, pivot tables, multiple workbooks and custom formats.

Course Outline:

Using Templates

Working with templates

Inserting a new worksheet

Managing Data

Sorting data

Finding and replacing data

Working with Databases

Creating a database

Working with data validation

Working with the Data Form

Using data form records

Defining criteria

Using Autofilter

Working with autofilter

Disabling autofilter

Working with Advanced Filters

Using criteria ranges

Using comparison, advanced and condition criteria

Extracting filtered records

Importing and Exporting Data

Changing external data range properties

Importing and exporting data from other applications

Creating/Revising Pivot Tables

Using a pivot table

Working with pivot table filter

Working with pivot table reports

Using Multiple Workbooks

Working with workbook windows

Linking workbooks

Using Conditional and Custom Formats

Creating a custom format

Working with Comments

Creating comments

Using the reviewing toolbar

Customizing Excel Preferences

Working with options

Managing Files

Changing workbook properties

Working with criteria

Copying Excel files to a floppy diskette

Return to the Top of the Page

Excel 2000 Macros

Length of Course:	1 day
Prerequisites:	Excel 2000 Advanced
Course Objective:	This course teaches the student how to use advanced functions, scenarios and goal seeking. It also teaches them to use, record, edit and create macros.

Course Outline:

Using Advanced Functions

Using lookup functions

Using vlookup functions

Using hlookup functions

Working with If and And conditions

Using the round function

Using Scenarios and Goal Seeking

Working with scenarios

Using goal seek

Using Data Tables

Working with data tables

Working with one variable tables

Working with two variable tables

Using Auditing Tools

Working with arrows

Tracing cell causing errors

Consolidating Worksheets

Consolidation by category

Consolidation by position

Solving Problems

Saving a solutions as a scenario

Restoring original values

Using Macros

Working with Macros

Using a shortcut key

Using Visual basic

Recording Macros

Assigning a shortcut key

Assigning and deleting a macro from a menu

Editing Macros

Writing a new macro

Using macro commands

Running a macro from the code window

Using Custom Toolbars and Buttons

Writing with custom toolbars

Assigning a macro to a button

Creating a Macro Button

Using macro buttons

Moving and sizing a macro button

Return to the Top of the Page

Excel 2000 Upgrade

Length of Course:

45 Minutes

Course Outline:

EXCEL NEW FEATURES

Saving a Worksheet as a Web Page

Importing Data

Importing Data from Text Files

Importing Data from Other Applications

Removing the Query Definition

Importing a Table from a Web Page

Creating Interactive PivotTables - Web

Adding Fields to a PivotTable - Browser

Adding a Trendline

Return to the Top of the Page

Excel 97 Beginning

Length of Course: 1 day

Prerequisites: Windows 95 Beginning

Course Objective: To provide the basics for worksheet manipulation and creation of a worksheet with formulas.

Course Outline:

Exploring Excel

Using the Office Assistant

Using OnLine Help

Using Basic Workbook Skills

Working With Ranges

Creating Simple Formulas

Copying and Moving Data

Printing Worksheets

Using Page Setup

Formatting Numbers

Formatting Text

Working with Columns and Rows

Formatting Cells

Using AutoFormat

Using Large Worksheets

Return to the Top of the Page

Excel 97 Intermediate

Length of Course: 1 day

Prerequisites: Windows 95 Beginning and Excel 97 Beginning

Course Objective: To learn to use worksheets in your Excel workbooks, create charts, and draw objects.

Course Outline:

Using Range Names

Using Labels in Formulas

Using Multiple Workbooks

Working With Multiple Sheets

Managing Worksheets

Using Paste Special

Working With Outlines

Creating Charts

Editing Charts

Drawing an Object

Drawing Additional Objects

Using Advanced AutoShapes

Managing Data

Working With HTML Files

Managing Files

Return to the Top of the Page

Excel 97 Advanced

Length of Course: 1 day

Prerequisites: Windows 95 Beginning and Excel 97 Intermediate

Course Objective: To learn to use database capabilities, filters, templates and macros in Microsoft Excel.

Course Outline:

Working With Databases

Using Database Functions

Working With The Data Form

Sorting Data

Using AutoFilter

Using Advanced Filters

Using Worksheet Protection

Rounding Numbers

Using Styles and Custom Formats

Using Templates

Using Macros

Recording Macros

Editing Macros

Creating a Macro Button

Using Custom Toolbars and Buttons

Return to the Top of the Page

Legal Terms and Conditions