Excel 2007 Advanced Courseware

Printable, customizable, training materials

 

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.
- OR -
  • No Annual Renewal Fees
  • Unlimited Users
  • Unlimited Printing Rights
  • All Components are Completely Customizable!

This trainer's courseware kit includes everything you need to teach Excel 2007 Advanced corporate training workshops:

  • PowerPoint
    Slides
  • Web-based
    Training
  • Quick
    Reference
    Sheets
  • Icebreakers & Exercise
    Files
  • Training Manuals
    & Instructor Guide


Download
FREE Sample
 

Excel 2007 Advanced Course Outline:

Module One: Getting Started
  • Icebreaker
  • Housekeeping Items
  • The Parking Lot
  • Workshop Objectives


Module Two: SmartArt
  • Inserting SmartArt
  • An Overview of the SmartArt Tabs
  • Adding Text to the Diagram
  • Resizing and Moving the Diagram
  • Resetting the Diagram


Module Three: Inserting Objects
  • About Contextual Tabs
  • Adding Pictures from Your Computer
  • Adding ClipArt
  • Adding Text Boxes
  • Drawing Shapes


Module Four: 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 Five: Creating Pivot Tables
  • Inserting a Pivot Table
  • Overview of the Pivot Table Tools Tab
  • Choosing Fields


Module Six: Working with Pivot Tables
  • Changing the Data Displayed
  • Applying a Style to Your Pivot Table
  • Some Real-life Examples


Module Seven: Creating Pivot Charts
  • Creating a Pivot Chart from a Pivot Table
  • Creating a Pivot Chart from Data


Module Eight: Solving Formula Errors
  • Using Named Ranges
  • Understanding Formula Errors
  • Tracing Dependents and Precedents
  • Using the Trace Errors Commands
  • Evaluating Formulas


Module Nine: Using What-If Analysis
  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table


Module Ten: 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 Eleven: Grouping and Outlining Data
  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data


Module Twelve: Wrapping Up
  • Words from the Wise
  • Review of Parking Lot
  • Lessons Learned
  • Completion of Action Plans and Evaluations

Try a FREE sample and see the value for yourself!

Soft Skills Library

Administrative Support
Anger Management
Assertiveness And Self-Confidence
Attention Management
Basic Bookkeeping
Budgets And Financial Reports
Business Ethics
Business Etiquette
Business Succession Planning
Business Writing
Call Center Training
Change Management
Civility In The Workplace
Coaching And Mentoring
Communication Strategies
Conflict Resolution
Creative Problem Solving
Critical Thinking
Customer Service
Emotional Intelligence
Employee Motivation
Employee Onboarding
Employee Recruitment
Facilitation Skills
Generation Gaps
Human Resource Management
Interpersonal Skills
Job Search Skills
Knowledge Management
Leadership And Influence
Lean Process And Six Sigma
Measuring Results From Training
Media And Public Relations
Meeting Management
Middle Manager
Negotiation Skills
Overcoming Sales Objections
Performance Management
Personal Productivity
Presentation Skills
Project Management
Proposal Writing
Public Speaking
Safety In The Workplace
Sales Fundamentals
Stress Management
Supervising Others
Supply Chain Management
Talent Management
Teamwork And Team Building
Time Management
Train-The-Trainer
Workplace Diversity
Workplace Harassment
Workplace Violence
Body Language Basics
Office Politics for Managers
Work-Life Balance






Microsoft Office Library

Access 2007 Advanced
Access 2007 Essentials
Access 2010 Advanced
Access 2010 Essentials
Excel 2007 Advanced
Excel 2007 Essentials
Excel 2010 Advanced
Excel 2010 Essentials
Groove 2007 Essentials
InfoPath 2007 Advanced
InfoPath 2007 Essentials
InfoPath 2010 Advanced
InfoPath 2010 Essentials
Office 365 Word Essentials
OneNote 2007 Advanced
OneNote 2007 Essentials
OneNote 2010 Advanced
OneNote 2010 Essentials
Outlook 2007 Advanced
Outlook 2007 Essentials
Outlook 2010 Advanced
Outlook 2010 Essentials
PowerPoint 2007 Advanced
PowerPoint 2007 Essentials
PowerPoint 2010 Advanced
PowerPoint 2010 Essentials
Project 2007 Advanced
Project 2007 Essentials
Project 2010 Advanced
Project 2010 Essentials
Publisher 2007 Advanced
Publisher 2007 Essentials
Publisher 2010 Advanced
Publisher 2010 Essentials
SharePoint Designer 2007 Essentials
Visio 2007 Advanced
Visio 2007 Essentials
Visio 2010 Advanced
Visio 2010 Essentials
Windows 7 Essentials
Word 2007 Advanced
Word 2007 Essentials
Word 2010 Advanced
Word 2010 Essentials
Office 365 Excel Essentials
Office 365 PowerPoint Essentials



Just a few of our satisfied customers. View all clients.

Polaroid America's Navy Aramex Delivery Unlimited Hertz Tupperware

“These materials are a life saver...”

Read testimonials.