Excel 2013 Expert

Printable, customizable, training materials

Your participants will learn how to use the advanced features of Excel 2013. This workshop is designed to provide an in-depth understanding 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 Expert

$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 Expert:

  • 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 Expert Course Outline:

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


Module Two: Working with Permissions and Options
  • Marking a Workbook as Final
  • Encrypting with a Password and Restricting Permissions
  • Protecting the Current Sheet or the Workbook Structure
  • Adding a Digital Signature
  • Setting Excel Options
  • Managing Versions
  • Saving a Workbook as an Excel Template
  • Module Two: Review Questions


Module Three: Sharing Workbooks
  • Inspecting a Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook
  • Module Three: Review Questions


Module Four: Performing Advanced Formula and Function Tasks
  • Using the Watch Window
  • About the Excel Calculation Process
  • Setting Calculation Options
  • Enabling or Disabling Automatic Workbook Calculations
  • Using the IFERROR Function to Evaluate Formulas
  • Module Four: Review Questions


Module Five: Working with Array Formulas
  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array
  • Module Five: Review Questions


Module Six: Working with Macros
  • Assigning a Macro to a Command Button
  • Running a Macro by Clicking an Area of a Graphic Object
  • Configuring a Macro to Run Automatically Upon Opening the Workbook
  • Changing a Macro
  • Module Six: Review Questions


Module Seven: Working with Forms
  • About Excel Forms, Form Controls, and Active X Controls
  • Using a Data Form
  • Using a List Box Control
  • Using a Combo Box Control
  • Using a Spin Button Control
  • Using a Scroll Bar control
  • Module Seven: Review Questions


Module Eight: Applying Advanced Chart Features
  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates
  • Module Eight: Review Questions


Module Nine: Working with PivotTables and Pivot Charts
  • Working with PivotTable Tools
  • Working with PivotChart Tools
  • About Slicers
  • Creating a Slicer in an Existing PivotTable
  • Creating a Standalone Slicer
  • Formatting a Slicer
  • Sharing Slicers with Another PivotTable
  • Disconnect or Delete a Slicer
  • Module Nine: Review Questions


Module Ten: Working with Power View
  • About Power View
  • Creating a Power View Sheet
  • Connecting to Different Data Modules in One Workbook
  • Modifying the Data Model without Leaving the Power View Sheet
  • Using Drill Down, Drill Up, and Cross Drill
  • Module Ten: Review Questions


Module Eleven: Working with Multiple Tables in Data Analysis
  • Using Multiple Tables in Your Data Analysis
  • Connection to Additional Data Sources
  • Creating Relationships between Tables
  • Using a Timeline to Show Data for Different Time Periods
  • Module Eleven: Review Questions


Module Twelve: Wrapping Up
  • Words from the Wise
  • Review of Parking Lot

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)