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.