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.

##### 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.

##### 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

@smuoit

### IT Training Staff

• Emily Blackmore
• Laurene Klassen

### Contact Info

• 214-768-1824
• ittraining@smu.edu