SelfStudy
Surgent's Microsoftr Excelr 365/Excelr 2019: Useful Functions for CPAs (EXUF)

Wednesday, January 29, 2020 – Friday, April 30, 2021


4CREDITSComputer Software and Applications
Microsoftr Excelr 365/Excelr 2019: Useful Functions for CPAs is a onelesson intermediate level course that guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.
Objectives
 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
Highlights
 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