The Basics of Excel Functions: Using logical, lookup and basic statistical/mathematical functions

Posted By: naag
The Basics of Excel Functions: Using logical, lookup and basic statistical/mathematical functions

The Basics of Excel Functions: Using logical, lookup and basic statistical/mathematical functions
English | 2017 | ASIN: B0758NFFPN | 29 pages | AZW3 | 0.5 Mb

This is a guide to using the basic functions in Microsoft Excel 2016. It includes logical functions (IF, AND, NOT, OR); lookup functions (LOOKUP, VLOOKUP, HLOOKUP, MATCH); basic statistical functions (AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTBLANK, COUNTIF, MAX, MIN, MEDIAN, MODE); useful maths, text and date functions (SUM, SUMIF, SUMIFS, DATE, DAYS, FIND, ROUND, RAND, RANDBETWEEN, PROPER). A really useful guide for someone getting into Microsoft Excel, or needing to learn the basics for a job. Each section includes a detailed description of each function and its arguments, and examples to better understand how it works, including examples using multiple functions.