Course Overview

This classroom training is designed for users wishing to extend their knowledge of the features and functions available within this program.

Pre-requisites
You should know how to produce basic formulas and how to use dollar signs in formulas prior to this training.


Objectives

By attending this workshop, you will learn –

  • how to build complex spreadsheets which link via formulae, together with being able to construct functions which incorporate logic into the statement. An element of automation is also examined so that repetitive sheets can be recreated with minimal effort.
  • how to manipulate data to give various outputs.

 

Content

  • Customising Quick Access Toolbar
  • Customising Ribbons
  • Freezing panes
  • Notes
  • Themes and Styles
  • Templates/Auto Templates
  • Multiple Worksheets -v- Multiple Workbooks
  • Group editing
  • 3D Formulas
  • Linking Worksheets/Workbooks
  • Protection
  • Consolidating Data
  • Auditing Tools
  • Watch Window
  • FlashFill
  • Text to Columns
  • Concatenation
  • IF Functions
  • Date/Time Functions
  • Lookup Functions
  • Sparklines

 

 

 

Have a question?

Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.

What you need to bring for these courses when delivered as a virtual classroom.

For virtual classroom courses, you will need:

  • Computer with Internet Access
  • Microphone and Headset
  • Webcam
  • Microsoft Teams
  • A dual monitor setup is recommended for IT training
Upcoming Courses
Get in touch via our contact form or call us on 01473 414 414