€751.17 – €1,075.16

Multiple Dates

Excel 2007 Advanced 1 Day Training in Cork

Event Information

Share this event

Date and Time

Location

Location

Regus - Cork City Gate

Bldg 1000, Units 1201 & 1202, City Gate

T12 W7CV Cork

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description
This workshop will teach the participants the advanced features of Microsoft Excel 2007.

About this Event

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 a 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

Prerequisites:

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

Agenda:

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

Share with friends

Location

Regus - Cork City Gate

Bldg 1000, Units 1201 & 1202, City Gate

T12 W7CV Cork

Ireland

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved