An organisation development specialistLinked In

Excel Advanced 2010

Duration 1 day


Designed for

Power users or those who typically would produce spreadsheets of a more complicated nature and who wish to further develop their skills

Pre-requisites

Delegates attending this course should have a good understanding of the basics and be able to confidently demonstrate them.

A pre-course questionnaire is available for delegates to confirm their existing knowledge before attending this programme

Course Aims

The aim of this course is to develop delegates’ usage of Excel to the highest level and enable them to utilise the Add-ins in order to produce sophisticated reports containing relevant information. The power and adaptability of macros will also be practiced in order for delegates to return to their own environments with an all round knowledge and understanding of the software

Course Content

  • Pivot Tables
  • Slicers
  • Goal Seek
  • Solver
  • Scenarios
  • Using Views and Creating Reports
  • Consolidating Data
  • Auditing Tools
  • Recording a Macro
  • Assigning Macros to Buttons
  • Viewing Code
  • Editing Code
  • Linking Data with Other Applications
  • Screenshots
  • User Defined Functions
  • On-Sheet Controls
More