Concat VS. Concatenate VS. Textjoin
The CONCAT, CONCATENATE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.
Removing Duplicates In Excel
We frequently encounter data while working with lists. It is a common problem caused by human error as well as duplication of data due to common practices – copy and paste procedure for consolidation of data.
.png "Using Excel’s Multiple Criteria In VLOOKUP Function")
Using Excel’s Multiple Criteria In VLOOKUP Function
Microsoft Excel’s VLOOKUP function is a popular feature amongst office personnel and data processor positions.
How to use CONCAT function
The CONCAT function was recently introduced by replacing CONCATANETE function and the CONCAT is only available with the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).
VLOOKUP for Dummies
VLOOKUP stands for Vertical Lookup. Learning vlookup is very easy but let’s first understand how VLOOKUP works?
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
