Build and apply Excel skills, including Visual Basic for Applications, in a realistic business context using account sales data
The JPMorgan Chase & Co. Excel Skills program is an opportunity for you to develop your skills in Microsoft Excel. In this program, you will be tasked with challenges that simulate the ones of employees at JPMorgan Chase & Co. Through each task, you will learn and develop valuable Excel skills. At the end of each task, you will be able to compare your work to an example provided by JPMorgan Chase & Co. employees to learn from them directly. Our goal is for you to feel equipped in your journey with us!
This program is self-paced. It takes approximately 5-6 hours to complete.
Skills Learned:
- Excel Keyboard Shortcuts
Practice common keyboard shortcuts to make working in Excel more efficient.- Microsoft Excel
- Excel Shortcuts
- Knowledge Check
- Conditional Formatting
Demonstrate key conditional formatting techniques in Microsoft Excel.- Microsoft Excel
- Conditional Formatting
- Data Exploration
- Visual Basic for Applications (VBA) Macros
Familiarize yourself with VBA, Excel’s built-in programming language.- Microsoft Excel
- VBA Macros
- Data Visualization in Excel
Build a data visualization dashboard using charts in Excel.- Microsoft Excel
- Data Visualization
- Dashboards
- Data-Driven Storytelling
Communicate your analysis and insights using PowerPoint to tell a data-driven story.- Written Communication
- Data-Driven Storytelling
- Finish Line
