If you think that Excel/ WPS is an entry-level software, you need to reconsider. Real that excel is right for essential data mining, storage, and collection tasks, but it can do much more now.
Be a genius in Data Analysis & MIS. Download coupons, FKL, CV & lessons
Top 10 Data Analysis tips that a data scientist should know
As the name suggests, this function helps you find a piece of information from a large and complex set of data. It also allows you to extract data and put it in your new table.
You just have to move to the insert function tab where you’ll find the VLOOKUP option. Here are some of the variables in VLOOKUP.
In this function, your typed variable will start finding the values from all the cells of the broad set of information.
In this one, you can set the range of data from where you want to look. It forms a limit and saves valuable time for the software. Hence, you will save time as well as you can manually set range on the data.
Col index num
Here you can select the column from which you want to find the data. It’s once again making the task more comfortable and faster.
Enroll now in our Global Advanced Data Analysis Courses. 100% value for money
The range looks up option shows either true or false. The right end of data will provide you with information close to the variable you put in. It’s like the function will try to find how much true or accurate your information is. On the other hand, false would not provide you anything and show NA if it doesn’t find the exact result.
One of the most common and popular functions, Sum, simply sums up the selected values. You can choose any part of the column to add up or choose the whole row or column to see the total value. It comes in very handy in invoices, sales figures, and more.
The IF function segregated information between true or false based on particular criteria. You write the criteria function or variable like:
IF (Criteria, True & False value)
Once you lodge in the criteria, the software checks the values that are true or false.
Top 30 Advanced Excel functions that a data scientist should know Credits: The Windows Club
This function lets you find out the maximum value of a particular data. It shows the range of the data. You just have to lodge MAX in the function tab to check out the maximum amount in the selected data.
In contrast to the max function, the MIN function allows you to check the minimum value in the selected set of data. It will tell you the lowest value from the primary data table.
SUMIF function helps find a particular piece of information that gets matched with your criteria. You have to enter the variable in the wizard box. The box contains the sum range tab, criteria tab, and range tab.
The range tab zeroes in on the area while the sum tab adds up the data.