Display & Accessibility Options
Excel 2007 Advanced Level 2
Microsoft Office 2007
 Next available Norwich date: 08 October 2010   |
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 work with tables in Excel, including pivot tables and lookup functions. Additionally to consolidate data and enhance presentation with scenarios and custom views.
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.
Version:
Microsoft Office 2007
Special Offer
Book one person onto any two levels of Excel training and receive £30 off the total price.
Profile Outline:
Course Introduction and Revision
- Revision exercise
- Changing a single cell
- Applying a global change
- Creating scenarios
- Editing scenarios
- Showing scenarios
- Summarising scenarios
- Creating custom views
- Using custom views
- Working with multiple sheets
- Linking files with formulas
- Paste special
- Data consolidation
- Importing text files
- Text to columns
- Text functions
- Defining and formatting a table
- Table features
- Switch between table and cell referencing
- Removing duplicates
- Converting to a range
Conditional Formatting
- Applying predefined rules
- Editing predefined rules
- Creating new rules
- Managing rules
- Sorting data
- Using subtotals
- Filter
- Advanced filter
- Creating a pivot table
- 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
- Chart templates
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £165.00 
Duration: 1 day
Norwich Dates:
-
08 October 2010
-
02 December 2010
Links:
People who attended this course, also booked:
Information & print:
