Excel 2016 Tips and Tricks

In this session, we will learn different techniques for working with data.  Additionally, we will work with common types of university data and use Excel functions to manipulate the data.

Session Length: 90 minutes

Intended Audience: Any Staff or Faculty

Prerequisites: Familiarity with Microsoft Excel 2016

Format: Presentation

Covers:

• Managing Workbooks and Worksheets
• Working with Data
• Summarizing Data
• Visualizing Data
• Printing Data
• Getting Assistance

• Presentation - handout (pdf)
• PowerPoint Slides (pdf)
• Creating PivotTables with Actuals Transactions (pdf)
• Quick Start Guide (pdf)
• Sample data (xlsx)