Analytics with Excel

What is a pivot table? Most of the analysts think that the pivot table takes row data and summarizes it. So you can make sense of it all without typing any formulas! Basically, we know how to use the pivot tables that we've already learned. A pivot table is a "bharmashtra" for analysts & learners of Excel. Pivot tables can summarize huge amounts of data.  How do you create a pivot table? The first step to creating a good pivot table is to make sure the data is in good shape. So, make sure you do the following before you create a pivot table. Lots of people use the word "column."  But in a pivot table, a column is a field. That first thing—try to remember this as you are creating the pivot table. After making a pivot table, the data needs to be dragged into fields (e.g., filters, columns, rows, and values). After the table is ready, we need to be ready for dashboard insight. For dashboard creation, we have to use pivot charts. Conclusion: In a simple way, for...

Demonstration of one of the most useful weapons in the tech industry. When we talk about lookup functions in Excel, then comes the most desirable VLOOKUP function. This is the core lookup function, used in every analytics task. So let's discuss this awesome function. And where we can use this function. If I would say... search/find the value on behalf of the name/value in large tables. So how would you search the right value on behalf of that value? In that case, we will use the VLOOKUP function. We listen to some of these things like that every day at our offices. But most of the professionals or learners are not aware of this function even now. VLOOKUP is the oldest function still in use now. The right syntax is below here with an explanation. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) lookup value: what you want to search on behalf of that argument. table_array: - Select the range from the located lookup value to the endpoint. (e.g. A1:C10) col_index_num:...

What is the TRIM function in Excel? When we prepare the data, the first step is data cleaning. Data cleaning is the most important criterion for the analysis of any data. Here we will discuss the most hidden function called "TRIM."      The TRIM function does clean extra spaces from the selected cell. The specialty of this function is making cleaning of the data and ensuring that data is properly usable for analysis. This is the specialty to put the right spaces and remove some extra spaces. This is the core thing, to make this function standable in the data cleaning part.  The TRIM function syntax is here: =TRIM(text) text:- The text or cell, which you want to remove the extra spaces.