Objectives
After completing the course, participants will be able to:

• Use the Excel menu & toolbars

• Open, Close & Print Excel files

• Enter Formulas into Worksheets

• Use Task Panes

• Adjust Column Width and Row Height

• Automatically compute totals and fill ranges

• Insert Columns and Rows

• Realign cell entries

• Change the Font and Numeric Format

• Preview and Print Selected Areas of a worksheet

• Use Excel functions

What you will learn
Topics covered by this course include:

Getting Started

• The Excel Application Window, Menus & Toolbars

• Using Excel Task Panes

Modifying an Existing Worksheet

• Resetting the Working Folder

• Moving the Cell Pointer

• Changing Data in a Worksheet

• Reversing an Edit Operation

• Saving a Workbook

• Adding Data to a Worksheet

• Entering a Formula into a Worksheet

• Saving & Printing a Worksheet

Using Worksheet Shortcuts

• Using the AutoFill & AutoSum Features

• Copying, Moving & Clearing Cell Entries

• Inserting Cells, Rows & Columns

• Using Autosum

Enhancing Worksheet Appearance

• Using Edit Mode

• Adjusting Column Width & Row Height

• Realigning Cell Entries

• Changing the Font & Numeric Format of Cells

• Adding Borders & Shading to a Worksheet

• Using the AutoFormat Feature

Enhancing Printed Output

• Changing the Page Setup

• Previewing a Worksheet and Printing a Selected Area

Using Excel Functions

• Using the Sum, Average, Max, Min and Count Functions

Prerequisites
Basic computer skills are recommended for this course.

Dates and times
Please refer to your Fourth R centre for dates and times.

© Copyright The Fourth R^®