Excel 2007 Level 2 Intermediate

Public Course Dates

	Date	Location
	Thu, 23 May 2013	Reading
	Thu, 18 Jul 2013	Reading
	Thu, 12 Sep 2013	Reading
	Thu, 7 Nov 2013	Reading

This course is available as a public course at our Reading training centre.

£225 for 1 day

Included in the price:

Comprehensive Manual
Refreshments & Lunch
Post Course Support

Course Description
Course Outline

Course Overview

With Microsoft Office Excel 2007: Level 1, you have learned it is possible to manage your data. It is time to take your workbooks and spreadsheets to the next step by streamlining some tasks and making your data easier to comprehend by creating a more visually dynamic display. In this course, you will use Microsoft Office Excel 2007 to restructure and to enhance your spreadsheets with options such as advanced formulas, charts, graphics, and pivot tables.

Course Objective

Learn to apply visual elements and advanced formulas to a worksheet to display data in other formats and to streamline repetitive tasks.

Target student

Anyone wishing to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web will benefit from this course. Additionally, this course is beneficial to the student who intends to take the Microsoft Office Specialist exam in Excel and who already has a working knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites

The Systematix course Microsoft Office Excel 2007: Level 1 or equivalent knowledge is recommended to obtain full benefit of this course.

We offer a range of Excel training courses

Calculating Data with Advanced Formulas
Analyze Data with Logical and Lookup Functions Calculate Data Across Worksheets Manage Cell and Range Names Use Specialized Functions
Organizing Worksheet and Table Data
Calculate Data in a Table or Worksheet Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data
Presenting Data Using Charts
Create a Chart Format Charts Modify Charts
Analyzing Data Using PivotTables and PivotCharts
Analyze Data Using PivotCharts Create a PivotTable Report
Inserting Graphic Objects
Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Insert and Modify Pictures and ClipArt Layer and Group Graphic Objects
Customizing and Enhancing Workbooks and the Excel Environment
Customize Workbooks Customize the Excel Environment Manage Themes

Publisher:	Microsoft
Version:	2007
Length:	1 day
Course-ID:	084891

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The course trainer was excellent. She spent time with individuals, explaining any problems experienced

- Siemens