Display & Accessibility Options
Excel 2010 Advanced Level 2
Microsoft Office 2010
 Next available Norwich date: 24 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 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 2010
What people say:
Excellent day. Thouroughly enjoyed the course. Joyce was extrememly helpful and informative, as were other staff. Look very much forward to undertaking further courses with Jarolds.
3Sun Ltd - Sep 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
- 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 and editing predefined rules
- Using icon sets and data bars
- 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
Profile Details:
-
Price: £165.00 
Duration: 1 day
Print Page
Norwich Dates:
-
24 February 2012
-
15 March 2012
-
20 April 2012
Links:
People who attended this course, also booked:
Information & print:
