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 OS X Mountain Lion Absolute Beginner's Guide by Paul McFedries
Cover of the book How Option Contracts Work by Paul McFedries
Cover of the book My Office Sway (includes Content Update Program) by Paul McFedries
Cover of the book Business Express: Developing your influencing skills by Paul McFedries
Cover of the book The Flash Animator by Paul McFedries
Cover of the book Secrets of Podcasting, Second Edition by Paul McFedries
Cover of the book Enterprise Software Security by Paul McFedries
Cover of the book Outsmart! by Paul McFedries
Cover of the book Taguchi Methods and Optimization for Robust Software (Digital Short Cut) by Paul McFedries
Cover of the book Java Coding Guidelines by Paul McFedries
Cover of the book Make Change Happen by Paul McFedries
Cover of the book Go in 24 Hours, Sams Teach Yourself by Paul McFedries
Cover of the book Exam Ref 70-663 Designing and Deploying Messaging Solutions with Microsoft Exchange Server 2010 (MCITP) by Paul McFedries
Cover of the book The Software Project Manager's Bridge to Agility by Paul McFedries
Cover of the book Plug In with onOne Software 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