Скачать или смотреть Excel Experiment 6

EXCEL LAB
EXPERIMENT 6

PRACTICAL APPLICATION OF EXCEL FOR INTERACTIVE DATA ANALYSIS AND VISUALIZATION

You are required to take on the role of a sales data analyst. Your task is to perform end-to-end data analytics on a dataset of your choice and create an interactive Excel dashboard to present your findings clearly and effectively. You are encouraged to implement features such as slicers, pivot tables, interactive charts, KPIs, and conditional formatting, but your dashboard is not limited to these features. You can any additional functionality that enhance analysis and visualization.
1. Dataset Selection
2. Data Cleaning and Preparation
3. Data Analysis
4. Interactive Dashboard Features