This repository contains the various tasks assigned by JPMorgan Chase & Co. Virtual Internship on Microsoft Excel

Dynamic Pricing Tool and Travel Cost Analyzer Calculator by using data analysis and advance excel.

Excel data analysis of Crowdfunding platforms

Working for excel using advanced function

Advanced_Excel

This is an Excel Project wherein we have applied formulas such as summits, maxims, minis, averageifs, countifs on a large data set. Have also created an interactive dashboard using pivot tables and various data visualisation tools. Presented data validation and conditional formatting. Have also presented VLookup, HLookup, IF and IFERROR Functions.

Kickstarter Analysis - Project Trend Analysis

Employee Performance Analysis using MS Excel

These files contain different uses of excel Formule and functions like statistical, logical, conditional, absolute reference, relative reference, Vlookup, Hlookup, Index_Match ETC.

Sprocket Central Pty Ltd, a medium size bikes & cycling accessories company, is looking to boost business by analysing their provided customer dataset to recommend which of these 1000 new customers should be targeted to drive the higher value for the company