Webcast: K2's Advanced Excel Functions and Formulas (XKAEF117)
Tell a Friend About This EventTell a Friend
 

Excel has more than 300 functions, many of which are unused by most accounting and finance professionals. Some of these little used functions can be used to calculate depreciation, mortgage interest and principal reduction, cash flow analysis over unequal periods, and trap errors. It's time for you to break out of your Excel cocoon. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and time saving but little used Excel functions. Among o

7/19/2017
When: 07/19/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

Acronym XKAEF117
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accountants and finance professionals who want to become more productive in using Excel
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

Excel has more than 300 functions, many of which are unused by most accounting and finance professionals. Some of these little used functions can be used to calculate depreciation, mortgage interest and principal reduction, cash flow analysis over unequal periods, and trap errors. It's time for you to break out of your Excel cocoon. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and time saving but little used Excel functions. Among other topics, you will learn about logical and conditional formulas, including using Boolean operators; advanced financial formulas such as XNPV and XIRR; innovative uses for Excel's date functions, and SUMPRODUCT, GETPIVOTDATA, and INDIRECT.

Objectives

Upon completing this course, you should be able to:

  • Use Excel's financial functions to compute depreciation, calculate mortgage interest and principal reduction, and perform conventional cash flow analysis
  • List three Excel functions for making conditional calculations that can evaluate multiple conditions
  • Explain the general process of entering an array formula in Excel
  • Describe the benefits of using GETPIVOTDATA for extracting summarized data from a PivotTable

Topics

  • Making advanced calculations with Excel's financial functions
  • Creating calculations that are dependent on a condition or conditions
  • Using array formulas to make calculations on a range of items
  • Building date and time calculations
  • Using GETPIVOTDATA to extract summarized data from a PivotTable
  • Employing INDIRECT to modify range references in formulas