Excel
Mastering Data Cleaning in Excel
Data cleaning is the process of identifying and correcting errors, inconsistencies, and inaccuracies in datasets to ensure they are accurate, reliable, and ready for analysis. It involves a series of steps, from removing duplicates and handling missing values to standardizing data formats and correcting errors.
Data Discovery : Crafting Excel Sales Dashboard for Supermarket Sales
This dashboard analyzes supermarket sales data, covering sales period, amounts, product lines, city-wise ratings, and payment methods to track performance over time.
Sales Pipeline Analysis using Excel : Finding Trends and Insights
This project explores sales funnel dynamics using Excel to identify patterns, track sales progress, and visualize key performance indicators (KPIs).