Search results for:
No result found! Try with different keywords!

Excel 2007 Advanced 1 Day Training in Cape Town


Excel 2007 Advanced 1 Day Training in Cape Town

Course  Overview:

Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.

This workshop will teach the participants the most common advanced features of Microsoft Excel 2007. The goal of this course is to get them familiar with these functions in a safe learning environment. Once it is completed, their familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for everyone at work or at home.

Target Audience:

Anybody who is interested in learning Excel 2007 Advanced

Learning Objectives:

After completing this course, Individuals will be able to demonstrate their understanding of:

Smart Art

Inserting Objects

Creating Charts

Creating Pivot Tables

Working with Pivot Tables

Creating Pivot Charts

Solving Formula Errors

Using What-If Analysis

Managing Your Data

Grouping and Outlining Data


Basic Knowledge in Excel 2007

Course Materials:

Attendees will receive a course manual with presentation slides and reference materials.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions


Module One: SmartArt

Inserting SmartArt

An Overview of the SmartArt Tabs

Adding Text to the Diagram

Resizing and Moving the Diagram

Resetting the Diagram

Module Two: Inserting Objects

About Contextual Tabs

Adding Pictures from Your Computer

Adding ClipArt

Adding Text Boxes

Drawing Shapes

Module Three: Creating Charts

Inserting a Chart

Overview of the Chart Tools Tabs

Understanding the Parts of a Chart

Changing the Chart Style

Resizing and Moving the Chart

Module Four: Creating Pivot Tables

Inserting a Pivot Table

Overview of the Pivot Table Tools Tab

Choosing Fields

Module Five: Working with Pivot Tables

Changing the Data Displayed

Applying a Style to Your Pivot Table

Some Real-life Examples

Module Six: Creating Pivot Charts

Creating a Pivot Chart from a Pivot Table

Creating a Pivot Chart from Data

Module Seven: Solving Formula Errors

Using Named Ranges

Understanding Formula Errors

Tracing Dependents and Precedents

Using the Trace Errors Commands

Evaluating Formulas

Module Eight: Using What-If Analysis

Using Goal Seek

Using the Scenario Manager

Using a One Input Data Table

Using a Two Input Data Table

Module Nine: Managing Your Data

Transposing Data from Rows to Columns

Using the Text to Columns Feature

Checking for Duplicates

Creating Data Validation Rules

Consolidating Data

Module Ten: Grouping and Outlining Data

Grouping Data

Adding Subtotals

Outlining Data

Viewing Grouped and Outlined Data

Module Eleven: Wrapping Up

Words from the Wise

Review of Parking Lot

Lessons Learned

Completion of Action Plans and Evaluations

Ticket Information Ticket Price
Early bird registration EUR 695
standard registration EUR 995

You may also like the following events from Mangates:

Map Regus - Cape Town, Mandela Rhodes Place, 7th Floor, Mandela Rhodes Place Corner Wale Street and, Burg S, Cape Town, South Africa
Event details from Report a problem

Are you going to this event?

Tickets from EUR 695 to 995 on

More Events in Cape Town

Explore More Events in Cape Town