How Microsoft Excel is Used in Real-World Data Analysis

EXCEL Definition :Microsoft Excel is a spreadsheet program developed by Microsoft that allows you to Collect, Organize, analyze and visualize data using tables and charts. Through examples I will explain to you on how data analysts' use Ms Excel on the day to day basis when working with datasets DATA ORGANIZATION Many companies deal with very large amounts of data and when it comes to organizing and cleaning the data, thats where Excel comes in. Many data comes very messy ,unstructured and with missing values and it needs to be formatted and cleaned to get better structured datasets for analysis WAYS TO FORMAT AND CLEAN DATA One of the ways to clean your data is by Remove duplicate To remove duplicates you simply Select your dataset, go to the Data tab click Remove Duplicates below is an example changing columns to their respective data types Data analysis with formulas Excel allows users to perform calculations quickly Below are the different types of formulas used in excel by majorit