Microsoft Excel

Microsoft Excel is a spreadsheet program that is used to manage, analyze, and present data. It includes many powerful tools that can be used to organize and manipulate large amounts of data, perform complex calculations, create professional-looking charts, and more.

For step-by-step handouts and self-paced tutorials, visit the Microsoft Office Training page.


Microsoft Excel 1: Formulas and Functions

This workshop covers the following topics and more:

  • Relative and absolute cell references—“must-know” information for working with formulas
  • Insert Function dialog box to insert functions and to quickly get help on how the selected function works
  • Name Manager to name a data range and use it in your formulas to save time and effort
  • Evaluate Formula dialog box to evaluate each part of your complex formulas individually to locate and correct any errors
  • Understanding and using the Trace Precedents and Trace Dependents features

Duration: 90 minutes

Date and Time Location Evaluation
Friday, October 20, 2017 - 10:00am to 11:30am
LPW 4056
Evaluate Workshop

Microsoft Excel 2: Objects, Charts, and Sparklines

This workshop covers the following topics and more:

  • Quickly insert objects such as pictures, clip art, shapes and more with just a few clicks of the mouse
  • Insert complex mathematical equations and symbols into your worksheets
  • Use the Screenshot feature to quickly insert a screenshot of any open application
  • Select your data and insert a chart into your worksheet
  • Bar chart, pie chart, line chart—Choose and use the right type of chart to get your point across

Duration: 90 minutes

Date and Time Location Evaluation
Friday, October 27, 2017 - 10:00am to 11:30am
LPW 4056
Evaluate Workshop

Microsoft Excel 3: Managing Data

This workshop covers the following topics and more:

  • Prevent bad data from being entered by using the Data Validation feature
  • Automatically add subtotals to several rows of related data with just a couple of mouse clicks
  • Using the powerful filter features of Excel to view only the data you have need of
  • Easily separate the contents of one cell into multiple columns such as first and last names
  • Speed up data input with the AutoFill feature and customize the AutoFill feature by using Custom Lists

Duration: 90 minutes

Date and Time Location Evaluation
Friday, November 17, 2017 - 10:00am to 11:30am
LPW 4056
Evaluate Workshop