Create Excel Dashboard with E-Commerce Sales Data

In this tutorial, we will learn how to create data visualizations in Excel using a real-world Kaggle Superstore e-commerce dataset. The video explains step-by-step how to organise raw data, apply aggregation formulas, and build charts and dashboards for data analysis. Topics covered in this tutorial: Importing and preparing Excel data Converting raw data into Excel tables Using formulas such as: SUM SUMIF COUNTIF AVERAGE Creating summary tables Building bar charts, pie charts, and line charts Creating a simple Excel dashboard Analysing sales and profit trends This tutorial is suitable for: Beginners learning Excel visualization Students working on data analytics assignments Anyone interested in business analytics and dashboard creation Dataset used: Kaggle Superstore Dataset Tools used: Microsoft Excel Kaggle Dataset