Powered by KU Information Technology
  • Home
  • Excel - Advanced Formulas and Functions

Excel - Advanced Formulas and Functions

What you should already know: 

You should have an intermediate level of skill in Excel 2013. You should be able to create spreadsheets, rows, columns, formulas, and functions.

Course objectives: 

By the end of this course, participants will be able to:

  • Understand the basic structure of formulas and functions
  • Use logical functions such as IF to perform calculations on line items
  • Use conditional functions such as SUMIF to summarize specified data in a worksheet
  • Use text functions to combine, extract, transform, and trim text in cells
  • Use date and time functions, such as TODAY, YEAR, and DAYS, to calculate spans of time
  • Use LOOKUP, VLOOKUP, and HLOOKUP to automatically reference values contained on other worksheets or to combine worksheets
Course outline: 
  • Logical Functions
    • IF Function
    • Use functions to apply conditional formatting
    • Nested IF Functions
    • OR, AND, NOT Functions
    • OR, AND, NOT Nested Functions
    • IFERROR
  • Conditional Functions
    • SUMIF, AVERAGEIF, COUNTIF
    • SUMIFS, AVERAGEIFS, COUNTIFS
  • Text Functions
    • LEFT, RIGHT, MID
    • FIND
    • TRIM
    • CONCATENATE
    • UPPER, LOWER
  • Date and Time Functions
    • NOW
    • TODAY
    • YEAR
    • DAYS360
    • NETWORKDAYS
    • WEEKDAY

Part 2

  • LOOKUP Functions
    • LOOKUP
    • VLOOKUP
    • HLOOKUP
Software tag: 
Audience tag: 

Link to KU IT's YouTube  Powered by KU IT 

Training Workshops

KU faculty, staff and students can sign up for courses at no cost at workshops.ku.edu.

Share your feedback

Would you like to see added or updated content on this site? Let us know by completing this quick form.