How Excel is used in Real World Data Analysis

What is Excel? Excel is a spreadsheet application that allows organizing, manipulating, calculating and visualizing data. Uses grid od rows and columns. Each grid is a cell that holds data. How is Excel Used in the Real world Excel is used across industries including finance, healthcare, marketing and retail. Common real-world applications; Sales analysis: Tracking product performance, revenue and discounts. Financial reporting: Budgeting, forecasting and expense tracking Project management and planning: Create timelines, track tasks, and allocate resources. Customer relationship management: Small businesses use excel to store, organize and analyze customer information and sales inquiries. Data Cleaning This involves removing inconsistencies, duplicates and errors to prepare data for analysis.Real world data features missing values, duplicates and inconsistent formatting. Here are the steps that I worked through: Back up data: Created a copy of the original dataset Removing duplicates: