Sign Out
Logged In:
Tab Image

Advanced Excel Skills

New for 2017   Ref. 456  
  Simon Pegg (Holleth Limited)
  7 July 2017, Birmingham
  £455 + VAT Members
  £505 + VAT Non-members
  Hands-on course


   Descriptive NA
   Predictive 100%

This course will equip you with knowledge of how to use advanced Excel features and to get started with the basics of creating macros using Visual Basic. This  course is designed for intermediate Excel users or above who are comfortable with using Excel functions and who wish to: learn how to avoid the main pitfalls of spreadsheet design; create useful applications using more advanced Excel functionality; automate their spreadsheet applications to a higher degree; and enhance their personal capability to build reliable and high quality spreadsheets. Good knowledge of using Excel shortcuts is an advantage but not essential.

You will learn:

  • How to organise data to facilitate both data input and reporting
  • The basics of spreadsheet automation
  • How to create Pivot Tables and scenarios
  • How to use advanced functions including array functions to query and summarise data
  • How to create Microsoft Queries to extract data from multiple spreadsheets

If you are interested in further information, have any requirements (e.g. an alternative course date), or have difficulty booking a course online then please contact Jennie Phelps. It is recommended that courses are booked online. If this is not possible, then please print off, fill and fax or post the Training Course Booking Form.

Jennie Phelps   Address:  The OR Society, Seymour House, 12 Edward Street, Birmingham, B1 2RX, UK
  Tel: +44 (0)121 233 9300
  Fax: +44 (0)121 233 0321