Loading Events

« All Events

  • This event has passed.

Excel 2010: Formula/Functions

May 20 @ 8:30 am - 4:00 pm

| $ 325.00

This workshop is designed for the more sophisticated user of Excel.  You will learn to create formulas and perform calculations involving date and time.  Use database functions and filters to extract information needed from a worksheet.  Do some data analysis using Excel’s Statistical functions.  Use Goal Seek to work a function “backwards”. Activities covered include: Tracking elapsed time.  Common Math and Statistical functions. Generating random numbers:RAND. The IF function. Using multiple lookup tables. Creating drop-down lists with Data Validation. Financial functions with common arguments. Using the concatenation operator and much more.  MATCH and INDEX, looking up values in a two-dimensional table, using array formulas, matching values in ranges, tagging duplicate entries, extracting unique/common values, working with SUM and AVERAGE with multiple conditions.  Look at DSUM, DAVERAGE, DMIN, DMAX, DCOUNT, DCOUNTA, DGET and SUBTOTAL. Work on Standard deviation: STDEV,STDEVP and MEDIAN, PERCENTILE, PERCENTRANK, RANK.   Also math functions like: DEGREES/RADIANS, PI, SQRT, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, TRUNC. Top off the day with Types of errors, trapping errors, and tracing errors.

Register for this Class Now!

Details

Date:
May 20
Time:
8:30 am - 4:00 pm
Cost:
$ 325.00

Venue

DCG
1551 Bond Street
Naperville, IL 60563 United States
+ Google Map
Phone:
630.717.8400
Website:
dcg-inc.com

Organizer

DCG