Microsoft Excel – Proven Spreadsheet Software for Analytics

Description

Microsoft Excel is one of the essential spreadseet sotware for data analytics. It uses for small or mid scale data storage and analytics. They offe wide range of visualization charts also to represent data.

Microsoft Excel Features :

1. Data Presentation : Various visualization charts are used for presenting data in Microsoft Excel.
2. Data Collaboration : With the help of workbooks and spreadsheets Microsot Ecel widely used for data collaboration in Analytics, data sharng or other many more services.
3. Data Analysis and manipulation
   1. Data queries, Functions and Formulas : Formulas and functions like Sum, Add and Substract etc are useful for basic calculations and some advanced formulas also available like Average, Vlookup, Hlookup and percentage etc.
   2. Conditional Formatting : It is used for formatting data like higlighting data on some condition, adding data bars, adding colors and adding icons etc.
   3. Filter and Sorting : We can filter out and sort data according to letters or values ascending or descending values.
   4. Data Validation : Data validation will check data. It ensures correct and consistant data filled in cells.
   5. Data Connections : We can import data from web, pdf and many different sources through data connections.

Advanced Features

1. Power Query :  Power query is used for data importation transformation and manipulation. it is also used in data modelling data visualisation and creating dashboards. we can form centralised data for data visualisation with the help of power query different formulas.

   Power query also useful for merge clean and manipulate data

Microsoft Excel pricing

Microsoft Excel offers different pricing with free and paid licences. you can buy Microsoft Excel software alone or it comes with Microsoft Office plans.

Pros :

1. Easy to use
2. Free and affordable in pricing
3. User friendly UI.
4. Most important tool in Analytics

Cons:

1. Large dataset will slow down excel spreadsheets.
2. Data security : anyone can share ecel sheet.