• Excel Formulas and Functions

  • Step-By-Step Guide with Examples
  • By: Adam Ramirez
  • Narrated by: Trevor Clinger
  • Length: 1 hr and 58 mins
  • 4.8 out of 5 stars (32 ratings)

1 title per month from Audible’s entire catalog of best sellers, and new releases.
Access a growing selection of included Audible Originals, audiobooks and podcasts.
You will get an email reminder before your trial ends.
Your Premium Plus plan is $14.95 a month after 30 day trial. Cancel anytime.
Excel Formulas and Functions  By  cover art

Excel Formulas and Functions

By: Adam Ramirez
Narrated by: Trevor Clinger
Try for $0.00

$14.95/month after 30 days. 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
    29
  • 4 Stars
    1
  • 3 Stars
    1
  • 2 Stars
    0
  • 1 Stars
    1
Performance
  • 5 out of 5 stars
  • 5 Stars
    30
  • 4 Stars
    0
  • 3 Stars
    0
  • 2 Stars
    1
  • 1 Stars
    1
Story
  • 5 out of 5 stars
  • 5 Stars
    29
  • 4 Stars
    1
  • 3 Stars
    1
  • 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.

2 people 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
    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.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Monique Haize
  • Monique Haize
  • 06-16-18

Book has good depth of information. Explained so I

Book has good depth of information. Explained so I can follow how to perform Excel functions. Thorough and easy to use. This is the one resource I purchase with each MS Office upgrade. Keep up the good work.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Jack
  • Jack
  • 06-16-18

Full of information

Book has good depth of information. Written so I can follow how to perform Excel functions. This a great book. It is definitely full of a lot of great information

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Britney
  • Britney
  • 06-16-18

Thank you.

Excel Formulas and Function is the most authorative source on EXCEL that I have ever seen. The research on EXCEL was extensive and complete to insure a knowledge base second to none.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Johny
  • Johny
  • 06-16-18

Good for beginners

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

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Dark
  • Dark
  • 06-16-18

A huge help

This book was a big help for my Intro to Civil Engineering class. It is an exhaustive and well constructed resource for anyone needing to learn the ins and outs of Excel.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Shinobi
  • Shinobi
  • 06-16-18

Well done

It is the real Deal. If you have been using Excel for years and this is the book. If you have never used Excel this is the book the explanations are just right. It Is Well Done