Excel 2007 Advanced Training in Ottawa on Apr 18th 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
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 Text Boxes
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
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
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
Module Ten: Grouping and Outlining Data
Viewing Grouped and Outlined Data
Module Eleven: Wrapping Up
Words from the Wise
Review of Parking Lot
Completion of Action Plans and Evaluations
After completing this course, Individuals will be able to demonstrate their understanding of:
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: 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:
- This Monday, 22nd April, 09:00 am, SAFe® 4.0 Advanced Scrum Master with SASM Certification Training in Pittsburgh PA on Apr 24th-25th 2019 in Pittsburgh
- This Monday, 22nd April, 09:00 am, Communication Strategies Training in Cincinnati, OH on Apr 22nd 2019 in Cincinnati
- This Monday, 22nd April, 09:00 am, Communication Strategies Training in Miami, Fl on Apr 22nd 2019 in Miami