Surgent's Microsoft 365: Exploring Useful Excel Functions

Overview

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.