Excel Level 2 Part 8 - Text Function 2( Changing Case)

Channel started to give awareness about technology.
You can contact us
Facebook : https://www.facebook.com/arunreddytech4u/
Instagram : https://www.instagram.com/arun_reddy_tech4u/?r=nametag
Youtube Channel link: https://www.youtube.com/channel/UCsdkb_7w_AiOzLRDAuXlhNw
The Following are link of video of
EXCEL LEVEL 2(ADVANCED EXCEL)
Part 1 - SUBTOTAL
https://youtu.be/TP7sMouKEFc
Part 2 - CUSTOM VIEW
https://youtu.be/9bilb9nTAPE
Part 3 – CELL REFERENCE
https://youtu.be/z8LgnACTH24
Part 4 – PIVOT TABLE
https://youtu.be/oijpbzE3BCI
Part 5 – FLASH FILL
https://youtu.be/jkHx77QaFvo
Part 6 – 3D FORMULAS
https://youtu.be/MBd72O7oXuU
Part 7 – CONCATINATE FUNCTION
https://youtu.be/eszmwYgXYBM
Part 8 – CHANGING CASE
https://youtu.be/UgQwJh8ZU2A
Part 9 – EXTRACTING TEXT
https://youtu.be/CZyze15LoW8
Part 10 – TEXT FUNCTION
https://youtu.be/_KukA6EirCM
Part 11 – DATE FUNCTIONS
https://youtu.be/80FnbqGt3Og
Part 12 – CALCULATING AGE & EXPERIENCE
https://youtu.be/jcBhTTEJnRA
Part 13 – LOGICAL FUNCTION
https://youtu.be/qmSFmkB8IyI
Part 14 – STATICTICAL FUNCTIONS
https://youtu.be/Qfh8_xpVEu8
Part 15 – TYPES OF SUM, AVERAGE & COUNT
https://youtu.be/-7d-LKJtflI
Part 16 – MEAN, MEDIAN, MODE & STANDARD DEVIATION
https://youtu.be/6_WRCrFso5o
Part 17 – MATH FUNCTIONS
https://youtu.be/mLkk26yIAVY
Part 18 – FINACIAL FUNCTIONS
https://youtu.be/d6qQ4U8qXmU
Part 19 – CONSOLIDATE DATA
https://youtu.be/kE77k_kVcxI
Part 20 – CONVERT FUNCTION
https://youtu.be/D-DGvgZTn2U
Part 21 - SLICER
https://youtu.be/f_eOz5pJUWE
Part 22 – NAME RANGE
https://youtu.be/mSvUOWnXuIA
Part 23 – TYPES OF COUNT FUNCTIONS
https://youtu.be/1GePX_k9CDQ
Part 24 – GOAL SEEK
https://youtu.be/li_2qVR--f8
Part 25 - SPARKLINES
https://youtu.be/BhXDuJXW8cc
Part 26 – ADVANCED CHARTING
https://youtu.be/C4fa2NPHw9U
Part 27 – ERROR HANDLING
https://youtu.be/3ByPRWr_ncI
Part 28 – ADVANCED DATA VALIDATION
https://youtu.be/cUyE42XOzIA
Part 29 – ADVANCED CONDITIONAL FORMATING
https://youtu.be/ZizOTv3-6nM
Part 30 - ADVANCED FILTERING
https://youtu.be/CsruGU0LCNg

Part 31- NPV & IRR
https://youtu.be/NeOpzI5P_mQ
Part 32 –DEPRECIATION
https://youtu.be/cpftKYV6BL8
PART 33 – INTRODUCTION TO VLOOKUP
https://youtu.be/dkCF1C6eKi0
PART 34 – VLOOKUP Vs HLOOKUP Vs LOOKUP
https://youtu.be/nPYq6h3-MZw
PART 35 – WORKING WITH VLOOKUP
https://youtu.be/iZ4ecAhqitY
PART 36 – INDEX + MATCH
https://youtu.be/UCauicZTfh8
PART 37 - VLOOKUP Vs INDEX +MATCH
https://youtu.be/S13eIvKceaA
PART 38 – REVERSE VLOOKUP
https://youtu.be/WhFEBdm04Sc
PART 39 – DYNAMIC VLOOKUP
https://youtu.be/Uja8gw3bSSg
PART 40 - INDEX+ROWS+COLUMNS
https://youtu.be/zX64qLxsObs
PART 41- NESTED VLOOKUP
https://youtu.be/uW3cawe9yMo
PART 42 – ERROR HANDLING IN VLOOKUP
https://youtu.be/fdXROOM9hhg
PART 43 - XLOOKUP
https://youtu.be/dfoHnXbYIyc
PART 44 – XMATCH
https://youtu.be/nfx2O_CBH9M
PART 45 – IFS FUNCTION
https://youtu.be/Xe8ISaUl3oo

PART 46 – SEARCHABLE DROPDOWN LIST
https://youtu.be/mgSotnoJBfg
PART 47 – SUMPRODUCT
https://youtu.be/LFDbJXPeLvs
PART 48 – DATA TABLE
https://youtu.be/21z9MUHOGgA
PART 49 – SCENARIO MANAGER
https://youtu.be/gM6x7TvNB3s
PART 50 – ARRAY FORMULA
https://youtu.be/jSXQcuNKK2k
PART 51 – INDIRECT FUNCTION
https://youtu.be/hfxO3Xk7vPo
PART 52 - OFFSET FUNCTION
https://youtu.be/Ynl7FHnntBk