Microsoft Excel 2019 Formulas and Functions

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Microsoft Excel 2019 Formulas and Functions by Paul McFedries, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Paul McFedries ISBN: 9781509306343
Publisher: Pearson Education Publication: February 19, 2019
Imprint: Microsoft Press Language: English
Author: Paul McFedries
ISBN: 9781509306343
Publisher: Pearson Education
Publication: February 19, 2019
Imprint: Microsoft Press
Language: English

Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets. 

 

Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries’ step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel’s most useful functions in your everyday work. Becoming an Excel expert has never been easier! 

 

By reading this book, you will: 

• Improve business analyses by adding intelligence and knowledge to your models 

• Replace cumbersome formulas with convenient predefined functions 

• Radically simplify complex calculations with Office 365’s new dynamic arrays 

• Use conditional formatting to reveal anomalies, problems, or opportunities 

• Calculate loan payments, interest costs, terms, and amortization schedules 

• Project the future value of investments, and plan to achieve investment goals 

• Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return 

• Sort, filter, and analyze tabular data, from customers to inventory 

• Easily analyze huge data sets with PivotTable calculations 

 

About This Book 

• For everyone who wants to get more done with Microsoft Excel in less time 

• For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data 

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets. 

 

Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries’ step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel’s most useful functions in your everyday work. Becoming an Excel expert has never been easier! 

 

By reading this book, you will: 

• Improve business analyses by adding intelligence and knowledge to your models 

• Replace cumbersome formulas with convenient predefined functions 

• Radically simplify complex calculations with Office 365’s new dynamic arrays 

• Use conditional formatting to reveal anomalies, problems, or opportunities 

• Calculate loan payments, interest costs, terms, and amortization schedules 

• Project the future value of investments, and plan to achieve investment goals 

• Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return 

• Sort, filter, and analyze tabular data, from customers to inventory 

• Easily analyze huge data sets with PivotTable calculations 

 

About This Book 

• For everyone who wants to get more done with Microsoft Excel in less time 

• For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data 

More books from Pearson Education

Cover of the book JavaScript for Programmers by Paul McFedries
Cover of the book The Practice of Programming by Paul McFedries
Cover of the book iOS 8 for Programmers by Paul McFedries
Cover of the book The Photographer's Guide to Paris by Paul McFedries
Cover of the book The Addicted Brain: Why We Abuse Drugs, Alcohol, and Nicotine by Paul McFedries
Cover of the book The Mac OS X Leopard Book by Paul McFedries
Cover of the book Solaris Application Programming by Paul McFedries
Cover of the book The Truth About Better Decision-Making (Collection) by Paul McFedries
Cover of the book Financing the Future by Paul McFedries
Cover of the book Speed It Up! A Non-Technical Guide for Speeding Up Slow Computers by Paul McFedries
Cover of the book Trading Commodities and Financial Futures by Paul McFedries
Cover of the book Microsoft SharePoint 2010 Creating and Implementing Real World Projects by Paul McFedries
Cover of the book Adobe Dreamweaver CS5 Classroom in a Book by Paul McFedries
Cover of the book CSS3 by Paul McFedries
Cover of the book The Greening of IT by Paul McFedries
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy