Excel Functions and Array Formulas

http://www.eventbrite.com/custombutton?eid=3853489892 (http://www.eventbrite.com/event/3853489892)

**Important: you must use the "Register Now" button to sign-up and pay for your spot at this event. Clicking "RSVP" won't allow you buy a ticket to this event, and won't save a spot for you.

Excel Saturday Intensive Training

Functions and Array Formulas (3 hours CPE)

Aug 25, 2012 8:30 am – 12:00 noon

Golden Gate University Room 2203

Excel functions are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you. This class will help you to learn about, and to solve problems with Excel functions and formulas.

Presented by: Experienced Excel user -Clinton Monroe, Joe Dion,Roger Nakaya, and Stephen Tin.

Session will cover:

Financial Functions NPV, IRR, SLN,SYD, DB

Date and Time Functions Date, Weekday, ..

Statistical Functions MAX, MIN,...

Text and Data Functions Left, Right, and MID

Logical Functions IF, ISERROR, OR, AND,...

Array Formulas SUMPRODUCT

This is a hands-on knowledge sharing session. Bring your own laptop to follow along.

Using a scroll mouse is recommended in navigating the spreadsheet.

No computer is provided by the organizer.

Schedule
8:30 am -9:00 am Check in & networking
9:00 am -12 noon Training session
*Complimentary light breakfast with bagels, coffee