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

Excel 2007 Advanced 1 Day Training in Cape Town

Advertisement

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



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

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 eventbrite.co.uk
Advertisement

More Events in Cape Town

Explore More Events in Cape Town