## Data Samples

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.

Automating Word: WordTrainingMay2018

Introduction to Excel: IntroExcelApril26SampleWorkbook

Excel Essentials: ExcelEssentialsSamples_Nov16

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

## Help Resources

• 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.

Automating Word:

Word 2016  – Templates in Depth

Word 2016 – Forms in Depth

Word 2016 – Mail Merge in Depth

Word 2016 – Advanced Tips and Tricks

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-Charts-Depth

## Workshop Dates

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