Print Page   |   Contact Us   |   Sign In   |   Join
Excel Power User Module 3: Six Critical Excel Functions (4152983B)
View Registrations Tell a Friend About This EventTell a Friend
 

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In this session, we'll explore six important Excel functions that enable us to automate a variety of tasks. We'll 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.

10/2/2015
When: 10/02/2015
12:00 PM - 2:00 PM
Where: Webcast/Webinar
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-834-6634


Online registration is closed.
« Go to Upcoming Event List  

The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly.
In this session, we'll explore six important Excel functions that enable us to automate a variety of tasks.
We'll 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.

  

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 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

 

Designed For:

Accounting professionals that use Excel for Windows.
 

Prerequisite: Excel Power User Modules1 and 2 or knowledge of the topics covered.

 

Advanced Prep: None

  

Speaker: Jeff S. Lenning, CPA, CITP

Vendor: CalCPA

Field of Study: Info Tech

Level:  Overview

CPE Credit: 2 hours

Acronym: EPU3

 

Registration Fees:

Members: $70

Nonmembers: $94

 

Meet the Speaker:

Jeff Lenning of Click Consulting, Inc., is a CPA and published author.  He has written several articles for the Journal of Accountancy and other publications.  His firm specializes in providing computer consulting services to CPA firms and their clients.

Membership Management Software Powered by YourMembership.com®  ::  Legal