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 Thursday, January 9, 2020 - Download as vCalendar
Venue FROG, Great Shelford, Cambridge CB22 5NE
Contact Name Debby O'Gorman
Email debby@frog.co.uk
Contact Phone 01223 841848
Website Event website

Event details:

Pre-requisites

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

 

Objectives

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

 

 

Formatting

Apply font formats

Inserting Symbols

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.