Data Analysis with Microsoft Excel

Description

Microsoft Excel (Popularly Known as MS Excel) is a Spreadsheet developed by Microsoft. It have the following features;

• It organize Data and Numbers
• It is use for Calculation
• It has a designing tools for Visualization
• It is deigned for various Operating System OS (which include Windows, MacOS and many more…)

How to Open Microsoft Excel Document on your Computer

• Click on Start button on the desktop
• Search for Microsoft Excel
• Open the Microsoft Excel your Searched and click on blank workbook
• And your Microsoft Excel document will display

How to perform Data Analysis with Microsoft Excel 

There are basically four stage to perform Data Analysis, they include:

• Data Exploration Stage
• Data Preparation Stage
• Data Cleaning Stage
• Data Visualization Stage

Data Exploration Stage

It basically deal with Knowing the data very well, getting familiar with the data

Asking the question.. How many rows those the data set have?, How many columns does the data set have?, What is the total sales(Revenue, Price etc.)?, What is the mean, median and mode? and many more….