FROG Software Training: Excel 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 Wednesday, March 11, 2020 - 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.