1.Exact-Use to identify that is there any two identical data in two different strings.
2.Trim-Use to adjust text function in proper way inside a string.
3.Sort-Use to adjust the given set of numeric data in ascending order.
4.Text-Use to convert numeric data into textual data.
5.Value-Use to convert textual data into numeric data.
6.Concatenate-Use to merge two data in two different strings into one in a particular string
7.Upper-Use to convert textual data into capital letters.
8.Lower-Use to convert textual data into small letters.
9.Proper-Use to convert textual data in proper alphabetical way.
10.Len-Use to find the length of data in a string.
11.Right-Use to eliminate left portion of the data in a string.
12.Left-Use to eliminate right portion of the data in a string.
13.Today-Use to find the current date.
14 Now-Use to find current date and time.
15.Day-Use to find the date from Date/Month/Year.
16.Month-Use to find the month from Date/Month/Year.
17.Year-Use to find the year from Date/Month/Year.
18.Edate-Use to add month in Date/Month/Year.
19.Vlookup-Use to look for a certain value in the given table of the given data set.
Issues that I encountered while learning.
The first Issue that I faced while learning exact function.I was facing difficulty while implementing the exact function then I checked the formula where I mistakenly used colon symbol instead of coma symbol and my issue got fixed
=Exact(A1:A2) to =Exact(A1,A2)
The second issue I faced was while implementing vlookup function I was not able to get my desired value I got a value from different column,then I checked the formula and I mistakenly written the wrong column.Then I corrected my column index no and my issue got fixed.
My learnings
The most important thing I learned is to fill correct values inside the excel formula to get your desired result.
Top comments (0)