This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:
-
Basic of excel Excel Function
- Advance Excel Pratice file:
- Advance Excel Pratice file:
-
Lookup & functions Lookup
-
Conditional formating
-
Data validation
-
Sorting and filtering
-
Data analysis using toolpak
Ecommerce-Sales-Analysis
An Ecommerce Sales Analysis Dashboard showcasing proficient data analysis in Microsoft Excel. Gain insights into sales, profit, regional performance, category-wise profitability, top-selling subcategories, and a pie chart analysis of ecommerce sales composition. This project offers a data-driven approach to decision-making within the ecommerce sector, aiding in revenue optimization and strategic planning
MacDonald Sales
Discover the 'MacDonald's Sales 2022 Dashboard,' a project that offers a comprehensive analysis of sales and customer-related data within the fast-food industry. This analysis includes insights into sales, profit, and the number of customers, a sales trend graph comparing 2021 to 2022, a pie chart of customer satisfaction, and a breakdown of sales by country in 2022. Gain valuable insights into financial performance, year-over-year trends, and customer sentiment to enhance strategic decision-making for MacDonald's
Adidas Sales Analysis
Explore the 'Adidas Sales Analysis Dashboard' project, which offers an in-depth analysis of Adidas's sales performance. This analysis includes sales in USD ($), sales by region, and sales by method, providing insights into financial performance and distribution strategies. Additionally, a bar graph visualizes retailer sales and profit, helping to identify key contributors to overall sales and profitability in the sportswear industry
SalesDashboad 
D Mart 
Sales Superstore Sample: Sales Performance Dashboard
connect with me :
Name:- Subham Kumar
Email:- kumarsubham0734@gmail.com
Linkden:- https://www.linkedin.com/in/ksubham/