Intermediate Excel

07 February 2018
A course for those who already have a knowledge of using Excel and are familiar with creating spreadsheets and editing formulas.

** EARLY BOOKING JUST £110 - Expires 22nd January 2018 - 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

Special Offer:

Book on to all three Excel courses:-

  • Introduction to Excel - 24th January 2018
  • Intermediate Excel - 7th February 2018
  • Advanced Excel - 21st February 2018

For Just £300. (This deal is non-transferable and expires 8th January 2018)

Date / Time
07 February 2018
GMT Standard 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