Advanced Excel

27 September 2017
A course for those who already have user knowledge of Excel and are familiar with creating and editing formulas and feel confident in exploring the advanced features in Excel

Course Aims:

 

To gain further knowledge and understanding of the many powerful features available in Excel.

Course Content:

  • Quick Access Toolbar
  • Quick Tips & Techniques
  • Linking between worksheets & workbooks
  • Group & Outline
  • Data validation
  • Pivot Tables, Charts & Slicers
  • Goal Seek
  • Scenario Manager
  • Conditional Formatting
  • Auditing & Tracing Errors
  • Watch Windows 
  • Sparklines
  • If Functions
  • Nested If
  • Horizontal & Vertical Lookups
  • Advanced Filters
  • Data Forms
  • Macros
  • Print Area
  • Cell Comments
Date / Time
27 September 2017
GMT Daylight Time
Venue
Zetland Square Dundas St Richmond DL10 7BP UK

Advanced booking is required to attend this event.

  • Early Bird Discount: £110
  • Standard Rate: £195
  • One Attendee on all 3 Excel Courses: £300