Surgent's Microsoft 365: Exploring Useful Excel Functions - Download
May 1st, 2024 - April 30th, 2025
| Member Price | $119.00 |
| Non-Member Price | $149.00 |
| If you are a member, please login to activate member pricing. | |
Credits
6Description
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.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
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