An organisation development specialistLinked In

Excel Intermediate 2013 / 2010 / 2007

Duration 1 day

Designed for

Users wishing to extend their knowledge of the features and functions available within this program

Pre-requisites

Delegates should have attended the introductory course or have gained similar knowledge and experience in the workplace

Course Aims

By the end of this course delegates will be able to build complex spreadsheets which link via formulae, together with being able to construct functions which incorporate logic into the statement. An element of automation is also examined so that repetitive sheets can be recreated with minimal effort. Delegates will also be shown the ‘database’ capabilities and be able to manipulate data to give various outputs.

Course contents

  • Customising Quick Access Toolbar
  • Customising Ribbons
  • Freezing panes
  • Notes
  • Themes and Styles
  • Templates/Auto Templates
  • Multiple Worksheets -v- Multiple Workbooks
  • Group editing
  • 3D Formulas
  • Linking Worksheets/Workbooks 
  • Protection
  • Consolidating Data
  • Auditing Tools
  • Watch Window
  • FlashFill (versions 2013 onwards)
  • Text to Columns
  • Concatenation
  • IF Functions
  • Date/Time Functions
  • Lookup Functions
  • Sparklines (versions 2010 onwards)

 

 

More