Excel Formulas & Functions For Dummies
- ISBN-10
- 1119839114
- ISBN-13
- 9781119839118
- Category
- Computers
- Pages
- 419
- Language
- English
- Published
- 2021-12-21
- Publisher
- John Wiley & Sons
- Author
- Ken Bluttman
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, 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.
Get the book
Other editions
Similar books
-
Excel Formulas and Functions For Dummies
By Ken Bluttman, Peter G. AitkenRoll up your sleeves and start working with functions from ABS to ZTEST Get your hands dirty and dig for the nuggets in your data! This book shows you how, walking you through over 150 built-in functions in Excel 2010.
-
Excel Formulas and Functions For Dummies
By Ken Bluttman, Peter G. AitkenRoll up your sleeves and start working with functions from ABS to ZTEST Get your hands dirty and dig for the nuggets in your data! This book shows you how, walking you through over 150 built-in functions in Excel 2010.
-
Microsoft Office Excel 2007 Formulas and Functions For Dummies
By Ken Bluttman, Peter G. AitkenThis book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing?
-
Excel All-in-One For Dummies
By Greg Harvey, Paul McFedriesBeing able to control which outline level is displayed in the worksheet makes it easy to print summary reports with ... when compared to word-processing outlines is that, most often, to calculate your summary totals in the worksheet, ...
-
Excel 2019 For Dummies
By Greg HarveyThe bestselling Excel book on the market — now in a new edition covering the latest version of Excel!
-
Excel Data Analysis For Dummies
By Paul McFedriesThis book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet.
-
Excel Data Analysis For Dummies
By Stephen L. Nelson, E. C. NelsonMost businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert.
-
Financial Modeling in Excel For Dummies
By Danielle Stein FairhurstThis book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more.
-
101 Most Popular Excel Formulas
By Bryan Hong, John MichaloudisLearn the Most Popular Excel Formulas Ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, plus Many More! You'll learn to apply the Top Excel Formulas to make your data analysis easier.
-
Microsoft Excel 2010 Formulas and Functions Inside Out
By Egbert Jeschke, Helmut Reinke, Sara UnverhauCustomize Excel formulas using 350+ built-in functions Create reusable formulas for common calculations Learn smarter ways to calculate date and time values Systematically search worksheets with lookup and reference functions Perform ...