Intermediate Excel

16 June 2017
A course for those who already have a knowledge of using Excel and are familiar with creating spreadsheets and editing formulas.

Early Bird discount available, if booked by 5th June 2017 - Just £110. Book Here.


Course Aims:

To gain further knowledge and understanding of absolute referencing, more complex formulas, macros and using Excel as a database.

Course Content:

Tips & Techniques –copying, moving, selecting, cells.

  • Fill Series
  • Inserting/Deleting Multiple Rows & Columns
  • Multiple Column Width Adjustment

Ranges

  • Naming, Deleting Ranges and including Cell Ranges in Formulas
  • Custom Lists – create your own list
  • Calculating cells in multiple areas, Sub Totals & Grand Totals
  • Creating, Moving, Renaming Sheet Tabs

Formulas

  • Summary sheets - calculating between worksheets
  • Sheets – Printing Selected/Individual & Duplicating Data
  • Paste Function
  • Absolute Referencing in formulas
  • If Function
  • V Lookup Function
  • Rounding
  • Macros

Database

  • Filtering Data
  • Conditional Formatting

Chart Manipulation

  • Creating
  • Editing
  • Presenting Charts
Date / Time
16 June 2017
GMT Daylight Time
Venue
Zetland Square Dundas St Richmond DL10 7BP UK

Advanced booking is required to attend this event.

  • Early Bird Rate: £110
  • Standard Rate: £195