Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book