The Basics Of Excel Functions: Using Logical, Lookup And Basic Statistical/mathematical Functions
by E Atkins /
2017 / English / Kindle
594.8 KB Download
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.
