Excel: Formulas and Functions

View Enrollment Details

Course Outline

• 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. Name Box and Name Manager
  • Name cells, tables, and areas of a worksheet
  • Use Names for:
    • Absolute Reference
    • Navigation
    • Selection
    • Values
    • Formulas and Functions
      
      
• Lesson 4. Intermediate Functions
  • Financial - PMT
  • Text - CONCATENATE, LEFT/RIGHT
  • VALUE and DATEVALUE
    
    
• Lesson 5. Advanced Functions
  • Lookup and Reference - VLOOKUP/HLOOKUP
  • IF:THEN:ELSE

Learner Outcomes

After completing this course, participants will be able to:

• Create and edit basic, intermediate, and advance functions with ease
• Use all of the cell references in Excel—Relative, Absolute/Mixed, and 3-D
• Develop results with functions based on criteria
• Employ the Name Box and Name manager for cell referencing and productivity in Excel
• Use Introductory functions—SUM, AVERAGE, COUNT, and TODAY
• Use Intermediate functions—PMT and CONCATENATE
• Build drop down lists and error alerts using Data Validation
• Use Advanced functions—VLOOKUP/HLOOKUP, SUMIFS, DSUM, and IF-THEN-ELSE.

Course Schedule