5 New Function in 2021 Excel

5 New Function needs to learn

1.Sort formula
 when you sort salary and any data in the excel so we can do it by formal 
Sort Function 

=Sort(Table ) enter

2. Unique formula for data combination

If have big data and some unique data you need to do separate 
=Unique(area column )
Unique(area column, False,thue) enter

3 Xlookup formula
 by Xolookup you can pull data as per as per requirement like

Xlookup(subject,first column, Second column) enter

Example - Candidate -ABCD, amount is 1,2,3,4
Requirement is need as what is C amount 

C : Xlookup(Subject(C), First column ABCD, Second column Amount) enter=3

4 Filter Formula
You have big data and you need candidate details specially salary 
Like who's salary is above 50000 that list you can filter easy by formula

=Filter(Select Table, Salary column>50000) enter if you need less then 50000 choose <50000

5 Sequence formula

you need to update sequence in excel so you and update easy sequence number in the data

1. =Sequence( 10) enter automatic 1 to 10 sequence you can update

2.  if you have candidate names without sequence like
A
B
C
D

example -candidate sequence we are updating ahead column of candidate name
=Sequence(A range #) automatic 1,2,3,4 sequence udpate 

This is new update to be in the 2021 excel .


 









Comments

Post a Comment

Popular posts from this blog

Raja Rayamlot kalla

 राजस्थान में अनेक वीरों ने मातृभूमि की रक्षा के लिए अपना बलिदान दिया, जिससे उनकी छवि लोकदेवता जैसी बन गयी। कल्ला जी राठौड़ ऐसे ही एक महामानव थे। उनका जन्म मेड़ता राजपरिवार में आश्विन शुक्ल 8, विक्रम संवत 1601 को हुआ था। इनके पिता मेड़ता के राव जयमल के छोटे भाई आसासिंह थे। भक्तिमती मीराबाई इनकी बुआ थीं। कल्ला जी की रुचि बचपन से सामान्य शिक्षा के साथ ही योगाभ्यास, औषध विज्ञान तथा शस्त्र संचालन में भी थी। प्रसिद्ध योगी भैरवनाथ से इन्होंने योग की शिक्षा पायी। इसी समय मुगल आक्रमणकारी अकबर ने मेड़ता पर हमला किया। राव जयमल के नेतृत्व में आसासिंह तथा कल्ला जी ने अकबर का डटकर मुकाबला किया; पर सफलता न मिलते देख राव जयमल अपने परिवार सहित घेरेबन्दी से निकल कर चित्तौड़ पहुँच गये। राणा उदयसिंह ने उनका स्वागत कर उन्हें बदनौर की जागीर प्रदान की। कल्ला जी को रणढालपुर की जागीर देकर गुजरात की सीमा से लगे क्षेत्र का रक्षक नियुक्त किया। कुछ समय बाद कल्ला जी का विवाह शिवगढ़ के राव कृष्णदास की पुत्री कृष्णा से तय हुआ। द्वाराचार के समय जब उनकी सास आरती उतार रही थी, तभी राणा उदयसिंह का सन्देश मिला कि अकबर...
Read more

Rental income property for sale in Mohali

Residential Flats In Mohali Punjab With Rental Income ₹ 15.90 Lakh/  Number   Get Latest Price Type residential Type Of Property Residential City mohali Area Of Construction 660 Floor 5 Number Of Rooms 1 Please go on this website where we will get more information about Mohali rental rooms and income related. https://www.99acres.com/commercial-property-for-rent-in-mohali-ffid https://flatfy.in/commercial-space-for-rent-mohali https://www.indiamart.com/proddetail/flats-in-mohali-punjab-with-rental-income-20979461473.html https://www.magicbricks.com/commercial-property-for-rent-in-mohali-pp https://dir.indiamart.com/mohali/commercial-property.html https://www.hlpgalleria.com/commercial-property-in-mohali/?gclid=CjwKCAjwmv-DBhAMEiwA7xYrdw428OVnED2MyY5c_ihbbPraGmtqUVY-ha5nBMQtqge4QG53ys75fhoCXVYQAvD_BwE If you need office space rental related information Please click on below website https://dir.indiamart.com/mohali/office-space.html https://www.99acres.com/commercial-property-in-...
Read more

Aryan khan emotional coalescence with this parent Shahrukh and Gauri khan on came from jail | आर्यन खान इस माता-पिता शाहरुख और गौरी खान के साथ भावनात्मक रूप से जेल से आए

Image
Aryan Khan emotional with his Parent  Superstar Shah rukh khan's son Aryan khan has been come  back home on 30 October 2021after 22 days jail. His mother Gauri khan is emotions when aryan came back home. Aryan khan's bail has accepted his little brother abram is very happy when Aryan reached home after long time. However, the little munchkin reportedly failed to understand why everyone was being so emotional about it and crying. Aryan’s sister Suhana, who is currently in the US, connected with him through a video call. SRK and Gauri had prepared a new routine for Aryan to follow after his return from jail. Right from getting his medical check-up done to getting some nutritional food to arranging for his counselling, they made sure Aryan got what was necessary.
Read more