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

File download - Clickhere

कोई टिप्पणी नहीं

टिप्पणी: केवल इस ब्लॉग का सदस्य टिप्पणी भेज सकता है.

Make Your own Custom Navigation Bar in excel

Make Your own Custom Navigation Bar in excel | Make a Custom Sidebar in Excel Step by Step Create Custom Navigation bar Download Excel File ...

Blogger द्वारा संचालित.