McCombs School of Business
Technology Training Team

Excel

 

Videos

All videos are in Excel 2007, but all functions will also work in Excel 2010 and 2003 (except where noted).  The downloadable files are only available to McCombs students, faculty, and staff.  Download instructions are below.

Rounding Functions (4 minutes)
This video covers the ROUND, ROUNDUP, ROUNDDOWN, TRUNC, and INT functions.

Intro to Pivot Tables (9 minutes)
This video is for Excel 2007.  It covers good starting data, how to create a pivot table, and how to add data to a pivot table.   To learn about Excel 2003 Pivot Tables, go to our online classes page and watch the Pivot Tables class video.
Download the spreadsheet (2007 file format)

Lookup Functions  (10 minutes)
This video covers the VLOOKUP function.  This function takes information in one table, finds it in another table, and returns a corresponding value.  The HLOOKUP function works in the same way, and watching this tutorial should prepare you to do both a VLOOKUP and an HLOOKUP function.  These functions also work in Excel 2003.
Download the spreadsheet:   2003 file format       2007 file format
Login with mccombs\yourMSBaccount

Semi-Logical Functions  (21 minutes)
Semi-logical functions evaluate a cell for a criteria, and perform a count, sum, or average if that criteria is met.  This video covers COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS, AND AVERAGEIFS.  In Excel 2003, only COUNTIF and SUMIF are available.
Download the spreadsheet
Login with mccombs\yourMSBaccount

Logical Functions  (6 minutes)
Logical functions evaluate a cell or cells for a criteria and return True or False.  This video covers the IF, AND, and OR functions.  These functions also work in Excel 2003.
Download the spreadsheet
Login with mccombs\yourMSBaccount

Nesting Functions  (6 minutes)
When you nest functions together, they can do more complicated work.  This video covers the fundamentals of nesting functions and nesting an OR statement within an IF statement. If you aren't familiar with logical functions, watch the logical functions video first.
Download the spreadsheet
Login with mccombs\yourMSBaccount

Copying Formulas and Cell References  (6 minutes)
This video will cover how to use cell references set your formulas up correctly, so you will be able to copy them, and how to copy them.  These are necessary skills for working with formulas and functions.

Excel I for McCombs Students Quick skills video (12 minutes)
Basic Excel Navigation, Table formatting, and working with large data sets. This video goes over some of the basics Excel skills taught in the Excel 1 for McCombs students class.

 

Skills

Files & Handouts

You can find our Excel training files and handouts on the Training Team SharePoint site. Access to this site is limited to current McCombs faculty, staff, and students. Please log in with mccombs\msbaccount, where msbaccount is your McCombs account. To download a file using Windows, right-click on the file name and select Save Target As..., then save to your computer.

Helpful Links

These links will take you outside of the McCombs Technology Training Team's website.

  • http://www.mrexcel.com/ - read helpful articles about Excel skills and search the message board for answers to your questions

Download a File

  1. Right click on the link for the file.
  2. Select Save target as from the right click menu.
  3. Navigate to the location on your computer where you want to save the file.
  4. Click Save.
  5. If prompted, click Open, otherwise navigate to the file and open it.