Excel 2007 Level 2
| Date |
Location |
Duration |
Cost |
| 06 Oct 2010 (Wed) | Washington | 1 | £ 165 |
| 10 Nov 2010 (Wed) | Washington | 1 | £ 165 |
| 13 Dec 2010 (Mon) | Washington | 1 | £ 165 |
| 11 Feb 2011 (Fri) | Washington | 1 | £ 165 |
| 25 Mar 2011 (Fri) | Newcastle | 1 | £ 165 |
| 27 Apr 2011 (Wed) | Washington | 1 | £ 165 |
| 25 May 2011 (Wed) | Washington | 1 | £ 165 |
| 17 Jun 2011 (Fri) | Washington | 1 | £ 165 |
| 22 Jul 2011 (Fri) | Washington | 1 | £ 165 |
| 18 Aug 2011 (Thu) | Washington | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
Course Overview
In Microsoft Office Excel 2007 Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Prerequisites
- Before starting this course, we recommended that delegates have attended the Excel 2007 Level 1 course 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
Recap of Introduction Level 1
AutoSum and simple formulae
Calculating Data with Formulas
Referring to a range of cells
Calculating data across worksheets
Using various functions, including: SUM, AVERAGE, COUNT, COUNTA, IF, MAX, MIN
Performing date and time calculations, including: DATEDIF, YEAR, MONTH, DAY, TEXT
Printing formulas
Using Absolute Referencing
Naming cells (Ranges)
Linking within a workbook
Linking within a workbook
Simple referencing in a worksheet
Calculating across multiple sheets using 3D-Referencing
Formatting
Conditional Formatting
Customising an Excel worksheet
Enhancing worksheets using themes
Working with comments
Protecting a workbook or worksheet
AutoFill (using existing lists and creating your own custom lists)
Security
Protecting a worksheet
Protecting a workbook
Creating Workbooks Using Templates
Creating a workbook from a template
Creating a custom template
Using Graphic Objects
Inserting and modifying graphic objects
Emphasise an area of a worksheet
Illustrate workflow using SmartArt graphics
Formatting graphic objects
Changing the order of layered graphic objects
Grouping graphic objects
Organising graphic objects
Sorting and Filtering Data
Sorting data in a spreadsheet
Filtering data in a spreadsheet
Calculating large volumes of data
Adding subtotals to a worksheet
Presenting Data Using Charts
Creating a chart
Modifying charts
Formatting charts
Print