Data Analysis & Visualization in Excel: Pre-processing, Analysis, and Visualization Techniques

This article discusses the importance of data pre-processing, analysis, and visualization in Excel. It covers various Excel functions and options such as filter, SUMIFS, and Pivot Table for data pre-processing. The findings related to yearly sales, yearly profit, change in sales, change in profit, and product-wise sales and profits are analyzed. The article also includes graphical representations of the data. This content is relevant for A2 Data Analysis & Visualization.