Data Samples

Download and unzip the appropriate file to use during the workshops. To download the file, right-click the file name and then select “Save Link As …” to save to the desktop or downloads folder. To unzip the file, right-click the file name (after it has been downloaded to your computer), and then select “Extract All.”

Double-click to open the file in Excel or Word. It will likely open in Protected View, so click on ‘Enable Editing’ to edit the document.

Excel Macros: ExcelMacroTraining_Dec2018

Automating Word: WordTrainingMay2018

Introduction to Excel: IntroExcelApril26SampleWorkbook

Excel Essentials: ExcelEssentialsSamples_Nov16

Excel Data Visualization and Pivot Tables (two workbooks): Excel_Samples_Nov_30_2017

Excel 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

This beginner cheat sheet is very useful for anyone just starting out with Excel macros – VBA-for-Excel-cheat-sheet

Microsoft Visual Basic Language Reference – https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/

  • Lynda.com training.

Lynda.com (now LinkedIn Learning) 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.

Macros:

Excel 2016: Macros in Depth This course is the basis for the current workshop, so would be a good review.

Learning VBA in Excel – this course shows more advanced VBA functionality

Excel VBA:  Managing Files and Data

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

https://www.lynda.com/Excel-tutorials/Excel-2016-Charts-Depth

Word Help Resources

  • This one-page guide is useful to remember commands and shortcuts.
  • Word quick reference sheet – word-2016-quick-reference
  • Lynda.com training.

Lynda.com (now LinkedIn Learning) 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.

Automating Word:

Word 2016  – Templates in Depth

Word 2016 – Forms in Depth

Word 2016 – Mail Merge in Depth

Word 2016 – Advanced Tips and Tricks

Workshop Dates

Introduction to Excel Macros: Dec. 12, 2018 at 1:30 pm, classroom B03, Raether Library

  • What is a macro?
  • Recording macros
  • Saving and running macros
  • Modifying macros in the VBA editor
  • If/Then and Do Loop conditional statements

Automating Word: May 10, 2018 at 10 am, classroom B02, Raether Library

  • Fields
  • Auto correct
  • Quick Parts
  • Building blocks
  • Content controls
  • Forms and templates
  • Mail merge
  • Office 365 Forms

Excel Essentials: November 16, 2017 at 2 pm, classroom B02, Raether Library

  • Tables vs Ranges
  • Subtotals
  • Text functions
  • Advanced functions (IF, VLOOKUP, COUNTIF, Goal Seek, Solver)
  • Date conversions

Data Visualization in Excel: November 30, 2017 at 2 pm, classroom B02, Raether

  • How to work with multiple worksheets
  • How to build graphs and traditional charts
  • Line-bar combination charts and interactive charts
  • Pivot tables to create summaries
  • Integrating multiple data sources in a dashboard
  • Creating basic infographics
  • (Prerequisite:  Proficiency manipulating data in Excel or the Excel Essentials workshop)

Introduction to Excel: no workshops Fall 2017

  • 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