Self-Study: Surgent's Microsoft® Excel® 2019: Exploring Useful Excel Functions

Overview

This course is a one-lesson intermediate level course that 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
• IF, AND, and IFNA Logical functions
• Quick Analysis feature

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, payment and depreciation
• Sel

  Preparation

  None

  Notice

  Download