OIT Technology News: March 2014

Spring IT Training

Mastering Basic Formulas & Functions

90 min. Hands-on

This foundational course will introduce you to the basics of building formulas in Excel 2013. This session will explore how to name groups of data, create basic formulas using built-in functions and arithmetic operators; using the basic functions SUM, AVERAGE, COUNT, MAX and MIN and finding and correcting errors in calculations.

Using Advanced Formulas

90 min. Hands-on

This course will focus on building more advanced formulas to help analyze and summarize your data. We’ll cover the basics of working with formulas, absolute and relative references, compound formulas and more. The following functions will be covered: Vlookup and Hlookup, COUNTIF, SUMIF and AVERAGEIF, IF, AND, NOT and OR statements, Date and time functions, and several text functions. This is an intermediate level course so attendees should be comfortable working in Excel.

Adobe Creative Tools

50 min. Webinar

Ever wondered what all those Adobe programs do? Or, why use one instead of another? Adobe Creative Cloud comes with a host of Creative tools. We will briefly introduce you to over 15 different programs, and then focus on four of the most common: Photoshop, Illustrator, InDesign, and Acrobat.

Creating Images and Icons

50 min. Webinar

Ever spent time searching for an illustration and wished you could create your own? Learn simple ways to make graphics using InDesign’s drawing tools. These skills can also be used in other Creative Suite programs.

Workshop Schedule

How do I register? click here

Upon registration a confirmation will be sent indicating the location of the class.

3/25 11 am  Excel: Basic Formulas (webinar) Register
3/27 3:30 pm Adobe Creative Tools (webinar)  Register
4/2  1 pm  Excel: Basic Formulas  Register
4/15 1 pm  Excel: Advanced Formulas  FULL
4/22 3 pm Creating Images & Icons (webinar) Register
4/23  1 pm  Excel: Advanced Formulas  Register
5/2  10:30 am  Excel: Advanced Formulas  Register