Excel Tips and Tricks

This class will explore many of the built-in Excel functions, formulas, and short cuts.

Overview

This class is geared toward the above average user who wants to increase their productivity and effectiveness with Excel.

 

Audience

It is a prerequisite that students enrolling in this class will understand how to create simple functions (sum, average) and formulas in Excel (=A2+B2) and that they are comfortable using the standard formatting features in Excel.

Length

4 hours

Outline

Entering Data

  • Enter a line break within a cell
  • Auto fill
  • Copying cells and creating series
  • Creating a custom autofill series
  • Auto complete

Formatting

  • Sizing rows, columns, wrapping text
  • Dates, text and values
  • Format painter
  • Custom number formats
  • Conditional formatting
  • Text to columns

Using Keyboard Shortcuts

Paste Special

  • Values and formulas

Absolute reference

Naming cells

Functions

  • Using the Function Wizard
  • PMT function
  • Date formulas

Error Messages

  • Identifying errors in formulas
  • Troubleshooting problems with formulas

Organizing Lists of Data

  • Sorting data
  • Filtering data
  • Subtotal
  • Grouping
  • Freezing rows and columns