Excel Formulas and Functions

Step-By-Step Guide with Examples

By: Adam Ramirez

Narrated by: Trevor Clinger

Length: 1 hr and 58 mins

Publisher's summary

For many of us, Excel is nothing more than a basic spreadsheet, something we may use on the odd occasion, but for some, it is part of our daily lives.

Microsoft Excel is more than just a spreadsheet; it is an essential tool for businesses. In fact, it would be fair to say that it is probably one of the most important tools that a business could have at its disposal.

Some of the best uses for Excel include extracting data into charts, using it to identify problems and trends, bringing all the data together from multiple files and other sources so it’s all in one easy-to-use place, and much more.

The basis of Excel lies in formulas and functions, used for storing data and retrieving it, for doing calculations, and for analyzing data, and is all in one simple grid format. It is these formulas and functions that provide the biggest headaches for inexperienced users and that is what my guide is all about. It will teach you how to use them and also look at some of the most commonly used ones.

Given that there are more than 400 functions alone and not much less in the way of formulas, I couldn’t possibly go over every single one of them. You don’t need to know them all; Excel has a built-in Function Wizard that helps you to get the best function for what you are doing, and built-in Formula Intellisense helps with formulas.

Without further ado, let’s immerse ourselves in the world of Excel formulas and functions.

©2018 Adam Ramirez (P)2018 Adam Ramirez

Excellent

Everything is there for the asking. I'm self taught with Microsoft so some things were over my head but overall love the book.

Good Book !

Good Book ! I recommend this book to persons who are working or to persons who are going to college

Very Helpful

Very Helpful. The coding details, particularly at the end, ran a little faster than I could absorb, but I think I can go back over the examples and get up to speed. Enjoyed it very much

Excellent

Nice explaination, nice narration !! VBA is a very vast topic and Sir , you are covering maxium topics, Thanks a lot.

Fantastic

This 10 bndl audiobook providing the student with the basic knowledge, tools and building blocks, and then, most importantly, a methodology or approach for continuing to develop your skills at your own pace as you become more ambitious in your coding. I have no hesitation in fully recommending this course.

Every Excel user should have one for a reference g

Every Excel user should have one for a reference guide. It will give you so much information without confusing you. Very well written and narrated.

Fantastic

This is a helpful book and interesting.I was really amaze cause this book is an ultimate beginners guide.The author is clear and explains the concepts very well.I highly recommend this book to all of you guys

Comprehensive and concise teaching style.

Comprehensive and concise teaching style. Loads of sample code is provided. Exactly what I was looking for and needed. Highly recommend!

Awesome book.

Awesome book. One of my favs for helping me understand the concept better. Excellent author, too!

Excellent

I first encountered Adam by doing audiobook courses here on Audible. I wish I had come across him many years earlier. I'm learning so much about VBA than I could have ever though