Frog Software Training: Excel 2010/2013/2016 Introduction

Designed for new users. 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.

Dates Wednesday, September 2, 2020 - Download as vCalendar
Venue FROG, Great Shelford, Cambridge CB22 5NE
Contact Name Debby O'Gorman
Contact Phone 01223 841848
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




Page Layout


Editing a Spreadsheet

Deleting cell contents

Editing text and numbers

Copying/moving data/Pasting Options


Inserting and deleting rows and columns

Hiding rows and columns

Inserting, deleting, copying and moving worksheets




Apply font formats

Inserting Symbols

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


Range Finder


Statistical Functions


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.