Download ~ Microsoft® Excel® 2013: Sampling Useful Functions by H. Albert Napier, PhD & Ollie N. Rivers ~ Book PDF Kindle ePub Free

eBook details

Title: Microsoft® Excel® 2013: Sampling Useful Functions
Author : H. Albert Napier, PhD & Ollie N. Rivers
Release Date : January 29, 2014
Genre: Computers,Books,Computers & Internet,
Pages : * pages
Size : 4654 KB

Description

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.