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.
Frog Software Training: Excel 2010/2013/2016 Introduction
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
Moving around the screen
Selecting cells and ranges
Creating a Spreadsheet
Entering text and numbers
Saving workbooks/Save as PDF
Preview and print workbooks
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
Formatting ranges (currency, fixed etc)
Rotate and indent text
Modify cell size and alignment
Apply borders and shading
Absolute & Relative Formulae
Analysing Data using AVERAGE, MIN, MAX, COUNT and COUNTA
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.