Equipped with a variety of functions and easy to use, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. But most users only scratch the surface of the program's functionality, especially the built-in formulas designed to make everyday operations and real-world tasks more efficient. Microsoft Excel Functions & Formulas demonstrates the secrets of Excel functions through the use of practical and useful examples in a quick reference format. Topics include logical, text, date and time, basic statistical, mathematical, financial, database, and reference functions as well as conditional formatting with formulas, array formulas, and user-defined functions.
Excel is the well-known standard spreadsheet application that allows you to easily perform calculations and recalculations of data by using numerous built-in functions and formulas. Although you may be familiar with simple functions such as SUM, this is just one of the many Excel functions and formulas that can help you simplify the process of entering calculations. Because there are so many other useful and versatile functions and formulas inside Excel that most users haven’t discovered yet, this book was written to help readers uncover and use its wide range of tools.
For each function or formula, we started with a simple task that can be solved with Excel in an efficient way. We added tips and tricks and additional features as well to provide deeper knowledge and orientation. After you have stepped through all the lessons, you will have a great toolbox to assist you with your projects and make many everyday workbook tasks much easier.