adbl_ms_membershipImage_includedwith_altText_B076FLV3HT
adbl_ms_membershipImage_includedwith_altText_B076FLV3HT

1 audiobook of your choice.
Stream or download thousands of included titles.
$14.95 a month after 30 day trial. Cancel anytime.
Buy for $6.95

Buy for $6.95

Pay using card ending in
By confirming your purchase, you agree to Audible's Conditions of Use and Amazon's Privacy Notice. Taxes where applicable.

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

What listeners say about Excel Formulas and Functions

Average Customer Ratings
Overall
  • 5 out of 5 stars
  • 5 Stars
    48
  • 4 Stars
    1
  • 3 Stars
    1
  • 2 Stars
    0
  • 1 Stars
    1
Performance
  • 5 out of 5 stars
  • 5 Stars
    48
  • 4 Stars
    1
  • 3 Stars
    0
  • 2 Stars
    1
  • 1 Stars
    1
Story
  • 5 out of 5 stars
  • 5 Stars
    48
  • 4 Stars
    2
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    1

Reviews - Please select the tabs below to change the source of reviews.

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

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.

1 person found this helpful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

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!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

This is a great audiobook and the teaching style



This is a great audiobook and the teaching style is very effective. Would recommend to anyone that wants to learn Excel Programming as well as Data Analytics

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Excellent

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

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Excellent

Good course overall. I learned a lot about VBA. Sometimes I felt as if Alan spent a lot of time going over a piece of code multiple times. It would be nice to have a little more information on on some of the library terms and why you would or wouldn't use them. For instance, sometimes you use Select and sometimes you don't, but I don't really know why. But overall, very useful

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Fantastic

A great course, and really interesting. If you are serious about learning how to make excel work for you, you should take this course. Highly recommended

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Great explanations.

Great explanations. After delving further into this study program is when I listened all of the information and smoothly narrated.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

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

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

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

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

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

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Kardel
  • Kardel
  • 06-17-18

Just what I needed

This is absolutely a great book! No matter what your level is, this book has you covered.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Olivia
  • Olivia
  • 06-17-18

Insightful!

You can take this book and create useful speadsheets with the tips in this book! Definetly worth the money. I've used this book to create an diy erp for a small business!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Chris
  • Chris
  • 06-17-18

The best for me

By far this is one of the best books ever written, simple expalanations straight to the point covering in detail excel tools and functions, tons of exercises with support materials. This book is the way to go to really learn excel.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Loraine
  • Loraine
  • 06-17-18

I think I'll be using this book for a long time

I learned a lot of advanced excel techniques in a relatively short amount of time. I find that using this as a guide while practicing on excel is the best way to get the most value out of this book.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Irene Dadler
  • Irene Dadler
  • 06-17-18

I love this book!

Much of what is in it I had knowledge of but there were some subjects that just blew my mind.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Felimone Dee
  • Felimone Dee
  • 06-17-18

Very informative.

This book is very useful and much appreciated. Excellent value. Big thank you to the author.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for John Hudson
  • John Hudson
  • 06-17-18

Outstanding!

I rarely give reviews but I took the time to write this one. This is an outstanding book, 5 Stars all the way!!!!!! The book is very well written and easy to understand.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Beverlyn Teen
  • Beverlyn Teen
  • 06-17-18

Fantastic

Fantastic reference and really helped me expand past what I could self-teach. This seems to be exactly the book I’ve needed to improve on my excel skills.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Gregory Cruz
  • Gregory Cruz
  • 06-16-18

This has EVERYTHING you might need or want in it.

This has EVERYTHING you might need or want in it. I had an issue with a spreadsheet at work the other day, jumped to that section, and within seconds had it fixed. If you use Excel, or you want to use it more often or more effectively and efficiently, this is worth every penny.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars
Profile Image for Honey Rimon
  • Honey Rimon
  • 06-16-18

A great audio book. It has all the information I

A great audio book. It has all the information I needed and more. Easy to listen and understand.