Excel Tutorial - Class #3

Thursday, October 14, 2021
2:30 PM – 3:30 PM
Shadyside campus, Coolidge Hall, room 232

Cost: Free

Want to improve your skills in Excel? Then join the Business Department for a 4-part Excel tutorial series, led by Graduate Assistant Peter Zimmer.

The tutorial will provide some foundational information, highlight the potential uses of the program, and provide resources for future skill building.

The 4 weekly sessions will be held Thursdays from 2:30 to 3:30pm. Dates: September 30, October 7, 14, 21 Location: Shadyside campus, Coolidge Hall, room 232.

Please register in advance via the link below.

Please bring your own laptop, with a full charge, and the latest version of desktop Microsoft Excel.

Class 1: Excel Basics: Navigating and Formatting (September 30)

In this class we will be going over the basic navigation of Excel; How to open workbooks, adjust views, change formatting and displaying data. We will discuss some of the uses of Excel and describe real world applications. This class is designed for people who have little to no experience with the program.

Class 2: Using Data: Basic Functions and Uses, Creating Lists (October 7)

In the second class we will begin to manipulate data and use basic formulas. We will discuss some shortcuts and basic functions within the program for sorting, finding, and navigating through data. We will discuss the role of syntax and referencing and how to create lists and tables. This class is designed for people who have used Excel but would like to become more familiar with fundamental functions and formulas.

Class 3: Intermediate Excel: Pivot Tables and Charts, Data Validation (October 14)

The third class will include more specific manipulation of charts and tables. We will use functions like VLOOKUP and Data Validation tools. We will discuss the uses of more elaborate data sorting and functionality and how that applies to real situations. This class is designed for someone who wants to apply more sophisticated functions to sets of data.

Class 4: Advanced Excel Uses: Logical Tests, Into to Macros (October 21)

In the final class we will present the basics of using logical tests and macros. This class is designed to show the opportunities within Excel but will not go into detailed applications and writing of Macros. This class is designed to inform people of the possibilities within the program.


Shadyside campus, Coolidge Hall, room 232


Register in advance via the link below.

Contact Information

Jessy Swisher