| Print |

Excel Introduction

Location Cambridge
Price ex. VAT 199 GBP
Start Date 06 February 2019
Course type Standard
Course code FROG229
Duration 1 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

    Course Search