| Sl. No. |
Description |
Keywords |
| 1 | Student Performance Analysis in Excel: Scores, Averages, and Formatting | formatting ,sorting |
| 2 | Product Inventory Management and Analysis in Excel | formatting , formulas |
| 3 | Sales Analysis and Trends Visualization in Excel | sum ,average ,countif ,max |
| 4 | Financial Statement Analysis: Profitability and Performance Metrics in Excel | formula ,pie chart ,financial |
| 5 | Employee Database Management and Analysis in Excel | hr, vlookup, datedif ,pivottable |
| 6 | Order Management and Sales Analysis in Excel | index ,match , pivotchart , slicers |
| 7 | Investment Analysis | formula ,average ,column chart |
| 8 | Customer Feedback Analysis: Evaluating Satisfaction and Insights Using Excel | countif ,radar chart |
| 9 | Budget Planning and Analysis: Evaluating Performance and Variances in Excel | variance ,sum ,if ,clustered column chart ,trendline |
| 10 | Project Timeline Management: Tracking Tasks and Visualizing Progress in Excel | datedif ,gantt chart |
| 11 | Sales Dashboard | index ,match , pivotchart , slicers |
| 12 | Customer Feedback Analysis | countif ,radar chart |
| 13 | Budget Analysis and Performance | sum ,clustered column chart |
| 14 | Project Task Timeline and Status Overview | datedif ,gantt chart |
| 15 | Product Comparison | pie chart |
| 16 | Revenue Analysis and Visualization | histogram , line chart, radar cahrt |
| 17 | Customer Segmentation and Analysis | average, coutif, pivotchart |
| 18 | Stock Performance Analysis | a line chart ,trendline |
| 19 | Sales Performance Analysis | pivottable , |
| 20 | Customer Analysis | pivottable |
| 21 | Inventory Management analysis | average ,countifs |
| 22 | Sales Forecasting and Analysis | sum , forecast |
| 23 | Financial Analysis and Visualization | cagr, if, npv , waterfall chart |
| 24 | Customer Segmentation and Analysis | averageif ,sumifs , rank |
| 25 | Loan Amortization and Financial Analysis | pmt , date |
| 26 | Stock Portfolio Analysis | xnpv , textjoin |
| 27 | Employee Performance Evaluation and Analysis | averageifs ,vlookup ,index ,match |
| 28 | Project Management Dashboard | datedif ,gantt chart |
| 29 | Customer Churn Analysis | averageif , pivotchart |
| 30 | Market Analysis | index ,match ,large |
| 31 | Monthly Sales Dashboard | combo chart , slicer |
| 32 | Customer Satisfaction Dashboard | pivottable , pivotchart ,donut chart |
| 33 | Project Status Dashboard | stacked bar chart ,pivottable , pivotchart |
| 34 | Financial Performance Dashboard | pivottable ,pivotchart ,sparklines |
| 35 | Sales Performance Dashboard | pivottable ,a clustered column ,slicer, pivottable ,data bars |
| 36 | Data Cleansing and Transformation | substitute ,trim ,a data validation |
| 37 | Sales Data Automation | vlookup ,index , match,sumproduct ,offset |
| 38 | Employee Data Analysis and Reporting | datedif ,pivottable ,sumifs ,pivotchart ,data validation |
| 39 | Inventory Management and Analysis | today ,countifs ,pivottable ,pivotchart |
| 40 | Financial Modeling | forecast ,return on investment (roi) ,goal seek ,scenario manager , |
| 41 | Scenario Analysis | goal seek ,index and match |
| 42 | Investment Portfolio Analysis | return on investment (roi) ,index and match , waterfall chart |
| 43 | Monte Carlo Simulation for Revenue Projection and NPV Analysis | npv ,countif , line chart |
| 44 | Statistical Analysis | correl ,t.test ,frequency |
| 45 | Optimization Modeling | Scenario Manager |