Sign Out
Logged In:
 
 
 
 
 
Tab Image

Advanced Excel Skills

 
         
  Ref. 506  
  Simon Pegg (Holleth Limited)
  22 August 2018, Birmingham
  £455 + VAT Members
  £505 + VAT Non-members
  Hands-on course
         

 

   
   Foundation
   Descriptive NA
   Predictive 100%
   Prescriptive
 

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
  Email: jennie.phelps@theorsociety.com