101 Ready-to-Use Excel Formulas (Mr. Spreadsheet's Bookshelf)

101 Ready-to-Use Excel Formulas (Mr. Spreadsheet's Bookshelf)
101 Ready-to-Use Excel Formulas (Mr. Spreadsheet's Bookshelf)
English | EPUB, MOBI, PDF | 240 Pages | 11.2 MB
This is the sort of book that is well worth its space on the bookshelf. I recall using several of the formulas in this guide, but it has been long enough that most of them have slipped my mind. There are many interesting formulas that are new to me as well. This thin book is filled with practical excel formulas, presented in a concise manner. Introductory notes of sorts will precede a formula, with an explanation of how it works to follow. There are several alternatives offered, where applicable.

Early chapters provide formula fundamentals, and progressively move into more intricate formulas further in. There are basic formulas for totals, complex formulas that refer to other worksheets, lookup formulas, string concatenation formulas, conditional formulas, and all sorts of fun things to have within reach.

I love this handy little reference, and if the rest of the Mr. Spreadsheet’s Bookshelf series of books is anything like this, it would make for quite the collection of just the facts guides that minimize the need to rummage through pages. With 101 Ready-to-Use Excel Formulas, when you need it, you quickly find it, and then you’re done.

From the Back Cover

"Save time, automate, and be more productive with Excel Formulas"

Excel formulas can make your work easier and more productive, but it takes time to grasp the ins and outs of formulas. Do you need immediate help and don't have time to research the right formula for the job at hand? "101 Ready-to-Use Excel Formulas" arms you with the 101 most commonly used Excel formulas that will solve your problems now!

Learn to create and customize Excel Formulas through step-by-step instructions, tips, tricks, and detailed explanations. The book includes the downloadable working formulas so you can immediately implement and reuse them in multiple workbooks.

This book is sure to be your go-to reference as you quickly become an Excel Formulas expert!

"Let Mr. Spreadsheet show you how to: " Analyze operational data with business and financial formulas Leverage Excel's powerful statistical functions Complete data cleanup and transformation tasks faster Work with dates and time-based data Enhance conditional formatting with your own customized formulas

About the Author
Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel.