* Excel Short Courses are for current UT faculty, staff, and students.
* Seating for each class is limited to 40 students.

Instructor: Kristin Harvey is a lecturer for the Department of Statistics and Data Sciences. She has a Master’s Degree in Educational Psychology specializing in Program Evaluation and a PhD in Educational Psychology specializing in Human Development, Culture, and Learning Sciences. She teaches and coordinates SDS 302: Data Analysis for the Health Sciences, an introductory undergraduate statistics course.

EXCEL Data and Graphics

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

EXCEL introductory statistics

This hands-on course will introduce participants to common inferential statistical analyses.  We discuss and practice applying these methods on real datasets using the Data Analysis Toolpak in Microsoft Excel. The specific topics covered in this course include:  paired and independent samples t-tests and supporting graphics, correlation, and linear regression. 

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, participants should be able to:
  • Use the Data Analysis ToolPak to calculate a paired samples t-test
  • Use the Data Analysis Toolpak to calculate an independent samples t-test
  • Create a bar chart of means for comparison including error bars
  • Learn how to make a correlation matrix or correlation calculation
  • Use the Data Analysis ToolPak to calculate a p-value for correlation
  • Use the Data Analysis ToolPak for single and multi-predictor linear regression
Prerequisites: Completion of "Excel Data and Graphics" short course or equivalent practice and experience with Excel.  Familiarity with basic statistical concepts such as t-tests and regression is 
recommended but not necessary.