Excel 2010 Advanced

Printable, customizable, training materials

Your participants will learn how to use the advanced features of Excel 2010. This workshop is designed to teach you an advanced understanding of Excel 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!
Excel 2010 Advanced


  • Unlimited Users
  • Unlimited Printing Rights
  • Completely Customizable

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

Polaroid America's Navy Hertz Tupperware

“These materials are a life saver...”

Read testimonials.

Everything you need to teach a one-day workshop for Excel 2010 Advanced:

  • Training Manuals
  • PowerPoint Slides
  • Instructor's Guide
  • Quick Reference Job Aids
  • Icebreakers, Activities,
     & Exercise Files
  • Pre-Assignments,
  • Promotional Advertorials
  • Lesson Plans with Flip Chart Notes

Also available: training video clips, editable books, audiobook workshops, e-learning, and cloud-based LMS.

Excel 2010 Advanced Course Outline:

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

Module Two: SmartArt and Objects
  • Inserting SmartArt
  • Adding Text to the Diagram
  • Resizing and Moving the Diagram
  • Resetting the Diagram
  • Adding Pictures from Your Computer
  • Adding Clip Art
  • Adding Text Boxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing
  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tab
  • Understanding the Parts of a Chart
  • Changing the Chart Style
  • Resizing and Moving the Chart

Module Five: Creating Pivot Tables
  • Inserting a PivotTable
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs

Module Six: Working with PivotTables and PivotCharts
  • Changing the Data Displayed and Refreshing the PivotTable
  • Applying a Style to Your Pivot Table
  • Creating a Pivot Chart from a Pivot Table
  • Creating a Pivot Chart from Data
  • Some Real-life Examples

Module Seven: Macros
  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors
  • Using Named Ranges
  • Understanding Formula Errors
  • Using the Trace Errors Commands
  • Using Error Checking
  • 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!

Administrative Skills ($2990)

Career Development ($2990)

Human Resources ($2990)

Personal Development ($2990)

Sales And Marketing ($2990)

Supervisors And Managers ($2990)

Workplace Essentials ($2990)

Office 2016 ($2990)

Office 2013 ($2990)

Office 365 ($2990)

Office 2010 ($2990)

Office 2007 ($2990)