T: 01473 414414

select courses

we have a wide range of courses proven to be effective
select
courses

We have a wide range of diverse courses proven to be effective

explore
create your own
courses

Partnering with you to develop your solutions

explore
public sector
courses

We have a wide range of courses to suit you. Explore our full range here

explore

Free Download

Please complete this form to instantly receive your FREE PDF by email


Microsoft Excel - Intermediate

1 Day

Introduction

Designed for users wishing to extend their knowledge of the features and functions available within this program

Pre-requisites

Participants should have attended the introductory course or have gained similar knowledge and experience in the workplace. Participants should be able to produce basic formulas.

Benefits

Time efficient and effective manipulation, creation and reporting of data to support decisions

Programme Objectives

By the end of this course participants will be able 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.  Participants will also be shown the ‘database’ capabilities and be able to manipulate data to give various outputs.
 

Programme 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 (versions 2013 onwards)
  • Text to Columns
  • Concatenation
  • IF Functions
  • Date/Time Functions
  • Lookup Functions
  • Sparklines (versions 2010 onwards)