Excel 2007 Essentials

Printable, customizable, training materials

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. The participants will learn how to use the basic features of Excel. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.

With Excel 2007, 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! ' " ' It's a "test"
Excel 2007 Essentials

$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 2007 Essentials:

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

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


Module Two: Opening and Closing Excel
  • Opening Excel
  • Understanding the Interface
  • Understanding Worksheets
  • Understanding Workbooks
  • Closing Excel


Module Three: Your First Worksheet
  • Entering Data
  • Using the Wrap Command
  • Editing Data
  • Adding Rows and Columns
  • Checking Your Spelling


Module Four: Working with Excel Files
  • About the New File Format
  • Saving Files
  • Publishing Files to PDF
  • Closing Files
  • Opening Files


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


Module Six: Printing Excel Data
  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data


Module Seven: Building Formulas
  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute Referencing


Module Eight: Using Excel Functions
  • Formulas vs. Functions
  • Understanding the Formulas Tab
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Using the Status Bar to Perform Calculations


Module Nine: Using Time Saving Tools
  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data


Module Ten: Formatting your Data
  • Changing the Appearance of Your Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting


Module Eleven: More Formatting
  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme


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)