Microsoft Excel 2007: Intermediate (1 day)

Course Overview

This course concentrates on developing your existing knowledge of Excel and includes working with more advanced formulas and functions.

In Microsoft(R) Office Excel(R) 2007: Essentials, 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.

You will learn how to get Excel to make decisions using IF functions and conditional formatting. You'll also learn how to create templates for commonly used worksheets and protect data using the security features.

This course will also enable you to create, build and customise graphs including plotting trend lines, and use Pivot Tables to help analyse data. You need to be using Excel regularly, including writing your own formulas, in order to get the most out of this course.

Microsoft is an increasing popular career choice. This Microsoft training course will help accelerate your job prospects.

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 (2 day)
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise

Audience

Anybody that has attended Microsoft Excel Essentials/Level 1 course that wishes to learn more advanced functions

Prerequisites

You must have attended the Excel 2007 Essentials course, or have participated in a training needs analysis to establish your knowledge before attending this course.

Course Outline

Calculating Data with Advanced Formulas

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable Report
• Analyze Data Using PivotCharts

Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates