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)**

Do you also teach other IT lessons?

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.

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.

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

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.

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

The video keeps pausing on me as well and it won’t start back up again.

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

I can’t find this chart in the workbook

Very useful, thank you so much buddy..

Thank you KMD

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

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

i would like to know about the formula formatting

min

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

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”.

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

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?

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

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.

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

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

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

Datazone from autozone uses your tutorials!! nice!

Really? That’s great!

I’m assuming that’s some sort of internal training system?

Thanks for letting me know 🙂

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

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

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

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

Sorry, you soon corrected it in your video, didn’t mean to nit pick :/.

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

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