Print Page   |   Contact Us   |   Sign In   |   Join
Excel Formula Expert Series - Financial, Stats & Math - 5576
Tell a Friend About This EventTell a Friend
 

In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data.

10/14/2016
When: 9:00 AM - 11:00 AM
Where: Webinar/Webcast
United States
Contact: April Deneault

« Go to Upcoming Event List  

Acronym EX124W
CPE 2 hours
Category
Excel
Level Intermediate
Vendor CPA Crossings, LLC
Who should attend

All Excel users who want to become Excel Formula Experts

Prerequisite
None
Fees: Early Bird
Standard
Member N/A
$79
Non-Member: N/A
$79

Description: 
Did you know that Excel 2010 has 402 functions and Excel 2013 has 453 functions? Did you know there are 12 different function categories? Did you know you could create your own functions?

In this webinar, we will focus on Financial, Statistical and Math functions.  In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules.  In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data.




Specific topics include:

  • Financial functions best practices for creating amortization schedules and calculating annual interest payments
  • Calculating & summarizing data with SUMIF and SUBTOTAL functions
  • Statistical functions used to analyze data

Objectives

  • Create complex amortization schedules
  • Use math functions to make SUM functions more accurate
  • Analyze data using the statistical functions

 REGISTER HERE

 

Membership Management Software Powered by YourMembership  ::  Legal