Lesson 11 - The AVERAGE and AVERAGEA Functions
Excel for Teachers
Carlo Excels
Objectives of this Episode:
1. AVERAGE Function Definition
2. Applications of the AVERAGE Function
3. AVERAGE Function VS Basic Calculations
4. AVERAGEA Function Definition
5. Applications of the AVERAGEA Function
6. AVERAGEA Function VS AVERAGEFunction
--- --- --- ---
Lesson Chapters:
00:00 Introduction
00:32 AVERAGE Function Description
01:14 Review of Averaging Calculations
02:22 Using the AVERAGE Function
04:14 Adding and Averaging Test Scores
05:03 AVERAGE Function VS Other Averaging Calculations
11:54 AVERAGEA Function Description
12:20 Using the AVERAGEA Function
13:02 AVERAGEA Function VS Other Averaging Calculations
16:56 When to Use the AVERAGE and AVERAGEA Functions
18:06 Closing
--- --- --- ---
Prerequisite Videos:
Basic Calculations
[ Ссылка ]
Basics of Functions
[ Ссылка ]
The SUM Function
[ Ссылка ]
--- --- --- ---
#carlo #microsoft #excel #microsoftexcel #excels #carloexcels #teacher #pinoy #filipino #guro #pinoyguro #filipinoguro #pinoyteacher #filipinoteacher #teacherphilippines #philippines #teacherpilipinas #pilipinas #tagalog #tagalogtutorial #pinoytutorial #filipinotutorial #departmentofeducation #deped #basic #beginner #beginners #introduction
* All data featured in the video are fictional. All names have been created through a name randomizer, and are fictional people. All records and grades have been created randomly and are all also fictional. Any possible similarity, relation or representation they might have on real existing people should not be inferred, and are not intentional and are purely coincidental.
* This channel discusses the use of Microsoft Excel. Microsoft, Microsoft Excel, and all products and company names are trademarks or registered trademarks of their respective holders. This channel's use of them does not imply any affiliation with or endorsement by them.
* The source image of the Carlo Excels logo and all thumbnail images used are edited from images with Creative Commons licenses. All music used are from the Youtube Audio Library.
Ещё видео!