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

• Use the Excel menu system

• 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

• Include print titles on every page of a printout

• Use Excel functions

What you will learn
Topics covered by this course include:

Getting Started

• Excel Menus

• Using the File tab

• Use the Quick Access toolbar

• Customising a Ribbon

• Displaying Help

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

Building a New Worksheet

• Opening a New workbook and populating it with data

• Using Spell Checker

Editing a Worksheet

• Using the AutoFill & AutoSum Features

• Copying, Moving & Clearing Cell Entries

• Inserting Cells, Rows & Columns

• Working in Edit mode

Formatting a Worksheet 

• 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

• Inserting a Manual page break and including Print titles in a printout

Using Excel Functions

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

• Using the Insert Function button

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^®