Excel 2013 Intermediate

Users who are experienced with Excel but want to take advantage of more in-depth functionality (e.g. complex functions, defined names and ranges, charts, data manipulation, advanced formatting) should enroll in the Excel 2013 Intermediate class. (One day, 3-hour class.)

Excel 2013 Intermediate

Students will gain experience with nested functions, boolean logic, data organization and manipulation. They will understand the difference between absolute and relative references, the dual worksheet layers (value and formula), and expanded charting operations. Students will also be able to implement object security (workbooks, worksheets, cells, etc.).

Students should have taken Excel 2013 Basic or its equivalent. Must be able to create, open, save, format, and print worksheets. Should be able to use formulas and basic functions and have the ability to cut, copy, and paste values and formulas. Must be familiar with Windows and possess basic computer skills.

  • One day, 3-hour class
  • $219 $169 ($50 discount)



Working with Worksheets

  • Viewing, Renaming, and Color-coding Worksheets
  • Moving and Copying Worksheets
  • Creating Linked Formulas
  • Using 3-D References
  • Hyperlinks
  • Advanced Sorting
  • ScreenTips

Formulas and Functions

  • Absolute vs Relative Cell References
  • Creating and Using Named Ranges
  • Using Custom Zoom
  • Entering Formulas and Functions
  • The Functions Library
  • Working with Insert Function
  • Using Financial Functions
  • Using Date Functions
  • Nested Functions
  • Auditing and Error Checking

Cell Formatting and Data Validation

  • Merging Cells and Wrapping Text
  • In-Cell Formatting
  • Creating and Using Custom Formats
  • Copy/Paste Formats
  • Applying Conditional Formatting
  • Using Data Validation

Working with Charts

  • Creating Charts
  • Changing the Chart Location and Size
  • Changing the Chart Type
  • Modifying Chart Elements
  • Formatting Chart Elements
  • Formatting a Data Series
  • Adding and Removing Data Series
  • Applying a Chart Filter
  • Printing Charts
  • Creating and Using a Chart Template
  • Creating a Sparkline

Object Security

  • Protecting Workbooks and Worksheets
  • Locking Cells
  • Allowing Users to Edit Ranges
  • Creating the History Report


  • Row and Column Outlines
  • Group and Ungroup
  • Cell Comments


PayPal Acceptance Mark

Official PayPal Seal