Virtual experience program J.P.Morgan Chase & Co. Excel Skills
I participated in the J.P.Morgan Chase & Co. virtual experience program, where I honed my Excel skills for business analytics. Through hands-on tasks, I gained skills in data analysis, and visualisation, enabling me to make data-driven decisions that drive business growth. ​
The Program Structure
The program was divided into four tasks, each building upon the skills learned in the previous one. Here's a detailed look at each task and what I learned:
​
Task 1: Conditional Formatting
The journey began with exploring Excel's conditional formatting capabilities. This powerful feature allowed me to:
​
- Highlight trends and patterns in large datasets visually
- Identify outliers and anomalies quickly
- Create heat maps to show data intensity across different categories
By applying various conditional formatting rules, I transformed raw numbers into a visually intuitive format, making it easier to spot key insights at a glance.
Task 2: Automating Processes with VBA Macros
Next, I worked on Visual Basic for Applications (VBA) macros. This task taught me how to:
- Record simple macros to automate repetitive tasks
- Edit and customise recorded macros for specific needs
- Create user-friendly buttons to run macros with a single click
Task 3: Creating Dynamic Dashboards
The third task focused on data visualisation and dashboard creation. This involved:
- Using PowerQuery to clean and transform raw data
- Creating pivot tables to summarise large datasets
- Designing interactive charts and graphs
- Building a cohesive dashboard that updates automatically with new data
This task was particularly enlightening as it showed me how to turn complex data into clear, actionable insights through visual representation.
​
Task 4: Data-Driven Storytelling
The final task brought everything together in a PowerPoint presentation. Here, I learned to:
- Distil key insights from the dashboard
- Create a compelling narrative around the data
- Design visually appealing slides that effectively communicate complex information
- Tailor the presentation to a business audience
This task emphasised the importance of not just analysing data, but also communicating findings in a way that drives decision-making.
Conclusion
Through this program, I gained:
1. Technical Skills: Advanced Excel functions, VBA programming, and dashboard creation.
2. Analytical Thinking: The ability to identify trends and draw meaningful conclusions from complex datasets.
3. Business Acumen: Understanding how data analysis translates into business strategy in the financial sector.
4. Communication Skills: The art of presenting data-driven insights to non-technical audiences.
​
As I reflect on this experience, I'm excited about the possibilities these new skills open up!
​​​​​​​​​​​​​
