Pages

Ebook excel formula and function for dummies 3th edition

​Introduction
Spreadsheets are such a mainstay in today's world; the term is almost a household word. Certainly in my home it is. And I don't just mean because I write books on Excel. Spouses use Excel to track household expenditures and insurance claims. A neighbor analyzes his eBay transactions in excel. Our local merchant keeps tabs on his store's inventory on a worksheet.
In the workplace, Excel is one of the most commonly used analysis and reporting tools. Financial statements, sales reports, inventory, project scheduling, customer activity — so much of this stuff is kept in Excel. The program's ability to manipulate and give feedback about the data makes it attractive.

About This Book
This book is about the number-crunching side of Excel. Formulas are the keystone to analyzing data — that is, digging out nuggets of important information. What is the average sale? How many times did we do better than average? How many days are left on the project? How much progress have we made? That sort of thing.
Formulas calculate answers, straight and to the point. But that's not all. Excel has dozens of built-in functions that calculate everything from a simple average to a useful analysis of your investments to complex inferential statistics. But you don't have to know it all or use it all; just use the parts that are relevant to your work. This book discusses more than 150 of these functions. But rather than just show their syntax and list them alphabetically, I have assembled them by category and provided real examples of how to use them alone, and in formulas, along with step-by-step instructions and illustrations of the results.

How to Use This Book
You do not have to read the book sequentially from start to finish, although you certainly can. Each chapter deals with a specific category of functions — financial www.it-ebooks.info 2 Excel Formulas and Functions For Dummies, 3rd Edition in one chapter, statistical in another, and so on. Some categories are split over two or more chapters. I suggest two ways for you to use this book:
✓ Use the Table of Contents to find the chapters that are of interest to you.
✓ Use the Index to look up specific functions you are interested in