• Book Name: Learn Excel Top Functions Quick Reference Guide with 500 Examples by Scott Ratliff
• Author: Scott Ratliff
• Pages: 147
• Size: 1 MB

Learn Excel Top Functions by Scott Ratliff PDF

Knowing how to use the built-in functions in Microsoft Excel will turn you into a power user! There are hundreds of functions and at first, the list can seem overwhelming. Even as a Microsoft Office Expert in Excel 2013 I do not know all of the Excel functions available. In writing this eBook, I discovered several new functions that I have now incorporated into my daily use and have made my data analysis more efficient. I hope that this eBook will help you learn more of the Excel functions and that they would help you gain control over your spreadsheets!

Why Lean Excel? This Lean Excel series focuses on time-saving tools that will help you reduce the waste associated with data analysis. One of the tenets of lean manufacturing theory is using specialized tools to accomplish a task. You could use a wrench to drive a nail but a hammer will get the job done much faster. Remember time is money. Think of the built-in functions as specialized tools. Let’s say you needed to find the average of a dataset that is in A1 through A5. Remember the average is the sum of all the numbers in a dataset divided by the count of numbers in that dataset. Let’s look at three ways to find the average.

First, you could use the formula =(A1+A2+A3+A4+A5)/5. Second, you could use the SUM and COUNT functions =SUM(A1:A5)/COUNT(A1:A5). Or lastly, you could use the AVERAGE function =AVERAGE(A1:A5). Although all three options give you the same answer, using the AVERAGE function is clearly the most efficient. But in order to use the AVERGE function, you need to know that it exists and what requirements you need to use it.

Learn excel top functions by scott ratliff pdf.