Excel 2010 Essentials for Everyone
in Just Three Hours

Course Length

Three Hours

Prerequisites

Windows Introduction or equivalent experience

Course Description

Perhaps you have worked in Excel a time or two, but you are unsure how to do some of the basics. This hands-on class is designed for the beginner or someone with minimal Excel skills. Upon completion, you will be able to create and edit worksheets, perform calculations, and use a variety of functions.

Course Topics

• Recognize screen elements

• Move from sheet to sheet in a workbook

• Rename, insert, move, copy, and delete a sheet

• Change the default number of sheets in a workbook

• Enter text and numbers in a cell

• Use AutoComplete

• Enter information in a selected range

• Replace and edit cell contents

• Use the Undo and Redo commands

• Preview and print data

• Save and close a workbook

• Create a new workbook

• Open an existing workbook

• Navigate using the mouse and keyboard

• Use the Go To command

• Change worksheet views

• Select data using the mouse and keyboard

• Enter a formula using cell references

• Edit a formula

• Understand the Order of Operations

• Enter a function using the “Insert Function” dialog box

• Enter a function using the Function Library

• Enter a function using Formula AutoComplete

• Use the AutoSum button

• Use the AutoSum button drop-down list

• Use the AutoFill feature

• Resize columns and rows

• Change a cell reference in a formula to absolute or mixed

• Insert and delete cells, rows, and columns

• Hide and unhide columns, rows, and a worksheet

• Move, copy, and paste data using the Clipboard

• Paste with Live Preview

• Use the Paste Options button

• Move and copy using Drag and Drop

• Sort rows by one column
   

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.

[Home   |   Services   |   Courses   |   Instructors  |  References  |  Contact Us]