Microsoft® Excel® 2013: Sampling Useful Functions

Microsoft® Excel® 2013: Sampling Useful Functions

Course Description

Microsoft® Excel® 2013: Sampling Useful Functions 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. 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.



Using the new Quick Analysis feature to quickly insert row and column totals is also discussed.

Prerequisite

The Napier & Rivers courses Microsoft® Excel 2013: Getting Started with Excel and Microsoft® Excel®2013: Working with Formulas and Functions or equivalent experience working with Excel 2013 in the Windows operating system environment are prerequisites for this course.


Note that this course emphasizes using the traditional keyboard and mouse actions to perform tasks in Excel 2013. Some relevant tips for working with Excel 2013 with a Windows 8 touch-screen device are also provided.