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 $79 (On Demand)

Downloadable PDF

Credits: 4

Qualifies For: CPE

$79

Textbook

Credits: 4

Qualifies For: CPE

$139
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
    Computer Software and Applications
  • 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 an unlimited CPE package

Unlimited Plus

  • 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

  • Does NOT include select+ courses

$849

 BUY NOW 

Unlimited Webinars

  • Unlimited access to all non-premium live CPE webinars

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

  • Access for a year from purchase date

  • Does NOT include Premium courses and select+ courses

$699

 BUY NOW 

 


Unlimited Self-Study

  • 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 and select+ courses

$499

 BUY NOW 

 

 


+Courses not included: ETDE, ETTX, Annual Tax Refresher, Surgent Interactive games and certification courses. Exclusions may change at any time.

 

Explore additional courses by topic

  • Accounting and Auditing CPE courses

    Accounting &
    Auditing

  • Business and Industry CPE courses

    Business &
    Industry

  • Ethics CPE courses

    Ethics

  • Financial Planning CPE courses

    Financial
    Planning

  • Fraud and Forensics CPE courses

    Fraud &
    Forensics

  • Government and Non-Profit CPE courses

    Government/
    Non-Profit

  • Personal Development CPE courses

    Personal
    Development

  • Practice Management CPE courses

    Practice
    Management

  • Taxes CPE courses

    Taxes

  • Tech CPE courses

    Tech

 

Qualifies for

CFP CFP® Board-approved CE for Certified Financial Planners


CMA IMA-approved CE for Certified Management Accountants

CPE NASBA-approved CPE for Certified Public Accountants


CTEC California Tax Education Council-approved CE

IRS IRS-approved CE for Enrolled Agents and the AFSP


YB GAO-fulfilling Yellow Book audit requirements

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.