ITS Training

Contact the Help Desk:

Follow us:
Facebook and Twitter twitter link for IT Services HelpDesk facebook link for IT Services HelpDesk


  • Mon-Thurs: 7:30 am - 8:00 pm
  • Fri: 7:30 am - 6:00 pm
  • Sat: 8:00 am - 4:30 pm
  • Sun: CLOSED access, through using IPFW credentials, will end on June 30, 2016.

What is is an award-winning provider of educational materials.'s all-star team of trainers and teachers provides comprehensive and unbiased movie-based training to an international membership of tens of thousands of subscribers. The Online Training Library® (OTL) includes video-based elearning courses on

  • Adobe and Microsoft applications and technologies
  • Web design
  • Promotion AnimationDigital photography
  • Video and audio
  • Mac applications
  • Programming
  • and more

IPFW Access

Click the following link and log in using your IPFW user credentials:

IPFW Off Campus Login Features

  • Build collections of courses with playlists.
  • Bookmark courses, chapters, and even individual videos.
  • View your course progress in course history
  • Earn Certificates of Completion by viewing all videos in a course.
  • Set your video player preferences.
  • Sign up for's monthly newsletter, new release notifications, special announcements, and offers.
  • Authenticating your account and you will be able to re-enter the same session by going directly to Latest Release

Note: For Google Chrome users, you may need to click the "shield" icon Google Chrome - Shield Icon in the Address field to allow the browser to display the video.

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.