Events Search
  Summary & Check Out (0)

Microsoft® Excel® 365/Excel® 2019: Useful Functions for CPAs (Z1-EXUF-2022-01-SSDL)

200 Minutes
On demand - Audio

On Demand - Audio

4 CPE Credits in SK

OVERVIEW

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.

DESIGNED FOR

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

BENEFITS

  • 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

HIGHLIGHTS

  • 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

COURSE LEVEL

Intermediate

PREREQUISITES

Experience working with Excel 2016 in the Windows operating system environment

PRICING

$79.00 - Member

$99.00 - Nonmember

ADDITIONAL OPTIONS

Remind me to register

Print a registration form

COURSE DEVELOPER

Surgent