Text

6 CPE

Surgent's Microsoft 365: Exploring Useful Excel Functions

This is a text-based course

Text
6 CPE

This is a text-based course. To receive credit, you are required to review all content and achieve a minimum score of 70% on the final exam.

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.

Learning 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

CPE Credits Available

6 CPE
6
Computer Software & Applications

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Technology

Prerequisites

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

Advanced Preparation

None

Intended Audience

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

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 119 119
    Join

  • COCPA Non-Member

    $ 155 155
    Your Price

Please login to register.