Search results
Advise your client, WorldWide Brewing Co., on a suitable M&A target to expand their operations in Asia as a junior Investment Banker with J.P. Morgan | Build real world skills with Forage.
- J.P. Morgan Software Engineering
A risk-free way to experience work on the job with us at...
- JPMorgan Chase & Co. Excel Skills
A risk-free way to build your technical skills with us at...
- J.P. Morgan Software Engineering
A risk-free way to experience work on the job with us at J.P. Morgan. Practice your skills with example tasks and build your confidence to ace your applications. Self-paced 5-6 hours
A risk-free way to build your technical skills with us at JPMorgan Chase & Co. Complete example tasks and build your confidence to ace your applications. The JPMorgan Chase & Co. Excel Skills program is an opportunity for you to develop your skills in Microsoft Excel.
- Overview
- Introduction
- Task 1: Excel Keyboard Shortcuts
- Task 2: Conditional Formatting
- Task 3: Visual Basic for Applications (VBA) Macros
- Task 4: Data Visualization in Excel
- Task 5: Data-Driven Storytelling
The JPMorgan Chase & Co. Excel Skills Virtual Internship, hosted by Forage, is an immersive program designed to equip aspiring finance professionals with essential Excel skills. The Excel Skills Virtual Internship empowers participants to stand out in the competitive finance landscape, setting them on a path to success.
J.P. Morgan is a global leader in financial services, that offers services to the world’s most important corporations. The Data Analytics team is looking to analyze the account performance metrics and sales trend for the 5years period between 2017-2021.
Practiced common keyboard shortcuts to make working in Excel more efficient.
Demonstrated key conditional formatting techniques in Microsoft Excel. Explored the data, for
•Missing values
•Repeated / duplicate values
•Errors in the data or in calculations that drive values in the data
•Trends and patterns
•Values that are negative or positive
Familiarized with VBA, Excel’s built-in programming language. Created the following two macros using the data modified with conditional formatting
1.A macro to sort the entire spreadsheet by 5 YR CAGR in descending order to see which accounts have the highest overall 5-year sales growth
Built a data visualization dashboard using charts in Excel. Created a dashboard using the account sales dataset worked with in prior tasks. Some of the focused business contexts when presenting findings were:
•Unit sales by year?
•Top 5 accounts by unit sales or CAGR?
•Effectiveness of different marketing programs by the number of sales driven?
Communicated analysis and insights using PowerPoint to tell a data-driven story. PowerPoint presentation to communicate key insights and data from the analysis and visualization work in the prior task. Creating a data-driven narrative allows you to directly link the issue you want to address, the insights useful to address the issue, and the action...
Get a taste of life as an investment banker at J.P. Morgan through our Investment Banking Virtual Experience Program on Forage. This program will give you insights into the different creative financial solutions that we provide to our clients and what it takes to be an investment banking in J.P. Morgan.
This repository encompasses the submitted files for the diverse tasks completed during the J.P. Morgan Software Engineering Virtual Internship.
People also ask
What is the JPMorgan Chase & Co Excel skills virtual internship?
What is the JPMorgan Chase & Co virtual internship repository?
How can I become an investment banker at JP Morgan?
How do I get a job at JPMorgan Chase & Co?
Through our Software Engineer Internship, you could help develop innovative solutions that impact the day-to-day lives of customers, clients and businesses around the world. Spend your internship with one of the world's biggest technology driven companies.
