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 11 Dec 2018 - This event is in the past.
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

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