the MOST

McCombs Office Solutions and Tips

Archives for McCombs Tech Resources

The McCombs Trainers are on YouTube

Love the Microsoft Office tips you find on the MOST? Then check us out on YouTube, where we’ve posted all of our video tutorials.

http://www.youtube.com/mccombstrainers

And if you like learning through video tutorial, there are thousands more technology tutorials on YouTube. One of our favorites is Excel is Fun.

Excel Logical Functions Webinar

This week the Training Team hosted a webinar for students about Excel Logical Functions. This one hour session covered:

  • COUNTIF(S)
  • SUMIF(S)
  • AVERAGEIF(S)
  • IF
  • AND
  • OR
  • IFERROR
  • Nesting Functions

Watch a Recording Online

If you”re interested in learning about these topics, you can watch a recording online.

View the Logical Functions webinar

Additional Microsoft Office Webinars

We’ve also recorded past webinars that are available online. We post links to our webinars on the Webinars tab of the Training Team Tutorials web page.

Save Money With Electronics Shutdown Checklist

Screenshot of sign "Closed for the Season"

photo courtesy of teofilo

With the holidays approaching, many of us will be out of the office or away from home for an extended period of time.  Why not save money by reducing your electricity usage!  Several years ago, we compiled a checklist of shutting down electronics, unplugging unnecessary equipment, and changing your thermostat.  UT Austin closes for the week between Christmas and New Year’s Day, and we made the list hoping that staffers would take some of these steps to save electricity and reduce our operating expenses.   Now, our Dean’s Office distributes it to all faculty and staff, and the list gets posted in offices for all to see.  In fact, it has been shared across the entire UT Austin community and places as far away as Florida (with some minor modifications).

Feel free to download the PDF, post it in public office spaces, email it around, or just take the steps yourself.

Did you find this helpful?  What should we add or change?  Do you use your own checklist?  What do you do to reduce your energy consumption and save money?  Please let us know in the comments.  We love to hear your thoughts.

Happy holidays from all of us at the McCombs School of Business!  We’ll see you in 2012!

Happy Holidays

Training Team would like to wish you happy holidays!

While you are away, don’t forget to check your McCombs email.  If you are away from your personal computer, you can check it through Outlook Web Access (sign in with your McCombs username and password).

ITS will be working over the break and they have a Stay Connected checklist for those of you wishing to use IT resources during the holiday.

We will see you in the spring semester with new technology ideas.

Have a wonderful holiday break and a Happy New Year!

Help with Excel Functions

It’s been well over a year since we put up any help posts for people learning Excel functions. I’d like to put up a reminder of all the posts we’ve done in the past and give a current list of online Excel function learning options.

Excel Learning Posts:

Learn Excel Functions

Five Excel Formulas and Functions Essentials

Learn Excel Watching YouTube

All our Excel posts

Microsoft Excel Official Office Website:

List of All Worksheet Functions (alphabetical)

Formulas Help and How-to

Function Reference

Microsoft Office Online Training

McCombs Training Team:

Excel Tutorials and Videos