Excel Power User Module 3: Six Critical Excel Functions | EPU3OD19

Product Code :
Format :
Level :
Designed For :
Accounting professionals that use Excel for Windows.
Field of Interest :
Computer Software And Applications
Prerequisite :
Excel Power User Modules 2 or knowledge of the topics covered.
Credits :
2.00 CPE
Description :
Explore six important Excel functions that enable us to automate a variety of tasks, as well as continue to integrate these functions as we proceed throughout the series.

This is part 3 of a 10 part series
Objectives :
  • 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.
Major Topics :
  • Conditional summing basics with SUMIFS
  • Remove duplicates
  • Lookup basics
  • Improving VLOOKUP with MATCH
  • Improving VLOOKUP with VALUE and TEXT
  • Moving beyond VLOOKUP with INDEX
Advanced Prep :
About the Author :
Lenning Jeff S - Jeff S Lenning is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. He specializes in providing computer consulting services to CPA firms and their clients.