Button to scroll to the top of the page.

Events Calendar

Yearly View
View as List
Monthly View
By Month
Weekly View
By Week
Daily View
Today
Search
Search
Download as iCal file
Excel Data, Graphics - SDS Short Course
Tuesday, February 06, 2018, 09:00am - 12:00pm
This course is intended to introduce new users to Microsoft Excel as a tool for managing, summarizing, and visualizing data, as well as conducting basic statistical analysis. It will cover topics such as using sorting and organizing data using filters, naming cells and cell ranges as a shortcut for functions, ‘if’ functions, matching data using built in functions, pivot tables and charts, editing charts and tables, and using built in features such for basic statistical analysis.

Note: I will primarily be working from a PC and using the built in package the Data Analysis ToolPak. The computers in the lab are PCs as well. If you wish to follow along on a Mac computer you must have Excel version 2016. The functionality of previous versions of Excel (2010 for Mac and prior) is not the same and you will not be able to follow along without the latest version.

After completing this course, a new user should be able to:

  • Create new tables and charts and edit properties
  • Name cells and cell ranges for functions
  • Use built in filtering functions
  • Use ‘if’ and ‘vlookup’ functions for summarizing data
  • Create tables and charts using Pivot Table
  • Use the Data Analysis ToolPak to create charts of data
  • Use the Data Analysis ToolPak to calculate descriptive statistics and correlations