Display & Accessibility Options
Excel 2003 Advanced Level 2
Microsoft Office 2003
 Next available Norwich date: 29 February 2012   |
Pivot Tables, Data Consolidation, Charting, Auditing and What if Analysis
Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Excel.
In particular, delegates will learn how to use what if analysis techniques, and perform formula auditing. Additionally to manipulate, consolidate and chart data using the various techniques, functions and facilities available with Excel including Pivot Tables.
Assumed Knowledge:
Delegates must have a good working knowledge of Excel. They must be regular users who are able to create, edit, format and print Excel spreadsheets. They must be able to use basic calculations, functions and charts. It is an advantage to have attended our Excel Advanced - Level 1 course.
Versions:
Microsoft Office 2000, 2002 and 2003
What people say:
This is the third Excel course I've been on with Jarrolds (previously completed the Intermediate and Advanced L1) and I've enjoyed all three courses very much.
I've recommended the course to other colleagues at work and they're now signed up too
HM Treasury - Jan 2011
Special Offer
Book one person onto any two levels of Excel training and receive £30 off the total price.
Profile Outline:
Goal Seek
- Changing a single cell
- Applying a global change
- Creating scenarios
- Editing scenarios
- Showing scenarios
- Summarising scenarios
- Data Table
- Creating custom views
- Using custom views
- Working with multiple sheets
- Linking files with formulas
- Paste special
- Data consolidation
Working With Text Files
- Importing text files
- Text to columns
- Text functions
Working with Lists
- Defining a range as a list
- Adding rows and colums
- Adding a total row
- Converting to a range
Data Manipulation
- Sorting data
- Using subtotals
- AutoFilter
- Advanced filter
- Conditional formatting with formulas
- Using the pivot table wizard
- Editing the pivot table
- Drilling down in a pivot table
- Lookup functions
- Cross-multiplication
- Conditional calculations
- Creating combination charts
- Plotting on a secondary axis
- Adding & removing data
- Adding trend lines
- Forecasting forward
- User defined chart types
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £165.00 
Duration: 1 day
Print Page
Norwich Dates:
-
29 February 2012
-
21 March 2012
-
25 April 2012
Links:
People who attended this course, also booked:
Information & print:
