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


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 12 Sep 2019 - Download as vCalendar
Opening times 09.30-16.30
Venue FROG Software Training Ltd, Great Shelford, Cambridgeshire CB22 5NE
Organiser name Debby O'Gorman
Telephone
01223 841848
Email
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
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