Video Lesson: Math and Statistical Functions

This Excel video lesson is about the Experience Level 1 Math and Statistical Functions in Excel.  Here is the level 1 function list extract from the Master Workbook that goes along with the video lesson.

The formulas discussed in the video are as follows:

MIN – MAX – AVERAGE – MEDIAN – SUM – PRODUCT – SUMPRODUCT

COUNT – COUNTA – COUNTBLANK – ABS – COUNTIF – COUNTIFS

SUMIF – SUMIFS – AVERAGEIF – RAND – RANDBETWEEN

ROUND – ROUNDDOWN – ROUNDUP – SUBTOTAL

As always, make sure to download the latest Master Workbook to follow along.

EDIT: The Gross Profit formula should not be including the ‘Retail Price’ in it’s SUM function.  I’ve left this mistake in there so that the numbers remain the same in the video & file, but I just wanted to point out that the calculation is incorrect.

Next up if you’re following the Lesson Guide is learning about Date & Time Functions (e.g. TODAY, MONTH)

This entry was posted in Function-Related Lessons and tagged , , , , , , , , , , , . Bookmark the permalink.

34 Responses to Video Lesson: Math and Statistical Functions

  1. Topacho Francis says:

    Do you also teach other IT lessons?

    • Dale Gross says:

      This is for the guy who does the lessons: Your organizational skills are sorely lacking. You might know excel, but you don’t know how to organize your materials.

  2. Ranjan says:

    Hi Ben,

    Many thanks for uploading these lessons. They certainly are very useful to me at work and the masterwork book too. Very handy.

    Thanks a ton.

  3. Anonymous says:

    I’m a beginner and want to learn these formulas but some hoe I found its going faster than your other videos. Can you suggest some video before watching this one.
    Thank you for sparing that much time. It’s helping a lot

  4. Ange Lina says:

    I really like the lessons. As I am a practical learner are there any exercises that I can do in order to work on the lessons that you provide.

  5. Anonymous says:

    I am not able to play the video. It is blank and there is no play button.

  6. Daniel Spencer says:

    Dear Ben, I’m a kinaesthetic learner, do you have any exercises that are more ‘walkthrough’ orientated? You tell us about a lot of the functions, but you don’t tell us how to make that dropdown chart etc. Basically, I would learn more if I could follow instructions to build exactly the same chart from scratch as you did along with inserting the functions myself, step by step. Thank you for you videos they are a help. Daniel

  7. Anonymous says:

    I can’t find this chart in the workbook

  8. sasankababu says:

    Very useful, thank you so much buddy..

  9. Anonymous says:

    Thank you KMD

  10. Anonymous says:

    Excellent Tutorial. Am learning a lot and I have only started.

  11. Anonymous says:

    The median function will always return the middle value of a SORTED set of numbers, regardless of the actual order in the array.

  12. RB says:

    Doesnt seem to be an excel sheet to follow along with this lesson..or am i just lost?

    • David says:

      Hey RB, I was having trouble finding it too. Go to the 4th spreadsheet (Function Examples) and click the “+” sign the the left of “Math and Statistical Functions”.

  13. Local says:

    The revenue does not equal the average retail price times the units solds. You put a wrong number for the average retail price.

    • David says:

      The revenue value is correct and the average retail price is indeed incorrect as you pointed out, thus making your first sentence irrelevant. What is your point? do you understand the point of the video?

  14. Anonymous says:

    You put in the wrong average retail price! It should be 59.8333

  15. Fine way of describing, and pleasant piece of writing
    to get information regarding my presentation subject matter, which i am going to
    present in university.

  16. sol says:

    This video is not working for me. It shows up as a blank and there is no play button to click

  17. On Sep 21, 2013 7:06 AM, “Free Excel Training!” wrote:

    > New comment on your post “Video Lesson: Math and Statistical Functions” > Author : kindergarten chicco smart support backpack red (IP: 192.3.176.238 > , .) > E-mail : marianneratliff@zoho.com > URL : http://www.nopchina.net/post/2012/05/29/themes-red-blue.html > Whois : http://whois.arin.net/rest/ip/192.3.176.238

  18. Stephanie Dean says:

    Hi, Like Liam and Ben I too am having problems with this video “freezing” intermittently (all others so far fine) am using Windows 7.

  19. aasdfffa says:

    Datazone from autozone uses your tutorials!! nice!

  20. Anonymous says:

    Hi there, do you have any practice sheets where I could test out all your brilliant teaching?

  21. @ckcondos says:

    This video isn’t loading in this screen or on Vimeo. The other videos are? Any ideas why

    • Hey Cam,

      The video loads fine for me. What kind of computer (PC/Mac) and what browser are you using?

      Might be a temporary hiccup which will correct itself, or may be related to something else.

      Cheers,

      Ben

      • Liam says:

        Hi Ben,

        I’m having similar problems with this video. All the others work fine, just not this one. Any ideas? I’m using Windows 8 by the way.

        Cheers,

        Liam

  22. Colby says:

    Howdy Ben,

    When I opened the spreadsheet to the section you’re on, I noticed that in the average category – Cell number C 118 – it read 15.50 and in the median category – Cell number C119 it read 15 instead of what you have with to start with in the video.

    Sincerely

    Colby

  23. Shehla says:

    Thank you so much you have come as an answer to my prayers

  24. Natalie says:

    Excellent tutorial. Looking forward to viewing others … nicely done.

Comments are closed.