• ID: 2755309
• Book
• 240 Pages
• John Wiley and Sons Ltd
1 of 4
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
Note: Product cover images may vary from those shown
2 of 4
Introduction 1

Chapter 1: Introducing Excel Formulas 5

Chapter 2: Common Mathematical Operations 21

Chapter 3: Manipulating Text with Formulas 37

Chapter 4: Working with Dates and Times 53

Chapter 5: Performing Conditional Analysis 79

Chapter 6: Using Lookup Formulas 103

Chapter 7: Common Business and Financial Formulas 127

Chapter 8: Common Statistical Analyses 157

Chapter 9: Using Formulas with Conditional Formatting 183

Index 205
Note: Product cover images may vary from those shown
3 of 4

4 of 4
Michael Alexander is a Microsoft Excel MVP who has written several books on advanced business analysis with Microsoft Access and Excel. Visit him at DataPigTechnologies.com. Dick Kusleika is 12–year Microsoft Excel MVP and the principal contributor at the Daily Dose of Excel blog (www.dailydoseofexcel.com).

John Walkenbach 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.
Note: Product cover images may vary from those shown
5 of 4
Note: Product cover images may vary from those shown