Microsoft Office and Accounts

Getting started with Excel

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

File Management

• Creating Worksheets
• Opening Worksheets
• Editing Worksheets

Editing 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
• Drag and Drop
• Copy and Drop

Editing Worksheets

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

Formatting Worksheets

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

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: 1 Day
Timings:  9:30 - 16:30

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.