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


Designed for existing users. The aim of this course is to have the participant `up and running' immediately following a one day intermediate 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 and graphs.

Dates Thursday, September 12, 2019 - Download as vCalendar
Venue FROG Software Training Ltd, Great Shelford, Cambridgeshire CB22 5NE
Contact Name Debby O'Gorman
Email debby@frog.co.uk
Contact Phone 01223 841848
Website Event website

Event details:

Pre-requisites
Attendance of the Introduction course or equivalent knowledge

Objectives
The aim of this course is to have the participant `up and running' immediately following a one day intermediate 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 and graphs.

Refresher of the Basics

  • Tips for Creating Spreadsheets
  • Basic Formulae/Functions/Absolute references

Tips for Working with Large Spreadsheets

  • Freezing Screen Titles
  • Splitting Windows
  • Displaying Multiple Sheets/Files on Screen

Page Setup Options

  • Margins
  • Headers and Footers
  • Printing Titles
  • Sheet Options
  • Scaling
  • Page Break Preview
  • Setting Print Areas
  • Sheet Background

Worksheet and File Linking

  • Creating simple links
  • Multiple sheet formulae

Ranges

  • Creating and naming ranges
  • Clearing and formatting ranges
  • Copying and moving ranges

List Data

  • Sorting a list
  • Filters
  • AutoComplete

Charts and Shapes

  • Charts
  • Creating, formatting and editing a chart
  • Printing Charts
  • Sparklines
  • Creating and modifying lines and shapes

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.