Lumenbrite Training

Excel Training: Introduction

Excel Training: Introduction

Excel Training: Introduction Schedule

Request a schedule of Excel Training: Introduction Training.

Special Group rates are available for this training.

We can also perform this training at your location or at one of the cities listed below:

Excel Training: Introduction Overview

In this introductory level course, the basic concepts of Microsoft Excel are explored. This course includes a basic understanding of spreadsheet software and an introduction to setting up spreadsheets and utilizing some of the basic tools for formula building and formatting. This course is critical in establishing a solid foundation for the more advanced courses that are offered as the knowledge base grows.

Excel Training: Introduction Course Prerequisites

  • Basic computer knowledge on a PC or Mac

Excel Training: Introduction Course Outline

  • Unit 1: Getting started

    • Topic A: Spreadsheet terminology
      • Discussing spreadsheet terminology
    • Topic B: Exploring the Excel window
      • Examining Excel window components
    • Topic C: Getting help
      • Using Help
      • Topic D: Navigating workbooks
      • Navigating a worksheet

  • Unit 2: Entering and editing data

    • Topic A: Entering and editing text and values
      • Entering text and values
      • Editing text
      • Using AutoFill to fill a series
    • Topic B: Entering and editing formulas
      • Entering a formula by typing
      • Entering cell references with the mouse
      • Editing a formula
    • Topic C: Working with pictures
      • Inserting and modifying a picture
    • Topic D: Saving and updating workbooks
      • Saving a workbook
      • Changing and updating a workbook
      • Using the Compatibility Checker

  • Unit 3: Modifying a worksheet

    • Topic A: Moving and copying data
      • Moving data in a worksheet
      • Copying data in a worksheet
      • Moving and copying data by using drag-and-drop
      • Copying data by using the Clipboard
    • Topic B: Moving and copying formulas
      • Moving a formula
      • Copying a formula
      • Using AutoFill to copy a formula
    • Topic C: Absolute and relative references
      • Observing the limitations of relative references
      • Using absolute references
    • Topic D: Inserting and deleting ranges, rows, and columns
      • Inserting a range
      • Inserting rows
      • Deleting a range

  • Unit 4: Using functions

    • Topic A: Entering functions
      • Entering a SUM function
      • Using the mouse to enter a function argument
      • Inserting a SUM function
    • Topic B: AutoSum
      • Using the AutoSum button
    • Topic C: Other useful functions
      • Using AVERAGE
      • Using MIN
      • Using MAX
      • Using COUNT and COUNTA

  • Unit 5: Formatting worksheets

    • Topic A: Formatting text
      • Using the Font group to format text
      • Formatting non-contiguous ranges
      • Using the Format Cells dialog box to format text
    • Topic B: Formatting rows and columns
      • Changing column width and row height
      • Applying color to a row
      • Setting alignment
      • Applying borders to ranges
      • Using the border-drawing pencil
      • Using the Paste Special option
      • Removing a border
    • Topic C: Formatting numbers
      • Using the Number group to format numbers
      • Exploring the Number tab
    • Topic D: Conditional formatting
      • Creating a conditional format
      • Editing and deleting a conditional format
    • Topic E: Copying formats and applying table formats
      • Copying formats
      • Using AutoFill to copy a format
      • Applying cell and table styles
      • Using Find and Replace to change cell formats

  • Unit 6: Printing

    • Topic A: Preparing to print
      • Checking spelling in a worksheet
      • Using the Research task pane
      • Finding and replacing text
      • Previewing a worksheet
    • Topic B: Page Setup options
      • Setting page orientation
      • Setting margins
      • Creating and editing headers and footers
      • Hiding gridlines and headings
    • Topic C: Printing worksheets
      • Printing a worksheet
      • Working with the print area

  • Unit 7: Creating charts

    • Topic A: Chart basics
      • Creating a chart
      • Moving a chart within a workbook
      • Examining chart elements
      • Using an embedded chart
    • Topic B: Modifying charts
      • Changing a chart type
      • Applying Quick Layouts and Quick Styles
      • Formatting chart elements
      • Modifying an embedded chart
    • Topic C: Printing charts
      • Printing a chart

  • Unit 8: Managing large workbooks

    • Topic A: Viewing large worksheets
      • Using the Freeze Panes command
      • Splitting a worksheet into panes
      • Hiding and unhiding columns and worksheets
      • Minimizing the Ribbon
    • Topic B: Printing large worksheets
      • Setting print titles
      • Adjusting page breaks
    • Topic C: Using multiple worksheets
      • Navigating between worksheets
      • Naming worksheets and coloring tabs
      • Working with multiple worksheets
      • Previewing and printing multiple worksheets

 

Course Resources
We'd love to Help!