Excel 2013 Advanced

Printable, customizable, training materials

Your participants will learn how to use the advanced features of Excel 2013. This workshop is designed to get into the more advanced features of Excel 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making!
Excel 2013 Advanced

$499 

  • 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 2013 Advanced:

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

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

Excel 2013 Advanced Course Outline:

Module One: Getting Started
  • Housekeeping Items
  • Pre-Assignment Review
  • Workshop Objectives
  • The Parking Lot
  • Action Plan


Module Two: SmartArt and Objects
  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Text Boxes
  • Drawing Shapes
  • About the Contextual Tabs
  • Module Two: Review Questions


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


Module Four: Creating Charts
  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding the Parts of a Chart
  • Resizing and Moving the Chart
  • Module Four: Review Questions


Module Five: Working with Charts
  • Using Chart Elements
  • Using Chart Styles and Colors
  • Changing the Chart Style
  • Using Chart Filters
  • Working with Data Labels
  • Module Five: Review Questions


Module Six: Creating Pivot Tables and Pivot Charts
  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples
  • Module Six: Review Questions


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


Module Eight: Solving Formula Errors
  • Using Named Ranges
  • Understanding Formula Errors
  • Using the Trace Errors Commands
  • Using Error Checking
  • Evaluating Formulas
  • Module Eight: Review Questions


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 Nine: Review Questions


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 Ten: Review Questions


Module Eleven: Grouping and Outlining Data
  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data
  • Module Eleven: Review Questions


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)