Learn data analysis and                interpretation using ms excel online :-

There are three steps to master Excel or to analyze very big data, all steps one by one will be explained here.

if we have rough data of more than 90 thousands entries, than we have to first prepare that data in a proper manner, after that we can analyze data to get the desired result, and finally to get a clear idea about the result we can visualize it using various graphs and tables. we will learn each step one by one here.

Data Preparation in MS Excel

Preparation of raw data is the first step in data analysation various functions given in MS excel are used for data preparation. like sort and filters, formulas and various other functions.

Data preparation is the first step for big data. If data is properly prepared than it is easy to visualize it for further work.

Data Analysation in MS Excel

Data analysation is one of the advanced ms excel skill  which is use to analyse big data simply.

there are various tools like pivot table, v lookup etc. are the mostly used tools in the excel which are used in data analysis.

 Data Visualization in MS Excel

Once the Raw data is prepared in a proper way and this data is analysed  using analytical tools we than simply display our data in good way like in charts, graphs etc.

In industries chart and graphs are the key point to take decision as it reduce our effort by making big data into small simple beautiful graphs and charts.