Excel 2010: Basic

Course ID

27080

Course Description

This course is intended for IT Professionals who wish to learn the basics of creating, editing, and saving worksheet in our essentials level class. They will work with formulas and functions to calculate and return values. Delegates will learn to change the appearance of a page including adding headers and footers and formatting numeric data.

Prerequisites

Students should be comfortable with basic navigation tasks of the Windows ® environment.

Audience

This course is designed for students who wish to learn the basic operations of the Excel 2010 program to perform their day-to-day responsibilities.

Course Content

    Getting started
  • Spreadsheet terminology
  • The Excel environment
  • Getting help
  • Navigating a worksheet

    Entering and editing data
  • Entering and editing text and values
  • Entering and editing formulas
  • Working with pictures
  • Saving and updating workbooks

    Modifying a worksheet
  • Moving and copying data
  • Moving and copying formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows, and columns

    Using functions
  • Entering functions
  • AutoSum
  • Other common functions

    Formatting
  • Text formatting
  • Row and column formatting
  • Number formatting
  • Conditional formatting
  • Additional formatting options

    Printing
  • Preparing to print
  • Page Setup options
  • Printing worksheets

    Charts
  • Chart basics
  • Formatting charts

    Managing large workbooks
  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets

    Graphics and screenshots
  • Conditional formatting with graphics
  • SmartArt graphics
  • Screenshots

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 1 day
Price - $250.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.