Unknown Title

Title:

Excel formulas & functions / by Ken Bluttman.

Author:

Bluttman, Ken author.

ISBN:

9781119839118

Personal Author:

Bluttman, Ken author.

Edition:

6th edition.

Physical Description:

xi, 398 pages : illustrations ; 24 cm

Content Type:

text

Media Type (RDA):

unmediated

Carrier Type:

volume

Series:

For dummies

--For dummies.

General Note:

Includes index.

"Learning made easy" -- Cover.

"Understand how functions and formulas work together ; use formulas to evaluate and forecast your financials ; practice with step-by-step example functions" -- Cover.

Contents:

Getting started with Excel formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Saying "array!" for formulas and functions ; Fixing formula boo-boos -- Doing the math. Calculating loan payments and interest rates ; Appreciating what you'll get, depreciating what you've got ; Using basic math functions ; Advancing your math -- Solving with statistics. Throwing statistics a curve ; Using significance tests ; Rolling the dice on predictions and probability -- Dancing with data. Dressing up for date functions ; Keeping well-timed functions ; Using lookup, logical, and reference functions ; Digging up the facts ; Writing home about text functions ; Playing records with database functions -- The part of tens. Ten tips for working with formulas ; Ten ways to get fancy with Excel ; Ten really cool functions.

Abstract:

This thorough guide to Excel formulas and over 100 of the most popular functions covers the basics of setting up formulas as well as more advanced skills such visualizing data.

Title Subject:

Microsoft Excel (Computer file)

Subject Term:

Electronic spreadsheets -- Computer programs.

Business -- Computer programs.

Genre:

Handbooks and manuals.

Format:

Books

Available:*

Library	Item Barcode	Shelf Number	Status
Searching... Lockport Public Library	34094004826148	005.54 BLUTTMAN	Searching... Unknown

Bound With These Titles

On Order

Summary

Unlock the power of Excel with a step-by-step roadmap to its formulas and functions

There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel.

If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro.

For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions.

This easy-to-use Excel formulas and functions survival guide shows you how to:

Work with financial functions like PMT, PPMT, NPER, RATE, and PV Calculate mean, median, mode, standard deviation, and many more statistical functions Troubleshoot formulas for common errors and validate your data to avoid mistakes Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions

You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.

Author Notes

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of Excel Charts For Dummies and all previous editions of Excel Formulas & Functions For Dummies.