Essentials of Excel

3 Hours
Versions 2003 or 2007

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

Important Screen Elements

Opening Workbooks

Reviewing Workbooks

Navigating Through Worksheets

Entering Text

Entering Numbers

Entering Dates

Editing Cells

Deleting Cell Contents

Understanding Mouse Pointer Shapes

Selecting Ranges

Moving Data by Drag-and-Drop

Copying Data with the Fill Handle

Reversing Mistakes with Undo and Redo

Checking For Spelling Errors

Saving Files

Closing Files

Using Microsoft Office Help

Working with Worksheets

Renaming Worksheets

Adding Color to Worksheet Tabs

Moving Worksheets

Adding New Worksheets

Deleting Worksheets

Writing and Copying Formulas

Writing Formulas

Understanding Order of Precedence

Formula Syntax

Creating Basic Formulas

Using Functions in Formulas

Using the AutoSum Button

Copying Formulas

Using the Clipboard to Copy and Paste

Using the Fill Handle to Copy

Formatting Worksheets

Changing Column Widths

Applying Fonts, Bold, Underline, and Italics

Copying Formatting from One Cell to Another

Aligning Data in Cells

Formatting Numbers and Formulas

Applying Borders

Applying Fill Color

Inserting and Deleting Columns or Rows

Inserting Columns and Rows

Deleting Columns and Rows

Printing Worksheets

Previewing Before Printing

Printing Worksheets

Appendix A:  Page Setup Options

 

 

 

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 intersted 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.