Self-Study: Surgent's Microsoft® Excel® 2016: Useful Functions for CPAs
Available Until
Self-Study
4.0 Credits
Member Price $65.00
Non-Member Price $85.00
Overview
This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.
Highlights
- 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.
Prerequisites
Experience working with Excel 2016 in the Windows operating system environment
Designed For
Experienced Excel 2016 users, or experienced Excel users switching from earlier versions.
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, payme
Preparation
None
Notice
Download
Non-Member Price $85.00
Member Price $65.00