Excel Formulas & Functions For Dummies
By Ken Bluttman
()
About this ebook
Put the power of Excel functions to work in your formulas
There are more than 400 built-in functions in Excel 2019, from AGGREGATE to Z.TEST. The question is which ones will make your work easier? How and why should you use a particular function in your formulas? Excel Formulas and Functions For Dummies offers thorough but easy-to-read coverage of powerful Excel functions.
With this book, you’ll learn to apply the power of Excel functions and formulas to make your work and other tasks easier. Compare 15-year vs. 30-year mortgage terms, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit card purchases, or forecast college expenses and savings. All of this and more is possible when you master functions and formulas in Excel. Although it covers the latest software version, Excel 2019, the techniques and functions described in this book can be used on any version of Excel.
- Step-by-step instruction on Excel's 150 most useful functions
- Each function is illustrated by helpful, real-world examples
- 85 specialized functions are described in abbreviated form
- Includes Excel’s must-know functions
This book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel’s powerful built-in functions.
Ken Bluttman
Ken Bluttman is the author of numerous computer books and articles. He recently wrote O'Reilly's "Access Hacks" as well as "Excel Charts for Dummies". Ken's technical chops include Microsoft Office, XML, VBA, VB.NET, SQL Server, and assorted web technologies.
Related to Excel Formulas & Functions For Dummies
Related ebooks
Teach Yourself VISUALLY Microsoft 365 Rating: 0 out of 5 stars0 ratingsTableau For Dummies Rating: 4 out of 5 stars4/5Excel 2003 Formulas Rating: 4 out of 5 stars4/5PowerPoint For Dummies, Office 2021 Edition Rating: 0 out of 5 stars0 ratingsMicrosoft 365 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Macros For Dummies Rating: 3 out of 5 stars3/5Excel VBA Programming For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2007 All-In-One Desk Reference For Dummies Rating: 3 out of 5 stars3/5Excel Data Analysis For Dummies Rating: 0 out of 5 stars0 ratingsExcel All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsJavaFX For Dummies Rating: 0 out of 5 stars0 ratingsExcel Sales Forecasting For Dummies Rating: 4 out of 5 stars4/5Excel Formulas & Functions For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2019 For Dummies Rating: 3 out of 5 stars3/5Excel Macros For Dummies Rating: 0 out of 5 stars0 ratingsOutlook 2019 For Dummies Rating: 3 out of 5 stars3/5Data Mining For Dummies Rating: 4 out of 5 stars4/5Excel Power Pivot and Power Query For Dummies Rating: 3 out of 5 stars3/5Office 2019 For Dummies Rating: 4 out of 5 stars4/5SPSS Statistics Workbook For Dummies Rating: 0 out of 5 stars0 ratingsExcel Workbook For Dummies Rating: 4 out of 5 stars4/5Python for Data Science For Dummies Rating: 0 out of 5 stars0 ratingsR For Dummies Rating: 4 out of 5 stars4/5Word 2019 For Dummies Rating: 3 out of 5 stars3/5Office 2019 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsStatistical Analysis with R For Dummies Rating: 0 out of 5 stars0 ratingsStatistics II For Dummies Rating: 3 out of 5 stars3/5Excel 2016 All-in-One For Dummies Rating: 3 out of 5 stars3/5PowerPoint 2019 For Dummies Rating: 0 out of 5 stars0 ratingsBookkeeping For Dummies Rating: 0 out of 5 stars0 ratings
Enterprise Applications For You
The Ultimate Guide To Master Excel Features & Formulas. Become A Pro From Scratch in Just 7 Days With Step-By-Step Instructions Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsSystems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5QuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsExcel 2019 For Dummies Rating: 3 out of 5 stars3/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Learn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratingsSharePoint 2016 For Dummies Rating: 5 out of 5 stars5/5Change Management for Beginners: Understanding Change Processes and Actively Shaping Them Rating: 5 out of 5 stars5/5101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsThe Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratingsThe New Email Revolution: Save Time, Make Money, and Write Emails People Actually Want to Read! Rating: 5 out of 5 stars5/5Mastering QuickBooks 2020: The ultimate guide to bookkeeping and QuickBooks Online Rating: 0 out of 5 stars0 ratingsCreate Income through Self-Publishing: An Author's Approach on Generating Wealth by Self-Publishing Rating: 5 out of 5 stars5/5M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query Rating: 4 out of 5 stars4/5Excel 2019 Bible Rating: 4 out of 5 stars4/5
Reviews for Excel Formulas & Functions For Dummies
0 ratings0 reviews