ECDL, ECDL Advanced & ECDL CAD

Getting started with Excel

• Overview of Excel
• Overview of Excel Screen
• Navigating the Excel Screen

File Management

• Creating Worksheets
• Opening Worksheets
• Editing Worksheets

Entering and Selecting Data

• Typing Text, Dates and Numbers
• Selecting Cells, Rows and Columns using the Mouse and Keyboard

Using Functions

• Using Sum, Average, Min, Max etc.
• Understanding the Function Wizard

Working with Dates

• Date Calculations
• Formatting Dates

Copying and Moving Data/Formulae

• Using Cut, Copy and Paste
• AutoFill
• Customising AutoFill
• Drag and Drop
• Copy and Drop
• Absolute Cell Referencing

Editing Worksheets

• Adding Rows and Columns
• Sizing Rows and Columns
• Hiding Rows and Columns
• Adding Comments

Formatting Worksheets

• Working with Fonts, Format Painter, Colours, Lines, Alignment and Number Formatting

Charting

• Producing Charts using a Function Key
• Producing Charts using the Chart Wizard
• Changing the Chart Type
• Formatting Charts
• Adding Titles
• Customising the Chart

Printing

Working with Large Worksheets

• Freezing and splitting Rows and Columns

About SquareOne

Any SquareOne course can be tailored to meet the particular requirements of your organisation.  We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.

Course Objectives

This course is suitable for all new users of Excel who wish to improve their understanding of the package and produce powerful well presented spreadsheet models.  Often "self-taught" users miss out on the productivity benefits of some of the time saving features of Excel.  These are covered in detail on the course.

Course Details

Duration:    2 Day

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.