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

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

Excel 2007 Advanced Training in Columbia, MD on Apr 19th 2019

Advertisement

Excel 2007 Advanced Training in Columbia, MD on Apr 19th 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:


SmartArt

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


FAQs

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: www.mangates.com

 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 Columbia, United States
Loading venue map..
Event details from Report a problem

Are you going to this event?

Advertisement