Intermediate Microsoft Excel XP/2003™
Event type: Mastercourse
Expand your knowledge of MS Excel with this course.
New for 2012
A natural progression from our introductory course that provides expert guidance through more complex functions and plenty of practice and examples to build confidence using them.
|
Date
|
Location
|
Price
|
|
|
29 May 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
12 June 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
22 June 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
5 July 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
16 July 2012 - 09:30
|
Edinburgh
|
Price: GBP 199.00
+ VAT
|
|
|
19 July 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
20 August 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
3 September 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
14 September 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
27 September 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
11 October 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
11 October 2012 - 09:30
|
Edinburgh
|
Price: GBP 199.00
+ VAT
|
|
|
25 October 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
7 November 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
20 November 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
30 November 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
|
14 December 2012 - 09:30
|
London
|
Price: GBP 199.00
+ VAT
|
|
Who will benefit
This course is suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel and are looking to expand this. Please note that this course is suitable for delegates using Windows XP or 2000 versions.
What you can gain
- Know how to protect your data using the security features
- Achieve automation of worksheets using excel look up features
- Improved interpretation of data by learning to create and customise graphs, including plotting trend lines
- Learn how Excel can make decisions using the 'if' function and conditional formatting
Speaker Details
This course is run by Reed Learning.
Outline
- Review of Excel fundamentals
- Building 3 dimensional worksheets
- Worksheet templates
- Protection and security
- Grouping worksheets
- Data tables and lookup functions
- Introduction to the 'if' function
- Group and outline functions
- Building graphs and using trend lines
- Database features including sorting and filtering data
- Methods to validate data
- Colours based on values (getting Excel to change the formatting characteristics based on the cell contents)
This course, which is run by Reed Learning, is endorsed by CIMA as suitable for members and their colleagues.
6 CPD hours for non CIMA members.
Prerequisites
A working knowledge of Excel introduction topics.