Microsoft Excel 2007/2010: Intermediate

Course Overview

This course is intended to allow people with an existing knowledge of working with basic spreadsheets within Excel to move on to the next level of ability including working with more complex spreadsheets, analysing and presenting data.

For those Microsoft students looking to improve their skills with Excel, this Microsoft training course would be a good start.

Related Courses

• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007: Intermediate (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Intermediate and Advanced Training Course

Audience

This course is for people who wish to expand on their current knowledge of Microsoft Excel. Anyone attending the course should either have attended Excel Foundation, or have and equivalent knowledge.

Skills Gained

Course Aims to enable delegates to:

Produce more professional spreadsheets and charts using Microsoft Excel and build on existing knowledge to manipulate and analyse data. The training is designed for existing Excel users wanting to increase their skills.

Course Outline

Working with Large Spreadsheet

• View options
• Hiding/displaying data
• Printing large worksheets

Working with Multiple Worksheets

• Using multiple worksheets
• Linking worksheets by using 3-D formulas
• Managing workbooks

Advanced Formulae

• Logical Statements
• Lookups

Documenting and Auditing

• Comments and Text Boxes
• Auditing features
• Protecting cells

List Management

• Creating lists
• Sorting and filtering
• Lists
• Advanced filtering

Advanced Formatting

• Borders and shading
• Special number formats
• Dates
• Styles
• Conditional formatting

Customizing Excel

• Formatting chart options
• Adding graphic elements