Career Aspiration Of Gen-Z ,To explore the industries, roles, and pathways using Excel .

Sales Performance of Coffee shop using Microsoft Excel

This repo contains an analysis of a theater fundraising campaign to determine ideal parameters to achieve optimal results. The dataset was analyzed in Microsoft Excel using Pivot Tables, Pivot Charts, COUNTIFS formulas, and line charts. This was the first assignment for the Data Analysis Boot Camp where Git Bash and the SSH key were set up to pu…

Performing analysis on kickstarter data to identify trends using Excel

Finding out potential target customers for personal loans using HBFC data.

This project focuses on data cleaning, transformation, and dashboard creation using a bike buyers dataset. It includes Pivot Tables, slicers, visualizations, and statistical insights to analyze trends based on income, age, occupation, and other key factors. Insights help understand customer behavior, purchasing patterns, and decision-making trends.

Created a dynamic and interactive Excel dashboard for "Complete Corner" Store's Sales Annual Report 2023

This project analyzes HR metrics over a decade, using visualizations to focus on employee growth, turnover, average staff, cost per employee, and annual business expenses.

Excel assignment covering conditional formatting, formulas, PivotTables, and PivotCharts (Due: 03-06-2021)

Mastered Excel Pivot Tables with a comprehensive Udemy course. Enhanced data analysis skills, learned advanced functionalities, and gained proficiency in creating dynamic and insightful reports.

Analysis of Kickstarter Campaign Data using Pivot Tables and Pivot Charts

Excel data analysis on sales data using pivot tables and charts with a dashboard

The eCommerce Store Sales Dashboard provides a comprehensive view of sales performance, customer trends, and product insights. Built using Microsoft Excel, it leverages pivot tables, charts, and slicers for interactive data analysis and decision-making.

"Excel BootCamp: A comprehensive guide covering essential Excel functions, formulas, data analysis, and automation techniques. Perfect for beginners and professionals looking to enhance their Excel skills!"

The goal of this project was to organize and analyze a database of 4,000 past Kickstarter projects to uncover any hidden trends.

Excel Analysis of Kickstarter Campaigns

Leveraging on Excel functions to clean data and pivot tables for dimensioning and analysis, churn was estimated using functions like SUBTOTAL, COUNTIFs, NESTED IFs etc.

Using Excel to Analyse and Visualize Data

This project provides an Excel-based analysis of car model unit sales to identify key insights and performance discrepancies.