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 The HTML5 Developer's Collection (Collection) by Paul McFedries
Cover of the book Cisco Unified Presence Fundamentals by Paul McFedries
Cover of the book The Truth About Creating Effective Feedback Loops with Your Employees by Paul McFedries
Cover of the book Business Express: Nurturing Business innovation by Paul McFedries
Cover of the book Forex Revolution by Paul McFedries
Cover of the book Africa Is Richer Than You Think by Paul McFedries
Cover of the book The Apache Modules Book by Paul McFedries
Cover of the book My iPhone by Paul McFedries
Cover of the book Test-Driven JavaScript Development by Paul McFedries
Cover of the book Assessment of Options Investments by Ranking Analysis by Paul McFedries
Cover of the book Getting to Grips with China's GDP Data by Paul McFedries
Cover of the book Bird Photography: From Snapshots to Great Shots by Paul McFedries
Cover of the book Adobe Master Class by Paul McFedries
Cover of the book Writing Effective Use Cases by Paul McFedries
Cover of the book Algorithms in Java, Parts 1-4, Portable Documents 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