This event has passed

Intermediate Excel

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

** 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
20 September 2017
GMT Daylight Time
Venue
Zetland Square Dundas St Richmond DL10 7BP UK