Excel 2007 Level 3
| Date |
Location |
Duration |
Cost |
| 24 Sep 2010 (Fri) | Washington | 1 | £ 165 |
| 15 Oct 2010 (Fri) | Washington | 1 | £ 165 |
| 16 Nov 2010 (Tue) | Washington | 1 | £ 165 |
| 24 Jan 2011 (Mon) | Washington | 1 | £ 165 |
| 23 Feb 2011 (Wed) | Newcastle | 1 | £ 165 |
| 18 Mar 2011 (Fri) | Washington | 1 | £ 165 |
| 18 Apr 2011 (Mon) | Newcastle | 1 | £ 165 |
| 20 May 2011 (Fri) | Washington | 1 | £ 165 |
| 24 Jun 2011 (Fri) | Washington | 1 | £ 165 |
| 27 Jul 2011 (Wed) | Newcastle | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
Course Overview
If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create PivotTables and PivotCharts, use lookup tables and import and export data.
Prerequisites
- Before starting this course, we recommended that you have attended the Excel 2007 Level 1 and 2 courses or have equivalent knowledge.
Objectives
Follow on Courses
Related Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
Course Content
Organising Data Using Tables
Creating tables
Modifying tables
Formatting tables
Outlining
Creating an Outline automatically
Creating an outline manually
Ungrouping an outline manually
Removing the Outline from a Worksheet
The outline symbol
Custom views
Creating a View of a Worksheet
Deleting a view of a worksheet
Displaying a different view
Scenario
Set up a scenario
View a scenario
Edit a Scenario
Delete a Scenario
Using tracers to help audit a worksheet
Display the Auditing Toolbar
Description of tracer arrows
Tracing Precedents and Dependents
Remove all tracer arrows
Adding a Comment to a cell
Read a comment attached to a cell
Print the comments with a Worksheet
Edit a Comment on a cell
Viewing comments all the time
Calculating Data with Advanced Formulas
Format Text Using Formulas
Perform Numeric Calculations
Calculate Data with Lookup & Reference Functions
Perform Logical Analysis
Print Formulas
Functions, including Nested IF, SUMIF, COUNTIF and COUNTBLANK function
Round: round a number to decimal places
Enter the Workbooks name, Path and worksheet name into a cell
Using VLOOKUP
Tips using VLOOKUP
HLOOKUP
Getting Started with Pivot Tables
Creating your first Pivot Table
Fields to create Row headings
Fields to create Column headings
Data in the Summary area
Dynamically building a Pivot Table
Rearranging Fields in a Pivot Table
Number formatting of the Data Area
Creating a second (or more) Pivot Table on the same data
Moving the Pivot Table from one sheet to another or around the same sheet
Deleting a Pivot Table
Formatting the Pivot Table
Autoformat
Removing AutoFormat
Grouping and Hiding of multiple row/column groupings
Pivot Table Options
Dealing with empty cells
Refreshing the Pivot Table
Activating automatic refresh options
Turning off the Summary Rows and Columns
Goal seek
Using Goal Seek to find a required result
Setting values based on a target cell
Macros
Record a Macro
Use Relative References when recording a macro
Run a Macro
Delete a Macro
Assign a Macro to a Toolbar Button
Remove a Button from a Toolbar
Assign a Macro to a Button on a Worksheet
Edit a Button on a Worksheet
Viewing the code behind a macro stored in the current workbook
Viewing the code behind a macro stored in the Personal workbook
Creating your own toolbar
Setting a security option for your macros
Print