An organisation development specialistLinked In

Excel Advanced 2013 / 2010 / 2007

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. Also for those wishing to analyses data using Excel as a database

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 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

  • Using Excel as a Database
  • Formatting as a Table
  • Quick Analysis (versions 2013 onwards)
  • Nested IF Statements
  • Combined Functions i.e. IF, Vlookup, And, Offset, Match, Choose
  • Sorting
  • Filtering
  • Data Validation
  • Pivot Tables
  • Slicers (versions 2010 onwards)
  • Data Models and Relationships (versions 2013 onwards)
  • Timeline
  • Forecast Sheets ((versions 2016 onwards)
  • Using Views and Creating Reports
  • Goal Seek
  • Scenarios
  • Data Tables
  • Recording a Macro
  • Assigning Macros to Buttons
  • Viewing Code
  • Editing Code
  • Linking Data with Other Applications
  • Screenshots- (versions 2010 onwards)
  • Apps for Office (versions 2013 onwards)
  • 3D

 

More