Lesson 23 - The Trim, Upper, Lower and Proper Functions
Excel for Teachers
Carlo Excels
Objectives of this Episode:
1. TRIM Function Definition
2. UPPER Function Definition
3. LOWER Function Definition
4. PROPER Function Definition
5. Applications of the TRIM, UPPER,LOWER and PROPER Functions
--- --- --- ---
Lesson Chapters:
00:00 Introduction
00:24 TRIM Function Definition
02:09 Using the TRIM Function
03:30 UPPER, LOWER and PROPER Function Definitions
04:22 Using the UPPER, LOWER and PROPER Functions
09:08 Cleaning Student Data with the TRIM Function
18:06 Closing
--- --- --- ---
Prerequisite Videos:
Cutting, Copying and Pasting
[ Ссылка ]
The Replace Command
[ Ссылка ]
--- --- --- ---
#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.
Ещё видео!