101 Ready-To-Use Excel Formulas

Provides over one hundred commonly used Excel formulas, with step-by-step instructions for creating and customizing formulas for specific business needs, including manipulating text, conditional analysis, financial formulas, and statistical analyses.

List 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

Product details

• Authors: M Alexander, Michae Alexander, Michael Alexander, Michael (McKinney Alexander, Michael Kusleika Alexander, Dick Kusleika, Richard Kusleika, Kusleika Richard
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 19.09.2014
• EAN: 9781118902684
• ISBN: 978-1-118-90268-4
• No. of pages: 240
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > Application software; Excel, Microsoft Excel, End-User Computing, Computer-Ratgeber