Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2007 Level 1

GK# 8754

Course Overview

TOP

If you are new to Microsoft Excel 2007, this course will teach you the fundamentals about spreadsheets. You will explore worksheets and workbooks, learn to work in columns and rows, and to work with cell contents. You will create formulas and use function commands to manipulate data. Finally, you will learn how to change the page setup, and to print your documents.

What You'll Learn

TOP
  • Learn navigation skills necessary for creating and using Excel spreadsheets
  • Organize columns and rows to accommodate information
  • Edit the contents of cells to organize the information on your worksheet
  • Calculate values using formulas
  • Specify an exact address of a cell
  • Create absolute cell references
  • Create formulas using functions or by building more complex formulas using the Insert Function dialog box
  • Format cells and worksheet elements for consistency and readability
  • Change the page setup
  • Preview the workbook to define how the printed worksheet appears

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Getting Started with Microsoft Excel

  • Understanding Spreadsheet Concepts
  • Creating New Workbooks

2. Modifying the Worksheet

  • Working with Columns and Rows
  • Working with Cell Contents

3. Using Formulas and Functions

  • Creating and Using Formulas
  • Creating and Using Functions
  • Using Absolute Cell References
  • The Insert Function Command

4. Formatting Worksheets

  • Formatting Cells
  • Formatting Worksheet Elements

5. Setting Print Options

  • Changing the Page Setup
  • Previewing the Workbook

Who Should Attend

TOP

New users of Excel 2000/2002/2003

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll