Average Function in Excel

Veröffentlicht am: 05 Juni 2020
auf dem Kanal: Chris Menard
5,455
53

The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.

The syntax for the Average Function
**********************************
AVERAGE(number1, [number2], ...)
The AVERAGE function syntax has the following arguments:
Number1 - Required. The first number, cell reference, or range for which you want the average.
Number2, ... - Optional. Additional numbers, cell references, or ranges for which you want the average, up to a maximum of 255.

Average and Averageif with wildcards:
   • Excel's Average and AverageIf function wit...  

Blog post on the Average Function
https://chrismenardtraining.com/post/...

Microsoft's support page for Average
https://support.office.com/en-us/arti...

#microsoftexcel #msexcel #chrismenard

Chris Menard's website:
https://chrismenardtraining.com

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!


Auf dieser Seite können Sie das Online-Video Average Function in Excel mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Chris Menard 05 Juni 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 5,455 Mal angesehen und es wurde von 53 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!