Tel: UK 0845 757 3888 | Ireland: 01 284 6796
Microsoft Excel 2007 Level 2
Course type Essentials (What does this mean?)
| Course title | Microsoft Excel 2007 Level 2 |
|---|---|
| Delivery method |  Classroom |
| RRP | £280 exc. VAT |
| Days/Duration | 1 |
| Code | DEX07L2 |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
King William Street, EC4 |- |6 |- |- 
Location Sep Oct Nov Dec view earlier dates King William Street, EC4 |- |- |- |- King William Street, EC4location information and directions
06 Jun fewer than 5 places available £280 exc VAT Microsoft Excel 2007 Level 2 training in King William Street, EC4
Middlesex Street, E1 |28 |12 |20 |15 Location Sep Oct Nov Dec view earlier dates Middlesex Street, E1 |3 |10 |21 |11 Middlesex Street, E1location information and directions
28 May limited availability £280 exc VAT 
12 Jun limited availability £280 exc VAT 20 Jul limited availability £280 exc VAT 15 Aug 5 or more places available £280 exc VAT 03 Sep 5 or more places available £280 exc VAT 10 Oct 5 or more places available £280 exc VAT 21 Nov 5 or more places available £280 exc VAT 11 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Middlesex Street, E1
Rosebery Avenue, EC1 |- |21 |9 |- Location Sep Oct Nov Dec view earlier dates Rosebery Avenue, EC1 |- |- |- |- Rosebery Avenue, EC1location information and directions
21 Jun 5 or more places available £280 exc VAT 09 Jul 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Rosebery Avenue, EC1
Midlands
Birmingham |- |14 |- |15 Location Sep Oct Nov Dec view earlier dates Birmingham |- |22 |- |13 Birminghamlocation information and directions
14 Jun fewer than 5 places available £280 exc VAT 15 Aug 5 or more places available £280 exc VAT 22 Oct 5 or more places available £280 exc VAT 13 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Birmingham
North
Manchester |- |11 |9, 18 |8, 31 Location Sep Oct Nov Dec view earlier dates Manchester |6 |1 |2 |4 Manchesterlocation information and directions
11 Jun fewer than 5 places available £280 exc VAT 09 Jul 5 or more places available £280 exc VAT 18 Jul 5 or more places available £280 exc VAT 08 Aug fewer than 5 places available £280 exc VAT 31 Aug 5 or more places available £280 exc VAT 06 Sep 5 or more places available £280 exc VAT 01 Oct 5 or more places available £280 exc VAT 02 Nov 5 or more places available £280 exc VAT 04 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Manchester
Newcastle |- |- |- |10 Location Sep Oct Nov Dec view earlier dates Newcastle |- |- |- |- Newcastlelocation information and directions
10 Aug 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Newcastle
Leeds, City Centre |28 |27 |18 |16 Location Sep Oct Nov Dec view earlier dates Leeds, City Centre |12 |12 |5 |13 Leeds, City Centrelocation information and directions
28 May limited availability £280 exc VAT 27 Jun 5 or more places available £280 exc VAT 18 Jul 5 or more places available £280 exc VAT 16 Aug 5 or more places available £280 exc VAT 12 Sep 5 or more places available £280 exc VAT 12 Oct 5 or more places available £280 exc VAT 05 Nov 5 or more places available £280 exc VAT 13 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Leeds, City Centre
Scotland
Edinburgh |- |- |26 |22 Location Sep Oct Nov Dec view earlier dates Edinburgh |- |3 |21 |- Edinburghlocation information and directions
26 Jul 5 or more places available £280 exc VAT 22 Aug 5 or more places available £280 exc VAT 03 Oct 5 or more places available £280 exc VAT 21 Nov 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Edinburgh
Glasgow |- |21 |23 |9 Location Sep Oct Nov Dec view earlier dates Glasgow |- |1 |21 |- Glasgowlocation information and directions
21 Jun 5 or more places available £280 exc VAT 23 Jul 5 or more places available £280 exc VAT 09 Aug 5 or more places available £280 exc VAT 01 Oct 5 or more places available £280 exc VAT 21 Nov 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Glasgow
South
Bristol |- |22 |- |20 Location Sep Oct Nov Dec view earlier dates Bristol |- |- |- |11 Bristollocation information and directions
22 Jun fewer than 5 places available £280 exc VAT 20 Aug 5 or more places available £280 exc VAT 11 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Bristol
Milton Keynes |- |25 |- |- Location Sep Oct Nov Dec view earlier dates Milton Keynes |3 |- |- |14 Milton Keyneslocation information and directions
25 Jun 5 or more places available £280 exc VAT 03 Sep 5 or more places available £280 exc VAT 14 Dec 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Milton Keynes
Reading |- |- |27 |- Location Sep Oct Nov Dec view earlier dates Reading |- |30 |- |- Readinglocation information and directions
27 Jul 5 or more places available £280 exc VAT 30 Oct 5 or more places available £280 exc VAT Microsoft Excel 2007 Level 2 training in Reading
Overview
In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Prerequisites
- Create basic spreadsheets
- Select and edit data
- Perform basic formatting
- Open, close and save files
- Create basic formulas – AutoSum
- Use Insert Function to create built-in functions
- Work with absolute references
- Use the Autofill feature
Delegates will learn how to
- calculate with advanced formulas
- organise worksheet and table data using various techniques
- create and modify charts
- analyse data using PivotTables and PivotCharts
- insert graphic objects
- customise and enhance workbooks and the Microsoft Office Excel environment
Course Outline
Lesson 1: Calculating Data with Advanced Formulas
- Topic 1A: Manage Cell and Range Names
- Topic 1B: Calculate Data Across Worksheets
- Topic 1C: Use Specialized Functions
- Topic 1D: Analyze Data with Logical and Lookup Functions
Lesson 2: Organizing Worksheet and Table Data
- Topic 2A: Create and Modify Tables
- Topic 2B: Format Tables
- Topic 2C: Sort or Filter Worksheet or Table Data
- Topic 2D: Calculate Data in a Table or Worksheet
Lesson 3: Presenting Data Using Charts
- Topic 3A: Create a Chart
- Topic 3B: Modify Charts
- Topic 3C: Format Charts
Lesson 4: Analyzing Data Using PivotTables and PivotCharts
- Topic 4A: Create a PivotTable Report
- Topic 4B: Analyze Data Using PivotCharts
Lesson 5: Inserting Graphic Objects
- Topic 5A: Insert and Modify Pictures and ClipArt
- Topic 5B: Draw and Modify Shapes
- Topic 5C: Illustrate Workflow Using SmartArt Graphics
- Topic 5D: Layer and Group Graphic Objects
Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment
- Topic 6A: Customize the Excel Environment
- Topic 6B: Customize Workbooks
- Topic 6C: Manage Themes
- Topic 6D: Create and Use Templates
Related blogs
Do a better Disk Cleanup as Administrator
Posted by Andrew Mallett on 14 May 2012
Many of us will know the Windows 7 Disk Cleanup feature but how many of us miss some features by not running as an administrator?
I know the name but what is the printer driver
Posted by Andrew Mallett on 09 May 2012
SUPPORT: “Which printer is it?” USER: “Darth Vader” Of course naming your printers other than by the print driver is useful and more fun for you users but does not really help you identify the printer. See how PowerShell can help you out....
what are you wearing
Posted by Bob Simms on 03 May 2012
Data mining and its use in business, or how to stop those annoying phone calls
What are your time stealers?
Posted by Jennie Marshall on 02 May 2012
I frequently facilitate learning sessions on time management, and one common theme for many, in this age of higher expectations on staff, is increased work load. But is it really more work that’s affecting our ability to be productive, or are we experiencing more ‘time stealers’ than we used to.
Windows : Open a command window to a directory
Posted by Andrew Mallett on 01 May 2012
Some things in both life and IT are simple and this is one of those items. Have you ever wanted to open the command window to a folder that you have navigated to with Windows Explorer? Read on help is at hand.
