Excel Outdated Functions Vs New Built-In Functions
These Excel functions are outdated | Use these new functions instead of them in excel | Hindi
Excel old vs new function | These Excel Functions Were Great… 10 Years Ago (Time to Upgrade) | You know those Excel functions you’ve been using for years? They used to be essential, but thanks to new functions, we now have simpler, faster, and better ways to get the job done. Microsoft Excel tips and tricks
#gurujicomputercourse #computergyan #exceltips #msexcel
Our First Channel: @computergyanguruji
Our Second Channel: @computerguruji
File download - Clickhere
Timestamps
00:00 Intro
00:39 Outdated functions: CONCAT & CONCATENATE Instead of TEXTJOIN
03:40 Outdated functions: VLOOKUP & HLOOKUP Instead of XLOOKUP
06:23 Outdated function: MATCH Instead of XMATCH
08:21 Outdated function: SUBTOTAL replace with AGGREGATE
10:21 Outdated functions: LEFT, MID, FIND, LEN Instead of TEXTAFTER & TEXTBEFORE
13:20 Outdated function: INDIRECT Instead of SWITCH Instead of XLOOKUP
Post a Comment