Frog Software Training: Excel Introduction

Designed for new users.

Dates Wednesday, May 5, 2021 - Download as vCalendar
Event Times: 09:30 to 16:30
Venue Great Shelford (may switch to online due to COVID)
Contact Name Rachel Crew
Contact Phone 01223 841848
Website Event website

Event details:


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.


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


  • Apply font formats
  • Formatting ranges (currency, fixed etc)
  • Rotate and indent text
  • Modify cell size and alignment
  • Apply borders and shading



  • 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)


For over 30 years we have improved the skillset of over 20,000 individuals with our exceptional and enjoyable courses. Our training and support started back in 1986, when our founder was working with Stephen Hawking as his PA. But you don’t have to be a world-famous theoretical physicist to take part in our training – All our courses from beginner to advanced level provide you with actionable, hands-on training that you can put into practice immediately and save you valuable time!