Microsoft Excel Introduction

BSBITU304 Produce spreadsheets – Nationally Recognised & Accredited Training

 Excel Introduction – Course Outline (PDF printable version)

General Information

Duration: 2 Half Days, 7 Hours
Cost: $445 GST‐Exempt, Includes training manual
Prerequisite: Experience with Windows.
Objectives: To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Excel.
Methodology: Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.
Competency Assessment:
This will be issued to trainees upon completion of training session.
Expected Outcome: By the end of the course the participant should be able to use the following functions and features of Microsoft Excel.

Course Content

Getting Started with Excel:
• Start Excel
• Excel Environment
• Opening Workbooks
• Working with Menus
• Navigating around a Worksheet
• Closing Workbooks

Setting up a Workbook:
• Creating a New Workbook
• Entering Data
• Editing and Deleting Data
• Undo Editing Changes
• Spell Check
• Saving the Workbook
• Additional Rows and Columns

Formatting a Worksheet:
• Widen Columns and Rows
• Selecting Cells
• Formatting Cells
• Copying and Moving Data
• Inserting Objects
• Customising your Toolbar

Preparing to Print:
• Previewing your Worksheet
• Adjusting Page Settings
• Adding a Header and Footer
• Print a Worksheet

Calculating Data:
• Creating Formulas
• BODMAS Theory
• Using Functions
• Copying Formulas