Excel Formulas and Functions For Dummies

by Ken Bluttman, Peter Aitken

for Dummies Computers and Internet, for Dummies

123 Members ½ (3.33)

On This Page

Quick Facts

Description

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, show more 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. show less

Tags

More Tags

Recommendations

Complete Recommendations

Member Reviews

Members

Recently Added By
All Members

Author Information

Ken Bluttman
19 Works 293 Members
Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written numerous articles and books on a variety of technical topics. His latest projects include large-scale cloud-based applications and mobile app development.
Peter Aitken
18 Works 175 Members

Series

for Dummies Computers and Internet
995 works
for Dummies
2162 works

Classifications

Genres
Technology, Nonfiction, Business, General Nonfiction
DDC/MDS
005.54 — Computer science, information & general works Computer science, knowledge & systems Artificial Intelligence/Virtual Reality General purpose application programs Spreadsheet Software
LCC
HF5548.4 .M523 .B5837 — Social sciences Commerce Commerce Business Office management
BISAC
More Classifications

Statistics

Members
123
Popularity
265,366
Rating
½ (3.33)
Languages
English, Italian, Korean
Media
Paper, Ebook
ISBNs
20
ASINs
4