24SS-0006: Surgent's Microsoft 365: Exploring Useful Excel Functions (Self-Study)
Valid for one year from purchase date
Self-study - Downloadable PDF
6 CPE (6 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
This course is a one-lesson intermediate level course that guides you through using the Quick Analysis feature to quickly insert row and column totals and creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions. The functions covered in this course are the:
-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; and
-IF, AND, and IFNA Logical functions.
Major subjects
-
Multiple ways to create a formula using one or more functions
-
Financial functions to calculate the internal rate of return, net present value, future value, present value, payment and depreciation
-
Date & Time functions to insert date and time components
-
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
-
Statistical functions to find the average, maximum, minimum, count, median and mode of a range of numbers plus the top five numbers
-
Lookup & Reference functions to find specific data and document worksheet formulas
-
Specific criteria and Database functions to calculate the sum, average, maximum value, minimum value and number of cells containing numbers in a database field
-
Text functions to improve worksheet appearance
-
Logical functions to perform calculations based on one or more tests
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?
Users experienced with using Microsoft 365: Excel in the Windows operating system environment, or experienced Excel users switching from earlier versions of Excel.
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$119.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
|
Standard Member Fee |
$119.00
|
 Standard Nonmember Fee |
$119.00
|
