Microsoft Excel Advanced

1 Day

This course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.

On completion of this course, attendees will be able to create a variety of functions, present their data using PivotTables, analyse workbooks and data and record macros.

Attendees should have attended our Excel Intermediate course or have equivalent knowledge.

£175 + VAT


 

Course Outline

Review of Excel Skills

  • Constructing formulae
  • Using functions
  • Absolute and relative cell referencing
  • Naming ranges

read more