On Site Excel Training

Our classes build upon each other and we recommend they be taken in order. We have found that even advanced users can greatly improve their efficiency by learning shortcuts. We move fast and make sure that both beginners and advanced users get value from each session.

We focus on exposing students to many features and not on memorizing where every detail is hidden. Our philosophy is if you know something is possible, then you can look it up. If you don’t know it exists, then you will never know to look it up.

On site classes are 6 hours in length, with breaks to regenerate brain cells. We prefer to use your computers with your version of Excel so that each student can become familiar with their equipment and save files to work on later. We like to schedule sequential classes no more than 1 week apart to help with retention. Accommodations can be made for three shifts and weekends if needed. Class size limited to 15 people.

On Site Classes start at $2999 per session. That works out to $199 per person if you fill the class, and your employees don’t have any travel expenses. Save even more by booking the complete series of 4 classes in 4 weeks and get a $250 discount!

Excel Basics and Power User Shortcuts (6 Hour Class)

• Overview
• File Management
• Using Rows & Columns
• Resizing Rows & Columns
• Selecting Ranges
• Formatting Cells, Rows, & Columns
• Data Entry
• Inserting Rows & Columns
• Constants And Formulas
• Saving Files
• Using Undo
• Modifying Formulas
• Adding Sheets To Your Workbook
• Printing Workbooks, Worksheets, And Selections
• Using Find & Replace
• Freezing Panes
• Hiding Rows & Columns
• Page Setup and Printing
• Moving & Copying Formulas
• Absolute References Intro

Creating and Editing Formulas (6 Hour Class)

• Advanced Formulas
• Using Functions
• Formatting Cells & Worksheets
• Conditional Formatting
• What If & Goal Seek
• Referencing Multiple Worksheets & Workbooks
• Relative and Absolute References
• Sort
• Filter
• Forms
• Subtotals
• Data Validation
• Using Time and Date Formats in Formulas

Graphing and Functions (6 Hour Class)

• Functions
  • Financial
  • Date &Time
  • Math & Trig
  • Statistical
  • Lookup & Reference
  • Database
  • Logical
  • Informational
  • Text
  • Cover the Following Functions:  If, Sum, Average, Min, Max, Count, Countif, Pmt, FV, Day, Month, Year, Hlookup, vlookup, PV, NPV, PI, Even, Odd, Round, Roundup, Rounddown, Percentile, percentrank
• Formulas and Problem Solving
• Show Precedents and Dependents
• Absolute References
• Partial Absolute References
• Graphing
  • Selecting Chart type
  • Modifying components

Working with Large Data Sets (6 hour Class)

• Importing and exporting data
• Working with Multiple Sheets
  • 3 Dimensional Formulas
  • Selecting Multiple Sheets
  • Formatting across multiple sheets
• Working with Multiple Workbooks
• Concatenate and text to columns
• Paste Special Options
• Insert Hyperlink to link to other workbooks
• Hiding Rows, Columns, Sheets
• Copying Sheets
• Conditional Formatting to values and cell references
• Protection
• Goal Seek
• Scenarios
• Group and Outline
• Validation
• Pivot Tables
• Pivot Charts
• Recording Macros