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
-
Updated
Jun 17, 2024
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
Analyzed Kickstarter data to uncover trends in Fundraising techniques using Excel with an emphasis on Pivot Tables.
Dashboard with useful KPI shown, created using pivot table and pivot chart
Performing analysis on kickstarter data to identify trends using Excel
Finding out potential target customers for personal loans using HBFC data.
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…
Created a dynamic and interactive Excel dashboard for "Complete Corner" Store's Sales Annual Report 2023
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
A sample server with Flexmonster Accelerator as a DLL
Analysis on Kickstarter data for a crowd funding campaign. Charts done on pivot tables and charts in Excel.
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.
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
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.
This excel practice project involves kickstarter campaign data. Additional calculations, conditional formatting, pivot tables and charts were used to analyze the data. The word document contains a write-up of the analysis.
Add a description, image, and links to the pivot-charts topic page so that developers can more easily learn about it.
To associate your repository with the pivot-charts topic, visit your repo's landing page and select "manage topics."