I have completed some MS Excel Course. This repository contains all the excel files (practice and exercises solutions by me) which were provided as Homework's or as hands on practice in course section.
Analysis of the Sakila DVD Rental database using SQL
Analysis of Company data to optimise marketing strategy and promote growth using Excel, Powerpoint & Tableau
Using VBA, analyzing one year of stock data
Statistics Using Excel
The project utilized Tableau, Excel and MySQL to analyze CSV-based employee data, offering insights into performance and attrition, aimed at enhancing employee retention and satisfaction.
This project leverages Excel 📊 to forecast YouTube views 📈 for the next 7 days using three methods: FORECAST Function 📉 Graph Trendlines 📈 Forecast Sheet Tool 📅 By comparing these methods, the project aims to identify the most accurate forecasting technique 🎯 and enhance predictive accuracy 🔍 for future view counts.
Data analyses and visualizations of Kickstarter Campaigns using Excel. UT Austin Bootcamp homework assignment.
This repository consists of all the projects done by me under the field of Data analysis.
Google Data Analytics Capstone Project
Analysis and comparison of the local and global temperature trends
Statistics Using Excel
This project analyzes a dataset of 1,000 crowdfunding campaigns to uncover market trends and identify factors contributing to the success or failure of campaigns. Using Excel, the project applies various analytical techniques including conditional formatting, pivot tables, statistical analysis, and goal-based success evaluation.
This repository stores the report and documentation of a data analytics project that evaluates the marketing campaign for top five clients of a Phantom firm using metrics and KPIs as success criterias.
Duke University project: Data analysis in Excel (statistical analysis)
Store analysis and Dashboard using Advanced Excel
This project involves creating a dynamic registration form in Excel, featuring dependent dropdown lists 📋, functional macros ⚙️, and protected sheets 🔒. The goal is to streamline data collection for meetings, ensuring ease of use and data integrity. 🌟📊
This project showcases a comprehensive Sales Dashboard designed to provide insightful visualizations and data-driven insights into sales performance across different time frames and categories. 🌟 Inspired by a YouTube tutorial, the project utilizes a combination of PowerPoint and Excel to create a visually appealing and interactive dashboard. 🖥️✨
Add a description, image, and links to the advanced-excel topic page so that developers can more easily learn about it.
To associate your repository with the advanced-excel topic, visit your repo's landing page and select "manage topics."