Excel 2013: Basic

Course ID

27110

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

A basic understanding of the Windows

Audience

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

Course Content

    Getting started
  • Spreadsheet terminology
  • The Excel environment
  • Getting help
  • Using a template

    Entering and editing data
  • Entering and editing text and values
  • Entering and editing formulas
  • 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

    Charts
  • Chart basics
  • Formatting charts

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

    Graphics
  • Working with pictures
  • Conditional formatting with graphics
  • SmartArt graphics

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

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.