23MEE309 – Excel for Business – Essentials

You are now a Dashboard Hero helping a college student manage monthly expenses with a dataset of at least 30 entries including Date, Expense Type, Description, Amount, Payment Mode, and Essential/Non-Essential. Calculate total expenses, category-wise spending, and remaining budget using formulas like IF, SUM, TEXT, and percentage calculations. Apply data validation dropdowns, conditional formatting to flag overspending, and create a dynamic dashboard with charts and a “Savings Alert” feature. Optional bonus challenges include adding slicers, Pivot Tables, donut charts, sparklines, or protecting worksheet cells. Submit a well-formatted Excel workbook with separate sheets for raw data, analysis, and dashboard, and aim to earn achievement badges such as Formula Master, Chart Wizard, Data Detective, and Excel Hero for completing the tasks. (Microsoft – 2025) (APP)