Details

101 Ready-to-Use Excel Formulas


101 Ready-to-Use Excel Formulas


1. Aufl.

von: Michael Alexander, Richard Kusleika

27,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 14.07.2014
ISBN/EAN: 9781118902592
Sprache: englisch
Anzahl Seiten: 240

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<b>Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas</b> <p><i>101 Ready-to-Use Excel Formulas</i> is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work.</p> <p>Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. <i>101 Ready-to-Use Excel Formulas</i> is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.</p> <ul> <li>Teaches you how to implement the required Excel formula</li> <li>Explains and details how the formulas work</li> <li>Lets you reuse or customize the given formula to address your particular needs</li> <li>Helps you make the formulas a regular part of your new, more efficient workflow</li> </ul> <p>Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with <i>101</i> <i>Ready-to-Use Excel Formulas.</i></p>
Introduction 1 <p>Chapter 1: Introducing Excel Formulas 5</p> <p>Chapter 2: Common Mathematical Operations 21</p> <p>Chapter 3: Manipulating Text with Formulas 37</p> <p>Chapter 4: Working with Dates and Times 53</p> <p>Chapter 5: Performing Conditional Analysis 79</p> <p>Chapter 6: Using Lookup Formulas 103</p> <p>Chapter 7: Common Business and Financial Formulas 127</p> <p>Chapter 8: Common Statistical Analyses 157</p> <p>Chapter 9: Using Formulas with Conditional Formatting 183</p> <p>Index 205</p>
<p><b>Michael Alexander</b> is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit him at DataPigTechnologies.com. <b>Dick Kusleika</b> is 12-year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel blog (www.dailydoseofexcel.com).</p> <p><b>John Walkenbach</b> is arguably the foremost authority on Excel. He has written more than 30 books, hundreds of articles on Excel, and he created the award-winning Power Utility Pak.</p>
<p><b><i>Save time, automate, and be more productive with Excel Formulas</i></b></p> <p>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? <i>101 Ready-to-Use Excel Formulas</i> arms you with the 101 most commonly used Excel formulas that will solve your problems now!</p> <p>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.</p> <p>This book is sure to be your go-to reference as you quickly become an Excel Formulas expert!</p> <p><b><i>Let Mr. Spreadsheet show you how to:</i></b></p> <ul> <li><b>Analyze operational data with business and financial formulas</b></li> <li><b>Leverage Excel’s powerful statistical functions</b></li> <li><b>Complete data cleanup and transformation tasks faster</b></li> <li><b>Work with dates and time-based data</b></li> <li><b>Enhance conditional formatting with your own customized formulas</b></li> </ul>

Diese Produkte könnten Sie auch interessieren:

AutoCAD 2013 For Dummies
AutoCAD 2013 For Dummies
von: Bill Fane, David Byrnes
PDF ebook
23,99 €
IBM Workplace Services Express For Dummies
IBM Workplace Services Express For Dummies
von: Stephen R. Londergan, Michael Loria
PDF ebook
16,99 €
Building Flash Web Sites For Dummies
Building Flash Web Sites For Dummies
von: Doug Sahlin
PDF ebook
18,99 €