Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft® Excel® 2016: Useful Functions for CPAs (UF16)

Choose CPE Format:

Self-Study SELECT STARTING AT $65 (On Demand)

Downloadable PDF

Credits: 4

Qualifies For: CPE

$65

Textbook

Credits: 4

Qualifies For: CPE

$80
It went over functions I have not used before that will be very useful.
Marc M.

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

Microsoft® Excel® 2016: Useful Functions for CPAs (UF16)

  • Customer Rating
    (6)
  • Field of Study
    Spec. Knowledge
  • Level
    Intermediate
  • Credits
    4
  • Qualifies for

    CPE

Overview

This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.

Major Topics:

  • 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; and
  • Select Logical functions to perform calculations based on one or more tests.

Designed for:

Experienced Excel 2016 users, or experienced Excel users switching from earlier versions.

Prerequisite:

Experience working with Excel 2016 in the Windows operating system environment

Advanced Preparation:

None

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:


Loading...

Thank You!

Thank You! Your request has been submitted.



Get More with a Surgent CPE package

Unlimited Self-Study Package

  • Unlimited 24/7 access to 200+ downloadable self-study courses

  • Courses range from 2-20 credits

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses

$499

Buy Now

Unlimited Webinar Package

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1-, 2-, 3-, 4-, and 8-hour webinars, including Saturday and evening options

  • Access through December 31st of the year in which you purchase

  • Does NOT include Premium courses

$599

$449

Buy Now

 

Unlimited Plus Package

  • Unlimited access to ALL live CPE webinars

  • Includes all premium courses and virtual conferences

  • Unlimited 24/7 access to all self-study courses

  • Includes all on-demand webcasts

  • Access for a year from purchase date

$799

Buy Now
  • CPE Continuing Professional Education for CPAs

  • IRS Continuing Education for EAs and the AFSP program

  • CFP Accepted by the CFP® Board

  • YB YellowBook Continuing Education

  • CTEC Approved for CE by CTEC

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.



Explore Additional Courses by Topic