Enhance your use of advanced formulas and database features

This one day course is designed for people who have created a spreadsheet and now wish to manipulate and interrogate the data in greater detail.

What you will gain

You will gain enhanced skills in the techniques associated with large and multiple spreadsheet design, including data manipulation, worksheet consolidation and more complex functions and formulae.

Who should attend this course?

You should attend this course if you are currently using Excel for basic formulas and would like to develop your skills in the creation and understanding of functions.

Course Objectives

This course covers the following key topics: -

  • Work with multiple spreadsheet workbooks
  • Dynamically link worksheets and workbooks using more complex formulae and consolidation tools
  • Work with lists and manipulate data using sort and filters
  • Understand and utilise some of Excel's more advanced functions
  • Create nested logical functions
  • Create and manipulate charts

 Booking Form 

Duration:
Course Code:
Delegate Cost:
1 day
ME2
£210 + VAT
Other courses you may like:

Microsoft Excel Introduction 
Microsoft Excel Advanced

Book this course for in-house delivery
 Request Now 
What others said about this course  
Trainer was very helpful, knowledgeable and made sure all delegates needs were met. KV (DCLG)
Very fluent and tailored presentation. PS (DCLG)
Very good, I would recommend colleagues to attend this. TB (Department for Transport)

Course Finder 

Call us now for further information

0844 33 505 87


Course Finder


Copyright © 2014 Alpha Consolidated Training Limited. All Rights Reserved.