Excel 2013 Essentials

Printable, customizable, training materials

Your participants will learn how to use the basic features of Excel 2013. This workshop is designed to provide a basic understanding of Excel 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will also 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 Essentials


  • 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 Essentials:

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

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

Module Two: Opening Excel
  • Opening Excel
  • Using the Recent List
  • Opening Files
  • Creating a Blank Workbook
  • Creating a Workbook from a Template
  • Module Two: Review Questions

Module Three: Working with the Interface
  • Understanding the Ribbon and the Status Bar
  • About Your Account
  • Using Backstage View
  • Understanding Worksheets vs. Workbooks
  • Closing Files
  • Closing Excel
  • Module Three: Review Questions

Module Four: Your First Worksheet
  • Entering Data
  • Using Flash Fill
  • Using Auto Fill
  • Editing Data
  • Adding Rows and Columns
  • Checking Your Spelling
  • Module Four: Review Questions

Module Five: Viewing Excel Data
  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files
  • Module Five: Review Questions

Module Six: Building Formulas
  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References
  • Using the Status Bar to Perform Calculations
  • Module Six: Review Questions

Module Seven: Using Excel Functions
  • Formulas vs. Functions
  • Using AutoComplete
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Understanding the Function Names
  • Module Seven: Review Questions

Module Eight: Using Quick Analysis
  • Formatting Tables
  • Creating Quick Analysis Charts
  • Calculating Totals
  • Creating Quick Analysis Tables
  • Using Sparklines
  • Module Eight: Review Questions

Module Nine: Formatting Your Data
  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Working with Alignment Options /Using the Wrap Command/Using Merge
  • Removing Formatting
  • Module Nine: Review Questions

Module Ten: Using Styles, Themes, and Effects
  • Using Conditional Formatting
  • Using Table Styles
  • Using Cell Styles
  • Formatting Cells
  • An Overview of the Page Layout Tab
  • Changing the Theme
  • Module Ten: Review Questions

Module Eleven: Printing and Sharing Your Workbook
  • Setting up Your Page
  • Previewing and Printing Your Workbook
  • Inviting People
  • E-Mailing Your Workbook
  • 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

Career Development

Human Resources

Personal Development

Sales And Marketing

Supervisors And Managers

Workplace Essentials

Office 2016

Office 2013

Office 365

Office 2010

Office 2007