Description
Book SynopsisMr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas 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 problemalong with detailed explanation of how the formulas work.
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. 101 Ready-to-Use Excel Formulas 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
Table of Contents
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
