About Square One

Any Square One 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 Days or 4 evenings
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.

Booking
To discuss course contents and booking arrangements, please contact Michelle or Suzanne on:

Tel:   0151 650 6907
Email: info@squareonetraining.com

trans

 
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

Microsoft Excel Outline

top of page top of page


Square One Computer Training

Square One Computer Training is the Wirral's premier software training company, offering both in-house and on-site training with floorwalking and consultancy services around the UK. Call +44(0)151 650 6907 for details.
Navigation Home Company Profile Our Premises Clients Course Outlines Course Schedule Consultancy How to Find Us Sales Enquiries Interesting Sites