What do you think?
Rate this book
Microsoft Excel 2019 Formulas and Functions
Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel's newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.
Becoming an Excel expert has never been easier! You'll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.
- Quickly create powerful spreadsheets with range names and array formulas
- Use conditional formatting to instantly reveal anomalies, problems, or opportunities
- Analyze your data with standard tables and PivotTables
- Use complex criteria to filter data in lists
- Understand correlations between data
- Perform sophisticated what-if analyses
- Use regression to track trends and make forecasts
- Build loan, investment, and discount formulas
- Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets
Becoming an Excel expert has never been easier! You'll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.
- Quickly create powerful spreadsheets with range names and array formulas
- Use conditional formatting to instantly reveal anomalies, problems, or opportunities
- Analyze your data with standard tables and PivotTables
- Use complex criteria to filter data in lists
- Understand correlations between data
- Perform sophisticated what-if analyses
- Use regression to track trends and make forecasts
- Build loan, investment, and discount formulas
- Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets
512 pages, Paperback
Published April 25, 2019
25 people are currently reading
21 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
March 21, 2023
Become Excel Expert
This book is a game-changer for anyone looking to master Excel 2019. This book is packed with invaluable information on a variety of formulas and functions that can help streamline your work and increase your productivity.
What I appreciated most about this book was how clearly McFedries explained even the most complex formulas and functions. His writing style is engaging and easy to follow, and he provides numerous practical examples that make it simple to apply what you've learned.
Whether you're a beginner or an experienced Excel user, this book is an excellent resource. I've read other Excel 2019 books, but none come close to the level of detail and clarity that McFedries provides.
Overall, I highly recommend this. If you want to take your Excel skills to the next level, this book is a must-read.
4.4/5
This book is a game-changer for anyone looking to master Excel 2019. This book is packed with invaluable information on a variety of formulas and functions that can help streamline your work and increase your productivity.
What I appreciated most about this book was how clearly McFedries explained even the most complex formulas and functions. His writing style is engaging and easy to follow, and he provides numerous practical examples that make it simple to apply what you've learned.
Whether you're a beginner or an experienced Excel user, this book is an excellent resource. I've read other Excel 2019 books, but none come close to the level of detail and clarity that McFedries provides.
Overall, I highly recommend this. If you want to take your Excel skills to the next level, this book is a must-read.
4.4/5
Displaying 1 of 1 review