did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781118902684

101 Ready-to-use Excel Formulas

by ;
  • ISBN13:

    9781118902684

  • ISBN10:

    1118902688

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2014-08-11
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $39.99 Save up to $3.90
  • Rent Book $36.09
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 2-3 BUSINESS DAYS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

Supplemental Materials

What is included with this book?

Summary

Mr. 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 problem—along 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 easily test the formulas and provides visual confirmation of the concepts presented.

  • Teaches you how to implement the required Excel formula
  • Explains and details how the formulas work
  • Lets you reuse or customize the given formula to address your particular needs
  • Helps you make the formulas a regular part of your new, more efficient workflow

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 101 Ready-to-Use Excel Formulas.

Author Biography

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.

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

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program