Microsoft Excel is the industry leading spreadsheet software program,
a powerful data visualization and analysis tool
Excel used in data analysis
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Recent Projects
Project 1: Sales Dashboard
I showes in this project how to use Excel Pivot Table and Pivot Chart to create interactive Dashboard which provides compelling data visualization and lets you interact with and explore data to gain insights into why things are happening or have happened in the Market.
Project 2: Chocolates Stores
In this project I cleaned the data using Microsoft Excel (Power Query) ,combined two datasets and did EDA with Excel formulas & tables ,then Used formulas like COUNTIFS, SUMIFS, XLOOKUP,thenVisual analytics and I Generated Dashboard .
Project 3: Bike Stores Dashboard
In this project i utilized SQL to extract data from different related tables from sales databases using JOIN and VIEW then transformed and filtered data by using aggregating and filtering function to improve reporting process then create Excel dashboard.
GitHub
To explore my next project, catching up with what’s trending, so connect with My GitHub Account.