What do you think?
Rate this book
Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas
Are you working on a project where you need to perform complex mathematical and financial operations? Did you know you could use Excel to perform such calculations using the predefined functions and formulae? Are you looking for a way to learn these functions better? If you answered yes to any of the questions, you have chosen the right book. Microsoft Excel is an application that helps you save time and analyze data easily. It has multiple predefined functions you can use to perform complex calculations and analysis and make your job easy. A lot of people struggle to understand these functions for multiple reasons, and therefore, cannot use the application well. Regardless of the industry you work in, you must understand the use of these functions so you can improve your analysis and understanding of the data. Use this book as your guide to understand different functions and formulae in Excel. In this book, you will learn ● What Microsoft Excel is, and its benefits ● The Formula Tab in Excel ● Types of Referencing ● Different functions in Excel ● Some tips and shortcuts To make it easy for you to learn these formulae, there are several screenshots to guide you and make the functions easy for you. If you want to learn more about how to use Excel, click on the buy now button now and grab a copy of this book today!
106 pages, Kindle Edition
Published May 14, 2020
712 people are currently reading
204 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 14 of 14 reviews
October 8, 2025
⭐️⭐️⭐️💫 3.5 Stars || A Helpful but Occasionally Repetitive Guide to Excel Mastery
It is a practical and accessible resource for anyone looking to strengthen their Excel skills. The book does a commendable job of breaking down complex formulas and functions into easy, step-by-step explanations—perfect for beginners or intermediate users wanting to polish their knowledge.
The examples provided are clear and relevant, helping readers understand not just how a formula works, but why it’s useful in real-world scenarios. From VLOOKUP and IF statements to more advanced tools like pivot tables, the author ensures that readers gain a solid grounding in Excel’s powerful capabilities.
However, the book does show a few weak spots. Some sections feel overly repetitive, covering basic functions more than necessary. Additionally, the layout and formatting could have been a bit more engaging—visual learners might miss flowcharts or step illustrations that would make the concepts easier to grasp.
Despite these minor shortcomings, the guide serves as a useful companion for office professionals, students or data enthusiasts who want to get comfortable with Excel formulas without feeling overwhelmed.
A solid, straightforward manual—not dazzling, but dependable. It lights the way for beginners/learners who prefer clarity and structure over flashy presentation.
3.5 stars for effort, initial clarity and practical value.
It is a practical and accessible resource for anyone looking to strengthen their Excel skills. The book does a commendable job of breaking down complex formulas and functions into easy, step-by-step explanations—perfect for beginners or intermediate users wanting to polish their knowledge.
The examples provided are clear and relevant, helping readers understand not just how a formula works, but why it’s useful in real-world scenarios. From VLOOKUP and IF statements to more advanced tools like pivot tables, the author ensures that readers gain a solid grounding in Excel’s powerful capabilities.
However, the book does show a few weak spots. Some sections feel overly repetitive, covering basic functions more than necessary. Additionally, the layout and formatting could have been a bit more engaging—visual learners might miss flowcharts or step illustrations that would make the concepts easier to grasp.
Despite these minor shortcomings, the guide serves as a useful companion for office professionals, students or data enthusiasts who want to get comfortable with Excel formulas without feeling overwhelmed.
A solid, straightforward manual—not dazzling, but dependable. It lights the way for beginners/learners who prefer clarity and structure over flashy presentation.
3.5 stars for effort, initial clarity and practical value.
April 20, 2022
Good info on Excel formulas and shortcuts
This has some good info on Excel formulas and shortcuts. I knew a lot of these already before reading this book, but I like how it is setup to group the usage and various types of functions like financial, text, and others. I also learned a few new keyboard shortcuts that I didn't know like CTRL + $ to quickly format a number as currency. Makes sense when you see it, but never new that till reading this book.
This has some good info on Excel formulas and shortcuts. I knew a lot of these already before reading this book, but I like how it is setup to group the usage and various types of functions like financial, text, and others. I also learned a few new keyboard shortcuts that I didn't know like CTRL + $ to quickly format a number as currency. Makes sense when you see it, but never new that till reading this book.
July 18, 2022
Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1)
by Adam Ramirez
The book which I will suggest to you folks today is an exceptionally captivating and extremely fascinating book the substance of this book will make you fall head over heels for this book.
Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1) by Adam Ramirez is a very useful book to learn Microsoft excel. This has some great data on Excel equations and easy routes. I realized a great deal of these as of now before perusing this book, yet I like how it is an arrangement to bunch the utilization and different kinds of capabilities like monetary, text, and others. I likewise scholarly a couple of new consoles easy routes that I didn't know like CTRL + $ to organize a number as money rapidly. Checks out when you see it, however, never knew that till perusing this book.
This book works effectively by covering a portion of the more essential things in Excel. You won't figure out how to do a Nested If equation or an Index(Match) yet you presumably wouldn't peruse this book assuming that you knew that stuff at any rate. It gives incredible clarifications of a ton of equations and what the math on some of them is doing. It likewise gives great tips and deceives. If you're simply beginning, you can't turn out badly by beginning here.
Overall, THIS IS A MUST-READ. Written cautiously, this book is something that will be a joy to peruse and I prescribe you to peruse it. This book is certainly worth the buy and worth the read.
Book Review By bookloverbiswa
by Adam Ramirez
The book which I will suggest to you folks today is an exceptionally captivating and extremely fascinating book the substance of this book will make you fall head over heels for this book.
Excel Formulas and Functions 2020: The Step by Step Excel Guide with Examples on How to Create Powerful Formulas (Excel Academy Book 1) by Adam Ramirez is a very useful book to learn Microsoft excel. This has some great data on Excel equations and easy routes. I realized a great deal of these as of now before perusing this book, yet I like how it is an arrangement to bunch the utilization and different kinds of capabilities like monetary, text, and others. I likewise scholarly a couple of new consoles easy routes that I didn't know like CTRL + $ to organize a number as money rapidly. Checks out when you see it, however, never knew that till perusing this book.
This book works effectively by covering a portion of the more essential things in Excel. You won't figure out how to do a Nested If equation or an Index(Match) yet you presumably wouldn't peruse this book assuming that you knew that stuff at any rate. It gives incredible clarifications of a ton of equations and what the math on some of them is doing. It likewise gives great tips and deceives. If you're simply beginning, you can't turn out badly by beginning here.
Overall, THIS IS A MUST-READ. Written cautiously, this book is something that will be a joy to peruse and I prescribe you to peruse it. This book is certainly worth the buy and worth the read.
Book Review By bookloverbiswa
July 20, 2020
A very short book on certain functions of Excel. I got it because of its price (free). But even in its brevity it contains useful information of how to use the program. And at the end of the book there are links to other Excel sources that add to its content. Even in its brevity, I found the solution of how to prepare a certain formula I'd been struggling to solve. For that I give it a 4 start rating
November 11, 2020
No depth
Not sure what I was expecting from a free book. This is a brief run through of some of the formulas in Excel.
The book suffers from not having many examples and better explanations of the functions are found simply by searching the Internet.
I downloaded the free book and there is an error in the first explanation of the Sum function.
So this is an average crib sheet and I was left disappointed.
Not sure what I was expecting from a free book. This is a brief run through of some of the formulas in Excel.
The book suffers from not having many examples and better explanations of the functions are found simply by searching the Internet.
I downloaded the free book and there is an error in the first explanation of the Sum function.
So this is an average crib sheet and I was left disappointed.
October 20, 2021
Pretty good beginner book
This book does a good job of covering some of the more basic items in Excel. You're not going to learn how to do a Nested If formula or an Index(Match) but you probably wouldn't be reading this book if you knew that stuff anyway. It gives great explanations of a lot of formulas and what the math on some of them is actually doing. It also gives really good tips and tricks. If you're just starting out, you can't go wrong by starting here.
This book does a good job of covering some of the more basic items in Excel. You're not going to learn how to do a Nested If formula or an Index(Match) but you probably wouldn't be reading this book if you knew that stuff anyway. It gives great explanations of a lot of formulas and what the math on some of them is actually doing. It also gives really good tips and tricks. If you're just starting out, you can't go wrong by starting here.
September 14, 2024
Learn how the Microsoft office is excel
I learn that is there computer is Microsoft excel for make sure that is budget for money financial wise is investment wise because it balances everything out with banking so accounting for checking accounts and savings accounts is congratulations on your financial independence is the most valuable investment you have control financial planning is business plan is the company work.
I learn that is there computer is Microsoft excel for make sure that is budget for money financial wise is investment wise because it balances everything out with banking so accounting for checking accounts and savings accounts is congratulations on your financial independence is the most valuable investment you have control financial planning is business plan is the company work.
June 18, 2020
First off, this is a very beginner book. To make the book more than a guide and more a useful tool, the sections that describe the various functions just add some examples. For example MOD and the other numeric built-in functions. A brief description is fine, but showing what the function does would bring more depth to this manual.
September 30, 2020
Work on different sheets
I’ve been struggling with the formula I needed to connect the sheets in a workbook. This book made it easy to find the formula I needed. Book explains everything with ease. It is more for a beginner. Great shortcuts given.
I’ve been struggling with the formula I needed to connect the sheets in a workbook. This book made it easy to find the formula I needed. Book explains everything with ease. It is more for a beginner. Great shortcuts given.
August 11, 2021
Very basic excel guide
November 5, 2022
Good examples
This book shows examples of what you should know to do good reporting.
It shows helpful formulas on how to use them and an explanation of the purpose of them.
This book shows examples of what you should know to do good reporting.
It shows helpful formulas on how to use them and an explanation of the purpose of them.
July 13, 2023
Good one
This is such a Good book we can recommend it to all nice one.... Just recommended to all people. Thanks
This is such a Good book we can recommend it to all nice one.... Just recommended to all people. Thanks
October 25, 2023
EXCELLENT BOOK
December 30, 2023
Ok ok
It could have more practicality. The book introduced me to the world of Excel again... But didn't have solutions to many possible explanation.
It could have more practicality. The book introduced me to the world of Excel again... But didn't have solutions to many possible explanation.
Displaying 1 - 14 of 14 reviews