Excel 2007 Level 2

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

Delegates will be able to :

• Test a value in a specific cell to see if it meets a required criteria and display a warning in a cell if the data does not meet the required criteria.
• Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data i.e. Maybe an expenses sheet that takes the monthly totals and displays them on a summary sheet.
• Filter a spreadsheet to show only the records that meet a specific criteria i.e. All surnames beginning with A.
• Display data in various graphical formats that can be easily understood by anyone not using Excel.

Follow on Courses

• Excel 2007 Level 3

Training Options

• Bespoke course (a 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
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• 1 delegate per computer
• 12 Months telephone and email support
• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• Lunch (When at our training venue)
• Refreshments (When at our training venue)
• Relaxed refreshment area at our training room

Course Content
Recap of Introduction Level 1

• AutoSum and simple formulae

Calculating Data with Formulas

• Refering to a range of cells
• Calculating data across worksheets
• Using various functions
• Performing date and time calculations
• Formatting text using formulas
• Performing numeric calculations
• Printing formulas

Linking within a workbook

• Linking within a workbook
• Simple referencing in a worksheet
• Using the Sum function in referencing

Enhancing workbooks

• AutoFormats
• Customising the Excel environment
• Customising an Excel worksheet
• Enhancing worksheets using themes
• Working with comments
• Naming cells and ranges
• Protecting a workbook or worksheet
• AutoFill (using existing lists and creating your own custom lists)
• Adding comments to cells on a worksheet

Creating Workbooks Using Templates

• Creating a workbook from a template
• Creating a custom template

Enhancing Visual Appeal 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