Excel database Analysis - how to analyze and visualize the data easily.

Using Excel data analysis tools you can visualize the data and remove duplicates and much more, here is the examples about few statistical analysis tools and how to analyze and visualize the Excel data s easily. 

Click here to Download  Excel Formulas – Master Workbook [14-01-2016] Size-40kb

1.       Format Painter : Copy formatting form one Place to Apply it to another, you can customize and design your excel data to understand easily.

2.       Conditional Formatting : Highlight Interesting cells emphasize unusual values, And visualize         data using data Bars, color scales, and icon sets based on criteria to Analysis you excel data,

3.       RefreshAll: Update all the information in the workbook that is coming from a data source
(Pivot Table, SQL, Data from another sheet) To Analysis excel data.

4.       Text to column: To Analysis Data Separate the content of one Excel cell into separate column, For Example you can separate a column of full name into First name and last name to clean and visualize the useful data easily,

5.       Remove Duplicate: Remove Duplicate values from a sheet or column cells To Analysis Data, You can specify which column should be checked for Duplicate,

6.       Filter: Enable Filtering of the selected cells or columns, Once the Filter turned on click             column header to choose a filter for column To Analysis Data.

7.       Protection: To Analysis Data You can prevent people from editing Locked cells or changing the from the cells,

8.       FreezePanes: Analysis Data To keep a portion of the sheet visible while rest of the cells scroll,

09.       Data Validation & Dependent Drop-down lists: Prevent invalid data from being entered into cell and creating custome drop down in cells To Analysis Data,

10.       Remove Zero:  Remove zero in the cell that have zero values.

11.       What-If Analysis: What-If Analysis in Excel allows you to try out different values                       (scenarios) for formulas To Analysis Data.