FROG Software Training: Excel 2010/2013/2016 Introduction

This course is intended for beginners who need to learn the basics of using spreadsheets. Our training centre is located on the outskirts of Cambridge with easy transport links with Shelford Train Station and the M11 and A11. We provide professional and enthusiastic training and of course there is the pub lunch to look forward to!

Dates Tuesday, June 2, 2020 - Download as vCalendar
Venue FROG, 4 Station Court, Great Shelford, Cambridgeshire CB22 5NE
Contact Name Rachel Crew
Contact Phone 01223841848
Website Event website

Event details:

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

The aim of this course is to have the participant `up and running' immediately following a one day basic programme based upon their existing skills and future needs.  At the end of the course the participant should be able to create a good selection of spreadsheets. This course will assist users to prepare for the Excel 2010 Core Microsoft Office User Specialist Exam.

  • 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
  • Views
    • Normal
    • Page Layout
  • 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
    • Inserting Symbols
  • 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
    • Function Wizard


Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.