This repository contains an Excel module project focused on data cleaning, analysis, and visualization for an e-commerce dashboard. It includes tasks such as data entry, table creation, and data cleaning to handle duplicates, missing, and inconsistent data.
From the README
VENKADESH-EXCEL-E-COMMERCE-DASHBOARD EXCEL MODULE END ASSIGNMENT 1 : DATA CLEANING, ANALYSIS AND VISUALIZATION WITH EXCEL DATE OF SUBMISSION : 15/07/2026 – 08:00AM PREVIEW SCREENSHOTS : QUESTIONS 1) DATA ENTRY, IMPORT, AND BASIC ORGANIZATION USING TABLES 1.1) TABLE CREATION IN ALL WORKSHEETS 1.1.1) TABLING CUSTOMER WORKSHEET 1.1.2) TABLING PRODUCT WORKSHEET 1.1.3) TABLING STORE WORKSHEET 1.1.4) TABLING SALES WORKSHEET THIS ONLY 2) DATA CLEANING: FIND/REMOVE DUPLICATES, HANDLE MISSING/INCONSISTENT DATA, CORRECT FORMATTING ERRORS, AND VALIDATE DATA 2.1) INCONSISTENT DATA "TYPOS" IN ALL WORKSHEETS 2.1.1) CHANGING TYPOS IN ALL WORKSHEETS 2.2) CORRECTING WORKSHEET 2.2.1) ID'S USING FILL...
