Excel 2007/2010/2013/2016 Intermediate

Short course

In Cambridge

Save 4%
£ 190 + VAT

Description

  • Type

    Short course

  • Level

    Beginner

  • Location

    Cambridge

  • Duration

    1 Day

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. This course will assist users to prepare for the Excel 2007 Core Microsoft Office User Specialist Exam. Suitable for: Designed for existing users. If required courses may be tailored. Please call to discuss content.

Important information

Documents

  • Outline

Facilities

Location

Start date

Cambridge (Cambridgeshire )
See map
4 Station Court, Great Shelford, CB225 NE

Start date

On request

About this course

Attendance of the Introduction course or equivalent knowledge

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Create spreadsheets
  • Create graphs
  • Excel
  • MS Excel
  • Accounts
  • Excel 2010
  • Excel 2007
  • Excel 2013
  • Formula referencing
  • Excel 2016

Teachers and trainers (1)

TBA TBA

TBA TBA

Trainer

Course programme

Excel Intermediate

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

Formatting Tables with Filters (Format Tables)

Charts and Shapes

Charts

Creating, formatting and editing a chart

Printing Charts

Sparklines

Creating and modifying lines and shapes

Additional information

FROG have been providing excellent training for 30 years

Excel 2007/2010/2013/2016 Intermediate

£ 190 + VAT