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:

Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.

Data Analysis of a Superstore using MS Excel with Visualization

Developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.

Advanced MS Excel

Developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.

'Vrinda Store' Data Analysis Project using Excel

Created an dashboard on excel using e-commerce datasets

An analysis of Amazon Stock Data from December 2020 to November 2021 that provides information regarding increase/decrease in Amazon's value on any given day.

This repository serves as a showcase of the skills I've acquired through Datacamp's "Data Analysis in Excel" course.

Statistical Analysis using Excel Spreadsheets

Advanced MS Excel

This DAX-based eCommerce dashboard provides a real-time snapshot of a business's financial position, aiding FP&A by highlighting key metrics for better decision-making. It handles large datasets from 2019 to 2021, visualizing KPIs like cumulative sales, profitable customers, and profit trends.

Data-driven analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optimize inventory levels, reduce costs, and improve customer satisfaction in a complex supply chain environment.

Utilizing Excel and statistics, including t-tests and z-tests, in the analysis of housing prices to determine the most influential factors driving home prices.

This project showcases a comprehensive Customer Detail Dashboard built using Excel. It visualizes key metrics and insights from transactional data (2020-2022), providing an interactive interface for analyzing customer behavior, sales performance, and profitability across regions and demographics.

Conducted extensive analysis of WeTalk's 2020 Q1 dataset using Google Sheets. Leveraged pivot charts to extract actionable insights, meticulously crafting a comprehensive dashboard for detailed evaluation of agent performance and operational trends in the support center.

Data-driven analysis of customer churn in telecommunications (2015-2018). Identifies key factors influencing customer retention, provides insights on demographic and behavioral patterns, and offers strategies to reduce churn and increase customer lifetime value.