Bibliograph

Excel formulas & functions, by Ken Bluttman

Type

Label

Excel formulas & functions, by Ken Bluttman

Language

eng

Illustrations

illustrations

Index

index present

Literary Form

non fiction

Main title

Excel formulas & functions

Responsibility statement

by Ken Bluttman

Series statement

For dummies

Summary

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

Table Of 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

Target audience

adult

resource.variantTitle

Excel formulas and functionsMicrosoft Excel formulas & functions for dummiesExcel formulas & functions for dummiesMicrosoft Excel formulas and functions for dummiesExcel formulas and functions for dummies

Classification