Intermediate Microsoft Excel 2007™

Event type: Mastercourse

Learn how to use the new and improved conditional formatting with this MS Excel course

New for 2012

Date Location Price  
13 June 2012 - 09:30 London Price: GBP 199.00
+ VAT
28 June 2012 - 09:30 London Price: GBP 199.00
+ VAT
11 July 2012 - 09:30 London Price: GBP 199.00
+ VAT
25 July 2012 - 09:30 London Price: GBP 199.00
+ VAT
7 August 2012 - 09:30 London Price: GBP 199.00
+ VAT
21 August 2012 - 09:30 London Price: GBP 199.00
+ VAT
7 September 2012 - 09:30 London Price: GBP 199.00
+ VAT
20 September 2012 - 09:30 London Price: GBP 199.00
+ VAT
3 October 2012 - 09:30 London Price: GBP 199.00
+ VAT
16 October 2012 - 09:30 London Price: GBP 199.00
+ VAT
29 October 2012 - 09:30 London Price: GBP 199.00
+ VAT
9 November 2012 - 09:30 London Price: GBP 199.00
+ VAT
23 November 2012 - 09:30 London Price: GBP 199.00
+ VAT
5 December 2012 - 09:30 London Price: GBP 199.00
+ VAT
20 December 2012 - 09:30 London Price: GBP 199.00
+ VAT

Who will benefit

This course is sutiable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel 2007 and are looking to expand this.

What you can gain

  • know-how to protect your data using the security features
  • automation of worksheets using Excel 2007 look up features
  • improved interpretation of data by learning to create and customise graphs, including plotting trend lines
  • decison making skills using the 'if' function and conditional formatting.

Speaker Details

This course is run by Reed Learning.

Outline

  • setting up entire workbooks with group editing
  • analysing filtered data using the subtotal function
  • using lookup statements
  • linking spreadsheets and workbooks
  • 'if' statements and calculations
  • all new conditional formatting features
  • sorting and filtering data
  • attaching security to a spreadsheet
  • setting up and utilising templates
  • utilising custom chart types
  • trace cell precendents and cell dependents
  • count functions
  • auditing worksheets
  • locate invalid data and formulas.

This course, which is run by Reed Learning, is endorsed by CIMA as suitable for members and their colleagues.

6 CPD hours for non members.

Prerequisites

A working knowledge of Excel introduction topics.