Skip to main content

Surgent's Microsoft 365: Exploring Useful Excel Functions

Available Until

Self-study

6.00 Credits

Member Price $119.00

Non-Member Price $169.00

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.

Highlights

  • 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

Prerequisites

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

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.

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

Preparation

None

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by Surgent Professional Education. The course expires one year from the purchase date. Format = text only download.

Non-Member Price $169.00

Member Price $119.00