Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

20SS-0139: Surgent's Microsoft Excel 365/Excel 2019: Useful Functions for CPAs (Self-Study)

Valid for one year from purchase date
Self-study - Downloadable PDF
4 CPE (4 non-technical)

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Alternate dates & more options

Microsoft Excel 365/Excel 2019: Useful Functions for CPAs is a one-lesson intermediate level course that guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.

Major subjects

  • IRR, NPV, FV, PV, PMT, SLN, SYD, and DB Financial functions
  • NOW, TODAY, DATE, MONTH, DAY, YEAR, TIME, HOUR, MINUTE, SECOND, WEEKDAY, and NETWORKDAYS Date & Time functions
  • SUM, RAND, SQRT, and ROUND Math & Trig functions
  • AVERAGE, MAX, MIN, COUNT, MEDIAN, MODE.SNGL, and LARGE Statistical functions
  • VLOOKUP, HLOOKUP, and FORMULATEXT Lookup & Reference functions
  • DSUM, DCOUNT, DAVERAGE, DMIN, and DMAX Database functions
  • PROPER, SUBSTITUTE, and LOWER Text functions
  • IF, AND, and IFNA Logical functions
  • Using the Quick Analysis feature to quickly insert row and column totals is also discussed

Learning objective(s)

  • Identify multiple ways to create a formula using one or more functions
  • Select Financial functions to calculate the internal rate of return, net present value, future value, present value, payment and depreciation
  • Select Date & Time functions to insert date and time components
  • Select Math & Trig functions to calculate the sum of a range of numbers, find a random number and the positive square root of a number, and round calculations to a specific number of places
  • Select Statistical functions to find the average, maximum, minimum, count, median and mode of a range of numbers plus the top five numbers
  • Select Lookup & Reference functions to find specific data and document worksheet formulas
  • Select specific criteria and Database functions to calculate the sum, average, maximum value, minimum value and number of cells containing numbers in a database field
  • Select Text functions to improve worksheet appearance
  • Select Logical functions to perform calculations based on one or more tests

Who should take this program?

Experienced Excel 2016 users, or experienced Excel users switching from earlier versions.

Fees

Our records indicate you are a nonmember. If you register, you will be charged $65.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Standard Member Fee $65.00
checkmark Standard Nonmember Fee $65.00

More program information

Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (4.0)
Level Intermediate
Format Self-study - Downloadable PDF
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. Experience working with Excel 2016 in the Windows operating system environment
Advance
prep
None

If the organization paying for the purchase is exempt from sales tax, call us at 952-831-2707 to complete your purchase.

Add to cart

Not a member? Join the MNCPA to start saving on CPE and accessing members-only benefits.

Search CPE catalog