We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:

  • Microsoft Office: Word, Excel, Outlook, PowerPoint, OneDrive, Visio, Teams
  • Microsoft Project
  • Microsoft SharePoint
  • Adobe Creative Suite: Photoshop, InDesign, Illustrator, Acrobat
  • Power BI
  • And many others…just call us on 01223 841848 or email us

Excel Introduction

Location Great Shelford, Cambridge
Price ex. VAT £210.00
Start Date 02 July 2020
Course type Standard
Course code FROG229
Duration 1 Day

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)

Course Search

Contact Us
Contact Us