Excel - Intermediate

 

Purpose

This course will enhance your ability to manipulate data and practice functions.

Learning Outcomes

  • Use autofill to complete a series
  • Apply conditional formatting to data within cells
  • Filter data within lists
  • Apply subtotal to data within lists
  • Use absolute cell referencing
  • Use functions such as If, Countif, Sumif, Averageif
  • Link and consolidate data between worksheets
  • Apply protection to workbooks and worksheets
  • Create and format charts
  • Create templates

 

 

Audience

For anyone who has a basic knowledge of Microsoft Excel and would like to consolidate and expand their understanding and skills.

 

 

 

Method

1 day

Cost

£106.00
(Prices do not include VAT)

There are currently no dates scheduled for this course, if you would like to submit an expression of interest please contact us.