Essentials of Excel

3 Hours
Versions 2007 and 2010

This fast-paced introductory course is ideal for students who want to learn the most essential features of Excel in a half day. This course covers setting up new workbooks, writing formulas, using functions, formatting text, page setup, and printing.

Building Simple Workbooks

Understanding Excel Terminology

Examining Important Screen Elements

Opening Workbooks

Reviewing Workbook Data

Navigating Within Worksheets

Entering General Text

Entering Numbers

Entering Dates

Editing Cells

Deleting Cell Contents

Understanding Mouse Pointer Shapes

Selecting Cells, Rows, and Columns

Moving Data by Drag-and-Drop

Copying Data with the Fill Handle

Reversing Mistakes with Undo and Redo

Saving Workbooks

Closing Workbooks

 

 

Writing and Copying Basic Formulas

Understanding Formulas Elements and Syntax

Creating Basic Formulas

Using Functions in Formulas

Using the Sum Button

Copying Formulas

Formatting and Printing Worksheets

Changing Column Widths

Applying Fonts, Bold, Underline, and Italics

Aligning Data in Cells

Formatting Numbers and Formulas

Formatting Dates

Applying Borders

Applying Fill Color

Inserting and Deleting Columns or Rows

Previewing Before Printing

Printing Worksheets

 

Find us
Find us on Facebook  Find us on Twitter

Register online

Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.

Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.

Top of Page
Softek Services, Inc.