Microsoft Excel 2007: Intermediate (2 day)

Course Overview

Excel 2007 gives professionals and everyday users the powerful tools necessary for getting the most out of their data. This course is designed for those users who wish to progress their current knowledge of Excel to include the more complex features.

Some Microsoft courses can also be delivered in-house or at a venue of your choice, please click here to send an enquiry and find out more

Related Courses

• Microsoft Excel 2007: VBA Introduction
• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise

Audience

Anyone wishing to use Excel to organise data and perform more complex calculations.

Skills Gained

To be able to create, edit, and format a spreadsheet. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists and create custom charts. This course will enable delegates to:

• Work effectively with the Database facilities.
• Use formula and functions.
• Build and format spreadsheets.
• Create and format charts.

Prerequisites

This course is designed for students who have completed the Excel 2007 Fundamental course or have equivalent knowledge.

Course Outline

Working with Large Worksheets

• Viewing Options.
• Hiding and Displaying Data.
• Printing Large Worksheets.

Working with Multiple Worksheets

• Using Multiple Worksheets.
• Linking Worksheets by Using 3-D Formulas.
• Managing Workbooks.
• Data Consolidation.
• Linking across Applications.

Formulae

• Sumif and Countif.
• Round and Intege.
• Lookups and Named Ranges.
• Logical Statements.
• And and Or.
• Index and Match.
• Subtotal Function.
• Is Functions.
• Text and Date.

Advanced Charting

• Chart Formatting Options.
• Creating Combination Charts.
• Using Graphic Elements.

List Management

• Introducing Lists.
• Sorting and Filtering Lists.
• Advanced Filtering.
• Custom Lists.
• Text to Columns.
• Custom Views.

Advanced Formatting

• Borders and Shading.
• Using Special Number Formats.
• Working with Dates.
• Working with Styles.
• Conditional Formatting.
• Other Advanced Formatting.

Notation and Auditing

• Comments and Text Boxes.
• Auditing Features.
• Data Validation.
• Protection.
• Workgroup Collaboration.

Customising Excel

• Changing Options.
• Customising Toolbars and Menus.