Search results for:
No result found! Try with different keywords!
Oh Snap, this is a past event! 😵

Do you want to get notified when this event happens again?

Excel 2007 Advanced Training in Cincinnati, OH on Apr 5th 2019


Excel 2007 Advanced Training in Cincinnati, OH on Apr 5th 2019

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.

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

Learning Objectives:

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


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


What can/can't I bring to the event?

Open mind and lots of energy

 Where can I contact the organizer with any questions?

Email: aW5mbyB8IG1hbmdhdGVzICEgY29t PH: 469-666-9332

 Is my registration/ticket transferrable?

Yes, you may transfer your ticket to other participants 7 days prior to the class.

 Can I update my registration information?

Yes, you will be able to change your e-mail or name during the class.

 What is the refund policy?

Please refer to:

 The name on the registration/ticket doesn't match the attendee. Is that okay?

Yes, we will be able to change it during the class. 

For more details Visit Mangates

You may also like the following events from Mangates:

Map Cincinnati, United States
Loading venue map..
Event details from Report a problem

Are you going to this event?