Excel Training by K2 Technologies

Learn Advanced Excel Functions

November 14, 11 a.m. mountain

Microsoft Excel: Top Essential Functions Part 1

There are almsot 500 functions built into Microsoft Excel.  Learn data analysis formulas to use your worksheets more efficiently.

This workshop will:

  1. Review function basics
  2. Describe absolute versus relative references
  3. Create named ranges
  4. Review functions you can use in your worksheets like IF, IFS, COUNTIF, SUMIF, and AVERAGEIF

December 12, 11 a.m. mountain

Microsoft Excel: Top Essential Functions Part 2

This workshop will cover:

  1. The VLOOKUP and XLOOKUP functions
  2. The tricks and traps of working with date values
  3. Leveraging functions to combine and extract text

Share:

Register to Receive the Tech Joke of the Week!

This Week's Joke:

How many programmers does it take to change a light bulb?

None, it is a hardware problem!

More Posts: