Intermediate Microsoft Excel 2007 / 2010
Event type: Mastercourse
Learn how to use the new and improved conditional formatting with this MS Excel course.
|
Date
|
Location
|
Price
|
|
|
23 May 2013 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
4 June 2013 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
14 June 2013 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
26 June 2013 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
Who will benefit
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
- decision 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 precedents and cell dependents
- count functions
- auditing worksheets
- locate invalid data and formulas.
General information
This course is organised by Reed Learning and endorsed by CIMA Mastercourses as suitable for members and their staff and colleagues.
This course starts at 9.30am. Lunch and refreshments are provided.
6 CPD hours (where applicable)
CIMA Mastercourses held in partnership with BPP
Find out more
If you have any queries please email or phone us on +44 (0)845 026 4722.
CIMA on demand
CIMA on demand is a high quality online professional development solution, specifically designed for busy finance and business professionals. Find out more.
Prerequisites
A working knowledge of Excel introduction topics.