Excel 2007 Advanced Training

Training Summary

Certificate: No Certification

Duration: 1 Day

Course Delivery: Classroom / Virtual

Language: English

Credits: 8

Training Highlights

  • High quality training from Certified & Industry Experts
  • Earn 8 PDUs and 8 SEU’s
  • Course Completion Certificates
  • Reimbursement guaranteed if the training is not satisfied
  • Extensive documentation provided

Our approach is both practical and inspirational.Our training is carefully designed and tested to develop the key skills and confidence needed while being highly participatory and fun

Course Overview

In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros.

Course Description See Below

Course Description:

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.

Course Outline:

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
Once after the training you receive course completion certificate from Mangates
Anybody who is interested in learning Excel 2007 Advanced Skills
What Does Mangates provide me on the day of the course?

We provide Course Materials, Course Completion Certificate and Refreshements

What experience does Instructor has?

All our Instructors are Certified & Industry Experts and they have years of experience in teaching Agile Courses

What Does Mangates provide me on the day of the course?

We provide Course Materials, Course Completion Certificate and Refreshements

What experience does Instructor has?

All our Instructors are Certified & Industry Experts and they have years of experience in teaching Agile Courses

Does this course includes exam?

This course does not include exams as this is non-certifications course. once after the training we provide course completion certificate with each credit per hour (SEU,s or PDU’s)


We have most experienced trainers in the Industry. Our Trainers are highly skilled in their subject areas and are uniquely positioned to provide participants with deep industry experience. They are motivated to transfer knowledge through practical support post and pre-training to provide participants with additional support outside the classroom.

Samir Chibber CST

Ashesh SPC4

Armen Pashkam SPC4

Abrar SPC4


All of our instructors are recognized experts in their fields with hands-on experience on the topics they teach. We combine proven adult educational training methods with leading-edge industry expertise to provide you an exceptional training experience. Every instructor must meet rigorous standards with the proven background in their given field of expertise. It is the difference that our customers covet and participant appreciates at the completion of the course.


Students will receive a course manual with presentation slides and reference materials.

ALL of our instructors, share with you over Real experience, case studies, stories, and examples.

We provide Continuing Support beyond the class with Free Coaching and Mentoring

Training Platforms

Flexibility is what we provide in order to take your career to the next level. Lets you get out and take the training on your convenient place and on your convenient time. Any of our Classroom courses can be delivered on-site at your workplace or a place of you choose.

Classroom Training

Social Interaction

Audio, Visual and Beyond

Instructor vs. Learner Focused

Virtual Training


Flexible Learning

Practical and Proven

Corporate Training

Save Valuable Time and Money

Customized Course Content

On Your Preferred Date & Time

Our Happy Customers

It's always great to hear from customers as it helps us find out if what we are doing is right and to continue to develop our Training and services in line with what our customers need. Below are just a few of the comments we've recently received from Our Participants

Good Focus on Knowledge Areas
Best Support Team and Best Instructor, Great Learning
Excellent Teaching, Real world Examples

Our Popular Courses

We know that picking what course to study next is sometimes rather difficult. Therefore to help narrow down your choices, we have taken the step to look through hundreds of courses on offer and pulled together a list of our most popular courses. This way you can see what is currently trending in the World! If you need help enrolling into any of these courses, call us to speak with one of our Training Consultants.

Business Analyst Boot Camp
Duration: 4 Days
Professional in Business Analysis (PMI-PBA)®
Duration: 4 Days
Professional Skills Boot Camp
Duration: 3 Days
Communication Skills
Duration: 1 Day
Technical Writing
Duration: 4 Days
Excel Analytics
Duration: 3 Days

Our Clients

Just some of the leading brands that trust Mangates