« Back to Class Listing

Excelling at Excel: Formulas and Functions

Description

In this half-day course, students will discover introductory, intermediate, and advanced functions/formulas in Excel.

  • The introductory functions include SUM, AVERAGE, COUNT, and TODAY functions.
  • The intermediate functions include VLOOKUP/HLOOKUP, PMT, and CONCATENATE.
  • The advanced functions include IF…THEN…ELSE, SUMIFS, COUNTIFS, AVERAGEIFS, DSUM, and DCOUNT.

Audience: This course is designed for those who are current users of Excel and want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals" and "Excelling at Excel: The 5Fs."

Software: This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, you will be able to:
  1. Create and edit basic, intermediate, and advance functions
  2. Use all of the cell references in Excel – Relative, Absolute/Mixed, and 3-D
  3. Develop results with functions based on criteria
  4. Measure time in hours and minutes, days, and years
  5. Use Introductory functions – SUM, AVERAGE, COUNT, and TODAY
  6. Use Intermediate functions – VLOOKUP/HLOOKUP, PMT, and CONCATENATE
  7. Use Advanced functions – IF-THEN-ELSE, COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE

Section: MS-EXCEL-FORMFUN (19MAY17)
Dates: May 19, 2017 - May 19, 2017 Time: 9:30 AM
Tuition: $185.00 Instructor: Greg Creech Register

Lesson 1: Formula/Functions Syntax and Referencing
  • Symbols for continuous and noncontiguous formula/function ranges
  • Absolute and Mixed Reference symbols
  • 3-D and linkage symbols
  • Relative, Absolute/Mixed and 3-D References

Lesson 2: Introductory Formulas and Functions
  • SUM, AVERAGE, COUNT, COUNTA, TODAY
  • Calculating days and years
  • Linking worksheets with a formula/function (3-D Reference)

Lesson 3: Intermediate Functions
  • Financial – PMT
  • Text – CONCATENATE, LEFT/RIGHT
  • Lookup and Reference – VLOOKUP/HLOOKUP
  • Time – Calculating hours and minutes for timesheets

Lesson 4: Advanced Functions
  • IF…THEN…ELSE
  • Functions based on criteria - SUMIFS, AVERAGEIF, and COUNTIFS
  • Database functions: DSUM, DCOUNT, and DAVERAGE

Class Schedule

Date Times Meeting Type Location
05/19/2017 9:30 AM - 12:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 3.0