Great Shelford, Cambridge / Online
1 day course
£210.00 (ex. VAT)

This is our 1 day intermediate Microsoft Excel training course for those that already have some basic knowledge of Excel and may have attended our Introduction course, but now need to take their skills to the next level.

If you have dabbled in Excel before and set up some basic tables and perhaps some very basic formulae, then this course will be the natural next step. After a refresh of the basics of Excel, this course will teach you not only how to organise your data faster but also how to interpret the numbers through sorting lists, using filters effectively and representing data in charts.

By the end of this course our trainers will have given you the extra tools you need to understand basic formulae in more detail, print and manage large spreadsheets more easily and create simple graphs.

Course Outline

Refresher of the Basics

  • Tips for Creating Spreadsheets
  • Basic Formulae / Functions
  • Absolute References ($)

Names

  • Naming Cells
  • Editing and Deleting

Tips for Working with Large Spreadsheets

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

Worksheet and File Linking

  • Creating Simple Links
  • 3-D Referencing
  • Consolidation
  • Hyperlinks
  • Links to other Programs

Page Setup Options

  • Margins
  • Headers and Footers
  • Repeat Headings for Printing
  • Scaling
  • Page Break Preview
  • Setting Print Areas

List Data

  • Sorting a List
  • Filters

Charts

  • Creating, Formatting and Editing Basic Charts
  • Sparklines

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel Power Pivot and Power Query

Microsoft Excel VBA