Download and unzip the appropriate file to use during the workshops. Double-click to open the file in Excel. It will likely open in Protected View, so click on ‘Enable Editing’ to edit the workbook.
Introduction to Excel: IntroExcelApril26SampleWorkbook
Excel Essentials: ExcelEssentials_May3_SampleFiles
- 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 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.
Advanced use of Excel 2016: These courses expand upon the introductory course, and present more advanced functions and features.
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)
- Find and replace
- Conditional formatting
- Data validation
Excel Essentials: May 3, 2017 at 10 am, classroom B02, Raether Library
- Tables vs Ranges
- Text functions
- Advanced functions (IF, VLOOKUP, COUNTIF, Goal Seek, Solver)
- Date conversions
- Pivot tables (if time)
- Charts (if time)