| Print |

Excel Intermediate

Location Cambridge
Price ex. VAT 199 GBP
Start Date 14 May 2019
Course type Standard
Course code FROG228
Duration 1 Day

Description

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.

Target Audience

Designed for existing users.

Prerequisites

Attendance of the Introduction course or equivalent knowledge.

Outline

Refresher of the Basics

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

Names

  • Creating and Naming Cells

Tips for Working with Large Spreadsheets

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

Worksheet and File Linking

  • Creating Simple Links  

Page Setup Options

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

List Data

  • Sorting a List
  • Filters

Charts and Shapes

  • Creating, Formatting and Editing Basic Charts
  • Sparklines 

Book the course: Excel Intermediate

Course Search