Help Resources

  • This one-page guide is useful to remember commands and shortcuts. This company also provides guides for other Microsoft Office products.Excel-2016-quick-reference-sheet
  • Lynda.com training.

Lynda.com provides short training videos on an astonishing number of software and productivity tools. We have a campus agreement with Lynda.com, so after clicking on the link, sign in with your trincoll.edu username and password.

Introduction to Excel: This course introduces Excel, but also shows how to use Vlookup and Solver. Pick and choose the videos that will help you with your project.

https://www.lynda.com/Excel-tutorials/Excel-2016-Essential-Training

Advanced use of Excel 2016: These courses expand upon the introductory course, and present more advanced functions and features.

https://www.lynda.com/Excel-tutorials/Excel-2016-Managing-Analyzing-Data

https://www.lynda.com/Excel-tutorials/Excel-2016-Cleaning-Up-Your-Data

https://www.lynda.com/Excel-tutorials/Excel-2016-Advanced-Formulas-Functions

Workshop Dates

Introduction to Excel: Wednesday, April 26, 2017 at 2 pm in classroom B02, Raether Library

  • Workbook vs. worksheet
  • File management
  • Navigation and toolbars
  • Cells – references and formatting
  • Simple formulas and autofill
  • Sorting (and tables)
  • Filtering
  • Find and replace
  • Conditional formatting
  • Data validation

Excel Essentials: May 3, 2017 at 10 am, classroom B02, Raether Library

  • Tables vs Ranges
  • Subtotals
  • Text functions
  • Advanced functions (IF, VLOOKUP, COUNTIF, Goal Seek, Solver)
  • Date conversions
  • Pivot tables (if time)
  • Charts (if time)