FROG Software Training: Excel 2007/2010/2013/2016 Introduction


FROG Software Training: Excel 2007/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 6 Feb 2019 - Download as vCalendar
Opening times 9.30am to 4.30pm
Venue FROG, Great Shelford, Cambridge CB22 5NE
Organiser name Debby O'Gorman
Telephone
01223841848
Email
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
    • 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

 

FROG Software Training Limited

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.

FROG Software Training Limited directory information