Surgent's Microsoft 365: Exploring Useful Excel Functions

Available Anytime

Location: Online

6Credits

Technical Business

Registration is Open

FICPA Members

~~$119.00 Regular Price~~

Nonmembers

$154.00 Regular Price

Please Login to Register

Please Select co-workers you wish to register from the list:

	Name	Email	Firm Office

Product Code: SU24-365U-SSDL

Level: Intermediate

Vendor: Surgent

Field of Study: Computer Software and Applications

Overview:

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 Topics:

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

Designed For:

Users experienced with using Microsoft 365: Excel in the Windows operating system environment, or experienced Excel users switching from earlier versions of Excel.

Prerequisite:

Experience working with Microsoft 365: Excel in the Windows operating system environment

Additional Info:

You will receive an email from [email protected] with instructions on how to log onto your course shortly. If you do not receive the email within the hour, please check your spam filter.

For technical support, registration questions or other customer service-related inquiries, please call (800) 778-7436 or email [email protected]. Phones are staffed from 8:30 a.m. to 5:00 p.m. Eastern Time, Monday through Thursday, and 8:30 a.m. to 4:00 p.m. Eastern Time on Friday.