Online Classes

The Training Team is happy to make a few of our training classes available  online. Thanks to Media Services, we are able to record some of our live classes and post them here for you to view. Look for more available online classes later in the semester.

You must use Windows Media Player to view these videos.

For the best learning experience, we recommend downloading the listed training materials for a class so you can participate in the hands-on sections

To download training materials:

1. Click the Training Materials link below the class name to be redirected to the specific SharePoint page with the class materials.
2. Log in with mccombs\msbaccount, where msbaccount is your personal McCombs account. For students, this is msb followed by some letter & numbers. For faculty and staff, this is your last name + first initial.
3. Right-click on the file(s) you want to download and select Save Target As.... Save to your personal computer.

 

Excel 2003

PowerPoint 2003

 

Excel 2003

Master Your Data: Excel Pivot Tables
Getting More from Excel - Functions, Features, and Keyboard Shortcuts
Excel I for Undergraduates/MPA Excel I
Excel II for Undergraduates/MPA Excel II
What If... Excel Goal Seek & Solver

Master Your Data: Excel Pivot Tables (for graduate students)
Learn how to use pivot tables in Excel to summarize and customize large amounts of data. An incredibly useful tool!  This is a recording of a class taught to graduate MBAs and MPAs on February 9, 2007.
View the online class

Training Materials:
Required
- Excel Pivot Tables for MBAMPAs Exercises (Excel workbook)
Optional
- Excel Pivot Tables Cheat Sheet (Word document)
- Pivot Table Basics (Word document)

 

Getting More from Excel - Features, Functions, & Keyboard Shortcuts (for graduate students)
This class teaches a variety of skills including naming cells, logical functions, lookup functions, financial functions, concatenation, data validation, protection, and keyboard shortcuts. This is a recording of a class taught to graduate MBAs and MPAs on March 9, 2007.
View the online class

Training Materials:
Required
- GettingMorefromExcel_workbook (Excel workbook)
Optional
- Getting More from Excel handout (Word document)
- Getting More from Excel Exercises (Word document)
- Getting More from Excel presentation (PowerPoint presentation)

 

Excel I for Undergraduates/MPA Excel I

In this class, we'll cover the essentials of organizing your data, including but not limited to a review of Excel basics, working with worksheets, formatting, sorting, filtering, hiding and grouping, and basic functions. We'll also use keyboard shortcuts throughout the class to help you learn the fastest way to work with your spreadsheets.
View the online class

Training Materials:
Required
- Excel I for Undergraduates (Excel workbook)
Optional
- Excel I for Undergraduates (PowerPoint presentation)

 

Excel II for Undergraduates/MPA Excel II

We'll cover the essentials to manipulating your data, including COUNTIF, SUMIF, logical functions, VLOOKUP, and pivot tables. We'll also use keyboard shortcuts throughout the class to help you learn the fastest way to work with your spreadsheets.
View the online class

Training Materials:
Required
- Excel II for Undergraduates (Excel workbook)
Optional
- Excel II for Undergraduates (PowerPoint presentation)

 

What If...? Excel Goal Seek & Solver

Excel has several "what if" tools, to help you answer your "what if...?" questions. This class covers Goal Seek, which allows you to determine a starting figure based on what you want your end result to be, and Solver, which allows you to find the optimal solution given your constraints.
View the online class

Training Materials:
Required
- What If - Excel Goal Seek Solver (Excel workbook)
- What If - Excel Goal Seek Solver exercises (Word document)
Optional
- What If - Excel Goal Seek Solver presentation (PowerPoint presentation)
- What If - Excel Goal Seek Solver handout (Word document)

 

PowerPoint 2003

Presenting Dynamic PowerPoint Presentations

This class will focus on how to get and keep the attention of your audience. We will cover getting your audience involved, the rehearsal timings feature, using PowerPoint’s presentation tools, and more elements of designing a good presentation.

View the online class

Training Materials

Required
- Ask me Sample (PowerPoint presentation)
Optional
- Presenting for Students (PowerPoint presentation with speaker notes)