Lesson 43 - The VLOOKUP and HLOOKUP Functions (Advanced)
Excel for Teachers
Carlo Excels
Objectives of this Episode:
1. Advanced applications of the VLOOKUP and HLOOKUP Functions
--- --- --- ---
Lesson Chapters:
00:00 Introduction
01:13 Using a Variable Index Number for VLOOKUP
05:40 Using VLOOKUP Functions with Two Conditions
10:17 Using VLOOKUP Functions with Three Conditions
19:25 Closing
--- --- --- ---
Prerequisite Videos:
Types of Values
[ Ссылка ]
Relative and Absolute References
[ Ссылка ]
The COUNTIF Function
[ Ссылка ]
Basic Data Validation
[ Ссылка ]
The VLOOKUP and HLOOKUP Functions (Basic)
[ Ссылка ]
The VLOOKUP and HLOOKUP Functions (Intermediate)
[ Ссылка ]
--- --- --- ---
#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.
