Excel Power User Module 3: Six Critical Excel Functions Webinar

Sep 26
11:00 - 1:00 p.m.

Online

2-Other
CPE Credits

  • Identify the keyboard shortcut for evaluating formula text.
  • Recall the arguments for the SUMIFS function.
  • Recognize the Excel feature that removes duplicate values within a range.

Highlights
  • Conditional summing basics with SUMIFS
  • Remove duplicates
  • Lookup basics
  • Improving VLOOKUP with MATCH
  • Improving VLOOKUP with VALUE and TEXT
  • Moving beyond VLOOKUP with INDEX

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. 4182983B Level: Update

Prerequisites:

Excel Power User Modules 1 and 2 or knowledge of the topics covered.

Notes

This webinar is hosted by PICPA's partner, The California Society of CPAs. After registering, you will receive an email from the California Society with the log-in information.

Speaker(s)

Jeff Lenning