Excel Introduction

LocationCambridge

Price ex. VAT
199 GBP

Start Date02 May 2019

Course typeStandard

Course codeFROG229

Duration1 Day

Description

The aim of this course is to introduce working with spreadsheets and simple calculations. At the end of the session you will be able to create, edit and format spreadsheets using number and font formatting; alter the structure of the spreadsheet by inserting, deleting and resizing columns and rows. Finally you will be able to create some simple calculations.

Target Audience

Designed for new users.

Prerequisites

Basic keyboard and PC skills and a knowledge of the windows environment is assumed.

Outline

What is a Spreadsheet?

The Excel Screen

The Ribbon

Moving around the screen

Selecting cells and ranges

Creating a Spreadsheet

Opening workbooks

Entering text and numbers

Saving workbooks/Save as PDF

Preview and print workbooks

Closing workbooks

Editing a Spreadsheet

Deleting cell contents

Editing text and numbers

Copying/moving data/Pasting Options

AutoFill

Inserting and deleting rows and columns

Hiding rows and columns

Inserting, deleting, copying and moving worksheets

Formatting

Apply font formats

Formatting ranges (currency, fixed etc)

Rotate and indent text

Modify cell size and alignment

Apply borders and shading

Formulae

Simple calculations

Copying formulae

Editing formulae

Absolute & Relative Formulae

AutoCalculate

Range Finder

Statistical Functions

AutoSum

Analysing Data using AVERAGE, MIN, MAX, COUNT and COUNTA

Tell Me (Help)

Book the course: Excel Introduction

*
Number of Attendees

*
Salutation:

*
Firstname:

*
Last Name:

*
Email:

* Attendees Names:

Software Version:

* Telephone No:

Company:

How did you here about us:

Voucher Code:

Comments:

FROG would love to keep in touch about future offers and services we think you’ll like to hear about. To confirm you would like to receive this information by email, please tick the box. Don’t forget, you can also change your marketing contact preferences at any time by emailing training@frog.co.uk or by using the unsubscribe links which you’ll find on all our marketing emails. For further information please see our Privacy Policy