Sign Out
Logged In:
 
 
 
 
 
Tab Image

Organising and Presenting Data in Excel

 
         
  Ref. 381  
  Simon Pegg
  3 March 2016, Birmingham
  £455 + VAT Members
  £505 + VAT Non-members
  Hands-on course
         

 

   
   Foundation
   Descriptive NA
   Predictive 100%
   Prescriptive
 

Create professional looking, accurate and dynamic spreadsheets to present data creatively. This course is ideal for intermediate Excel users or above who are comfortable with basic Excel functions and who wish to learn how to avoid the main pitfalls of spreadsheet design, create useful applications using simple Excel functionality, reduce the time spent analysing data and create more time to make decisions and share their spreadsheets with other users whilst ensuring consistent analysis.

Good knowledge of using Excel shortcuts is an advantage but not essential; being able to re-size and place shapes in Excel worksheets is an advantage. This course uses standard Excel functionality, formulas and tools. It requires no knowledge of visual basic.

You’ll learn:

  • How to organise data to facilitate both data input and reporting.
  • Techniques to identify data quality issues and to validate data before use.
  • How to build dashboards that summarise the data dynamically.
  • How to incorporate form controls (option buttons, tick boxes and scroll bars) into spreadsheets.
  • How to build effective visual graphics such as a speedometer and a scrolling list.

Course Provider: Simon Pegg

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