How Excel is Used in Real World Data Analysis

Excel is a Spreadsheet Software by Microsoft that helps to turn raw data(numbers, text, date)into meaningful information/insights. It is used to organize data, do calculations, visualizations and create dashboards. Therefore What is Data Analysis? Data Analysis is the application of tools and techniques to organize, study, reach conclusions, and sometimes make predictions about a specific collection of information. Excel is one of the most powerful tools that is used to do Data Analysis. The point of data analysis is to understand information on some deeper, more meaningful level. By definition, raw data is a mere collection of facts that by themselves tell you little or nothing of any importance. To gain some understanding of the data, you must manipulate the data in some meaningful way. The purpose of manipulating data can be something as simple as finding the sum or average of a column of numbers or as complex as employing a full-scale regression analysis to determine the underlying