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

A sample server with Flexmonster Accelerator as a DLL

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

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

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.

Dashboard of road accidents occured during the period of 2021-22 with different reasons behind. Using Ms excel for the data processing and creating pivot tables , using fucntions and may more features of excel to create the final dashboard to give quick overview of data

Over $2 billion was raised using the successful crowdsourcing service, Kickstarter, but not every campaign found success. Crowdfunding Campaigns were analyzed to determine what led to success.

Performing analysis on kickstarter data to identify trends using 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…

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

Sales Performance of Coffee shop using Microsoft Excel

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.

Integrated customer and product data in Excel's orders worksheet using INDEX, MATCH, and IF functions with absolute referencing. The project showcased adept Excel skills, featuring dynamic pivot tables and an interactive dashboard with timeline filters for insightful coffee sales analytics.

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

Analysis on Kickstarter data for a crowd funding campaign. Charts done on pivot tables and charts in Excel.

This project explores the data science job market, revealing correlations between skills, job roles, regions, and salaries. Leveraging Excel’s Power Query, PivotTables, DAX, and charts, it highlights high-paying skills like Python and SQL. These insights aim to guide data professionals toward in-demand skills for competitive career growth.