What You'll Learn

After completing this module, students will be able to:

• Define an alternative data set
• Define multiple alternative data sets
• Vary data to get a desired result by using Goal Seek
• Find optimal solutions by using Solver
• Analyse data by using descriptive statistics
• Analyse data dynamically by using PivotTables
• Filter, show, and hide PivotTable data
• Edit PivotTables
• Format PivotTables
• Create PivotTables from external data
• Create dynamic charts by using PivotCharts.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

 

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

 

Course Outline

Lesson 1: Data Analysis

This lesson explains how to define alternative data sets, use Goal Seek and Solver, and analyze descriptive statistics:

• Defining an Alternative Data Set
• Defining Multiple Alternative Data Sets
• Varying Your Data to Get a Desired Result by Using Goal Seek
• Finding Optimal Solutions by Using Solver
• Analyzing Data by Using Descriptive Statistics

Lab : Data Analysis

• Create a scenario to measure the impact of a rate increase.
• Create and summarize the results of two scenarios.
• Use Goal Seek to find a target value.
• Use Solver to determine the best values for multiple variables, given specific constraints.
• Generate descriptive statistics by using the Analysis ToolPak.

Lesson 2: PivotTables and PivotCharts

This lesson explains how to work with PivotTables and PivotCharts.

• Analyzing Data Dynamically by Using PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data
• Creating Dynamic Charts by Using PivotCharts

Lab : PivotTables and PivotCharts

• Create a PivotTable, add fields, and then pivot it.
• Filter a PivotTable, and show and hide levels of detail.
• Rename and edit a PivotTable, and then link to a PivotTable cell.
• Apply a number format, styles, banded rows, and a conditional format to a PivotTable.
• Use an imported text file as the basis for a PivotTable.
• Create, modify, and update a PivotChart.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com. 

Getting Certified

You may wish to consider the following MCAS certification associated with Microsoft Office Excel 2007:

• Microsoft Certified Application Specialist: Microsoft Office Excel 2007

To gain this certification, students need to pass Exam 77-602: MCAS: Using Microsoft Office Excel 2007.

Candidates for this exam should have the equivalent of six months to one year of hands-on experience creating business deliverables with Microsoft Office Excel 2007 and might have experience with previous versions of Microsoft Office Excel. These candidates are especially effective and efficient at creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

 

Is This Training Programme Right For You?

This course is intended for experienced information workers who want to learn advanced-level Excel 2007 skills.

Prerequisites

Before attending this course, students must have:

• Basic computer knowledge
• Basic file-management skills
• Basic knowledge of the Excel interface, workbook manipulation, and formula creation

For more information, or to book your place, please call us on +44 (0)117 906 5660, start a LiveChat or email us at info@retendotraining.com.

Ask Us A Question

Live Chat

Why not ask one of our knowledgeable team to answer your question using our Live Chat?

Call Us

Our team are also on standby to answer your questions over the phone. Just call 0117 230 9689 now!