Microsoft Excel Introduction

1 Day
Versions XP, 2003 and 2007

Course Description

This instructor-led, hands-on course teaches students the basic skills needed to enter and edit information, write formulas, format cells, and print spreadsheets in Microsoft Excel.

Prerequisites

This course is designed for users that are new to Microsoft Excel or are self-taught. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Windows course or have equivalent knowledge. You should feel comfortable using a mouse and have a working knowledge of the Windows environment.

Is this the right level for you? Take our free assessment! Please contact our office at 202.682.4500 if you have any questions.

Building a Simple Excel Workbook

Understanding Important Screen Elements

Opening and Reviewing a Workbook

Entering Text, Numbers, and Dates

Editing and Deleting Cell Contents

Understanding Mouse Pointer Shapes and Selecting Ranges

Moving Data by Drag-and-Drop

Copying Data with the Fill Handle

Reversing Mistakes with Undo and Redo

Spell Checking Your Work

Saving and Closing a File

Using Help

Working with Excel Worksheets

Renaming Worksheets

Adding Color to Sheet Tabs

Moving Worksheets

Adding and Deleting Worksheets

Writing and Copying Excel Formulas

Writing Formulas

Using Functions in Formulas

Using the AutoSum Button

Copying Formulas

Using the Insert Function Tool

Using =TODAY to Insert the Current Date

Using Dates in Formulas

Using AutoCalculate

Formatting An Excel Worksheet

Changing Column Widths

Applying Fonts, Bold, Underline, and Italics

Aligning Data in Cells

Centering Data Across Columns

Wrapping Text

Formatting Numbers, Formulas, and Dates

Adding Borders and Fill Color

Inserting and Deleting Columns or Rows

Inserting Comments

Removing Formatting and Comments

Working with Larger Excel Workbooks

Keeping Headings on the Screen as You Work

Previewing Before Printing

Printing Row and Column Headings

Hiding Columns

Sorting Rows of Information

Printing a Worksheet