This Repository Contains Solution to the Assignments of Excel Skills For Business - Macquarie-University on Coursera Taught by Nicky Bull, Dr Prashan S. M. Karunaratne, Professor Yvonne Breyer

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.

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

Analyzed Kickstarter data to uncover trends in Fundraising techniques using Excel with an emphasis on Pivot Tables.

This project required me to organize and analyze a database of 4,200 past Kickstarter campaigns to uncover any hidden trends. Kickstarter has been hugely successful as a crowdfunding service, but all of the projects have not seen success.

Dashboard with useful KPI shown, created using pivot table and pivot chart

Performing analysis on kickstarter data to identify trends using Excel

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.

Built a dynamic Workforce & Sales Intelligence Dashboard that integrates employee, attendance, and CRM data to surface workforce capacity, sales pipeline health, win rates, and revenue forecasts. Features include calculated KPIs, cohort analysis, role-level performance, territory heatmaps, and interactive filters for time, team, and product.

📊 Excel Projects Portfolio – A collection of 5 projects showcasing skills from basic formulas to advanced dashboards using Excel, Pivot Tables, Power Query and Power Pivot. Includes Payroll System, Advanced Charts, Student Marksheet, and Interactive Sales Dashboards.

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…

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.

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

Sales Performance of Coffee shop using Microsoft Excel

A sample server with Flexmonster Accelerator as a DLL

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

This is an Excel sales dashboard I built to clearly understand business performance including sales, profit, customer count, and trends across different categories and states.

Performing analysis on kickstarter data to identify trends using Excel

Excel-based project focused on data cleaning, XLOOKUP, Pivot Tables and Pivot Charts

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