The bulk of our tutorials live on our blog. It is a searchable resource, so just type what you're looking for in the search box in the top right corner. Visit the blog at: blogs.mccombs.utexas.edu/the-most.
Student Email
All McCombs Students receive a McCombs branded email address. The features available vary based on when you were admitted to McCombs.
Students Admitted Before 2012
Students who entered McCombs before the year 2012, you receive a 100 MB mailbox during your time at McCombs and lifetime email forwarding after leaving McCombs. Email can be forwarded to another address while you are at McCombs.
Useful email links:
Students Admitted January 2012 and Later
For students admitted January 2012 or later, you will receive a McCombs branded email address that will be forwarded to the email account you used when applying to McCombs. You can update your email forwarding to forward to a different account. After graduation, your email forwarding will continue for life.
While at McCombs, you will have access to McCombs contacts and distribution lists through the McCombs Webmail page, but you will need to empty your Sent Items folder after sending any email through this site because your mailbox size is only 2 MB.
Useful email related links:
Faculty and Staff Email
All faculty and staff receive a McCombs branded email address that follows the form first.last@mccombs.utexas.edu. You also receive a 250 MB mailbox on the McCombs Exchange servers.
Excel Articles on The MOST
The Training Team has dozens of articles about Excel on our blog, McCombs Office Solutions and Tips (the MOST). This is a searchable resource, so type the topic you're looking for into the search box and press Enter.
View all Excel posts on the MOST
Excel Webinars
Click the Webinars tab to view any of our recorded webinars.
Intro to Excel
Microsoft has put together introductions to Excel, compiling the information they think you need to have a good foundation in Excel.
Roadmap to Excel 2007
This is a series of Microsoft tutorials to help you become familiar with Excel. If you have never used Excel, the first two will be especially helpful. Much of this will also apply to Excel 2010.
Get to know Excel 2010
This series of Microsoft videos will help you become familiar with Excel, add data to a workbook, and do basic formulas. To only watch certain videos, click the name of the video in the left column.
Roadmap to Excel 2011 (Mac)
This series of Microsoft videos and written tutorials will help you become familiar with Excel 2011, add data to a workbook, and do basic formulas.
Excel Video Tutorials
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. To download a file, click on the link and log in with mccombs\your mccombs user name as your username and your regular McCombs password.
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.
Sum Function (4 minutes)
This tutorial (from icteachercom on YouTube) shows you three different ways to sum cells.
Rounding Functions (4 minutes)
This video covers the ROUND, ROUNDUP, ROUNDDOWN, TRUNC, and INT functions.
Average, Max, Min, Count, and CountA Functions (7 minutes)
This tutorial (from rrphillips on YouTube) teaches you how to do Max, Min, Average, and also introduces you to named ranges. To learn more about named ranges, watch Define Name for Cell Ranges on Woopid.
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. 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)
This set of functions does not have an official name, so we have dubbed them "semi-logical functions." Like a logical function, each of these functions evaluate a cell or cells for a criteria and determine if it is true or false. If the criteria is met, the function will perform a count, sum, or average. 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
Mailbox Size Management
Your McCombs mailbox has a size limit. When you reach that limit, you will not be able to send or receive email until you reduce your mailbox size.
Mailbox Size Limits:
- Faculty and Staff - 250 MB
- Full-Time MBA Students - 100 MB
The following videos cover tools that help you manage your mailbox in Outlook 2003, or Outlook 2007.
What is on the Server?
Everything stored on the server counts against your mailbox size limit. So, to understand how to manage your mailbox size, it helps to know what is stored on the server. Watch the video below for an explanation.
Video - What is on the Server (2 min)
Checking Your Mailbox Size
If you don't want to exceed your mailbox size limit, it helps to know what size your mailbox currently is. Watch the video below to learn how to check your mailbox size in Outlook 2003, 2007, and Outlook Web Access.
Video - Checking Your Mailbox Size (2 min)
Deleting Email
One simple way to avoid exceeding your mailbox limit is to delete email that you no longer need. The videos below will show you how to delete multiple emails, bypass the Deleted Items folder, manage your Deleted Items folder, delete attachments, and recover Deleted Items if necessary.
Video - Deleting Email and Other Items (3 min)
Video - Managing the Deleted Items Folder (2.5 min)
Moving Email Offline
If you want to save email, and you are in danger of exceeding your mailbox limit, the only other option is to move some of your email offline.
Video - Offline Email Folders (5 min)
AutoArchiving
Auto-Archive is a feature in Outlook that automates moving email offline. It is very helpful if you have trouble remembering to move email offline.
Video - AutoArchive (5 min)
Backing Up
If you have saved emails to the hard drive of your computer, you will need to include your offline email file when you back up the important files on your computer. You will need to close Outlook before you back up your offline email file. To back it up, you will just navigate to the file on your computer, copy it, and paste it to the drive of another physical location. This can be a CD that you burn, a USB drive, or an external hard drive.
Please note: If your email contains sensitive data, you must be careful to secure whatever it is you back up to. You should not backup anything confidential to a USB drive, as those are easy to lose or steal. All sensitive data should be secured at all times.
If you have an offline email folder, and do not know where it is saved, read the Outlook Personal Folders article on the Tech Help Wiki.
Opening Your Offline Email in Outlook
You cannot navigate to your offline email file (ie PST file, Personal Folder, or Archive file) and double click to open it. You must open this file in Outlook.
To do so in Outlook 2003 and Outlook 2007:
- Open Outlook.
- Go to the File menu and hover your mouse over Open.
- From the menu that opens to the right, select Outlook Data File.
- In the dialog box that opens, navigate to your offline email file (.PST file) and select it.
- Click the Open button.
- Your offline email folder will appear in the folder list on the left side of your Outlook window.
Avoid Sending Attachments
Mailboxes often exceed their size limit because attachments take up so much space. One way to keep your mailbox size under its limit, and to help your friends and coworkers do the same, is to avoid sending attachments. Here are some ideas on avoiding sending attachments:
Webinars
To make training more accessible to all students, the Training Team began offering webinars in fall of 2011. We plan to continue offering webinars each semester. They will be recorded and posted on this page.
Webinar Preparation
If you plan to attend a webinar, you should test your connection to Adobe Connect first. This will ensure that you will be able to connect to the webinar at the right time.
Test your connection
Excel Webinars