Jump to ratings and reviews
Rate this book

Excel 2019 Formulas & Functions: How to Master Excel Formulas and Functions in 30 days

Rate this book
Put the power of Excel functions to work in your formulas in 30 days

It is write with step by step guide with screenshots for excel dummies. Well adapted with Microsoft Excel 2019 screenshots and features.


Written for Dummies and Experts

By reading this book, you

• 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

Buy now

Kindle Edition

Published October 21, 2019

3 people are currently reading

About the author

David Knight

158 books4 followers
There is more than one author with this name

David Knight writes video game guides. He has been an avid gamer since the 1980s. He began his career as a game designer in 1995. In 1998, he co-created and co-hosted the webcast "Game Waves." He also became a technical editor for Prima Games. He has published more than a dozen video game guides.

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
0 (0%)
4 stars
0 (0%)
3 stars
0 (0%)
2 stars
0 (0%)
1 star
0 (0%)
No one has reviewed this book yet.

Can't find what you're looking for?

Get help and learn more about the design.