Microsoft Excel 2016 Formulas and Functions (MrExcel Library)
$30.73
Price: $30.73
(as of May 21,2023 10:22:25 UTC – Details)
Book + Content Update Program
In this book, Microsoft Excel expert Paul McFedries shares his knowledge on how to use Excel 2016’s core features to solve problems and get the answers you need. With real-world examples, McFedries helps you get the most out of features and improvements such as AutoFill and Excel’s newest functions. Along the way, you’ll discover the fastest and best ways to handle essential day-to-day tasks such as generating account numbers and projecting the impact of inflation.
Becoming an Excel expert has never been easier with the crystal-clear instructions and insider insights provided in this book, as well as complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.
Some of the key topics covered in this book include:
- Quickly creating powerful spreadsheets with range names and array formulas
- Using conditional formatting to instantly reveal anomalies, problems, or opportunities
- Analyzing your data with standard tables and PivotTables
- Using complex criteria to filter data in lists
- Understanding correlations between data
- Performing sophisticated what-if analyses
- Using regression to track trends and make forecasts
- Building loan, investment, and discount formulas
- Validating data, troubleshooting problems, and building more accurate, trustworthy spreadsheets
In addition to all of this, the book is part of Que’s exciting Content Update Program, meaning that sections of the book will be updated as Microsoft updates features of Excel 2016. The updates will be delivered to you via a FREE Web Edition of this book, accessible with any Internet connection. For more information, visit .
About MrExcel Library
Each book in the MrExcel Library focuses on a specific set of crucial Excel tasks and presents the necessary skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books help you
- Dramatically increase your productivity, saving you 50 hours a year or more
- Present proven, creative strategies for solving real-world problems
- Show you how to get great results, no matter how much data you have
- Help you avoid critical mistakes that even experienced users make
User Reviews
Be the first to review “Microsoft Excel 2016 Formulas and Functions (MrExcel Library)”
Related Products
There are no reviews yet.