In this course, students will learn to work with spreadsheets, use formulas, and format cells and pages.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion of this course, students will be able to create and edit Excel worksheets and workbooks

1
  • Creating and Nagivating a Workbook

  • Opening, saving and closing in Excel

2
  • Using Sort and Filter

  • Sorting data
    Creating filters
    Creating an advanced filter

3
  • Calculating Data

  • Using basic formulas
    Calculating with functions
    Using absolute and relative references

4
  • Formatting Cells

  • Modifying fonts
    Adding borders and colors to cells
    Using the format painter
    Formatting numbers
    Cell alignment
    Adjusting column and row width

5
  • Page Setup

  • Excel Views
    Setting page breaks
    Orientation
    Margins
    Headers and Footers
    Freeze and unfreeze panes and repeat rows
    Splitting a worksheet
    Rename and remove sheets
    Set printing options

Audience

This course is designed for beginners and is intended for individuals wanting to gain basic knowledge of working on Excel.

Language

English

Prerequisites

There are no stated prerequisites for this course. Please check with your representative for details.

$185

Length: 1.0 day (8 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...