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