Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel Power User Module 3: Six Critical Excel Functions 4172983B
Register View Registrations Tell a Friend About This EventTell a Friend
 

The Excel Power User series helps you improve your Excel proficiency and quickly complete tasks. In this session, 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. Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.

 Export to Your Calendar 11/17/2017
When: 12:00 PM to 2:00 PM
Where: Webinar/Webcast
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10582


Online registration is available until: 11/17/2017
« Go to Upcoming Event List  

Curriculums:   Computers and Technology,Young and Emerging Professionals,Business and Industry

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

Description

The Excel Power User series helps you improve your Excel proficiency and quickly complete tasks.

In this session, 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.

Note: This session is presented with Excel for Windows. Items covered may not be available in Excel for Mac.

Materials are provided as an ebook.



Major Subjects

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

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.

Level:  Overview

Designed For

Accounting professionals who use Excel for Windows.

Advanced Prep:

None.

Prerequisite

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

Membership Management Software Powered by YourMembership  ::  Legal