This repository contains my work completed as part of the JPMorgan Chase & Co. Excel Skills course. The course covered a range of Excel functionalities that are essential for data analysis and business intelligence. Below is a summary of the tasks I completed:
In this task, I mastered various keyboard shortcuts to enhance efficiency in Excel. These shortcuts are crucial for speeding up the workflow and improving productivity while working with large datasets.
I applied conditional formatting to highlight data trends, identify outliers, and visually interpret data more effectively. This task involved creating custom rules and using formulas to dynamically format cells based on their values.
I developed and executed VBA Macros to automate repetitive tasks in Excel. This task involved writing VBA code to create macros that can streamline workflows and reduce manual effort.
I created various charts and graphs to visually represent data, making it easier to identify patterns and insights. This task focused on using Excel's built-in visualization tools to create meaningful and interactive data presentations.
In the final task, I combined all the skills learned to tell a compelling data-driven story. This involved synthesizing data insights and presenting them in a clear, concise, and impactful manner, using both visualizations and narrative techniques.
The completion certificate is included in this repository as a PDF file. It serves as validation of the skills and knowledge acquired during the course.
- Clone or download the repository.
- Open the respective files to explore the completed tasks.
- Refer to the README file for a summary of each task.
This repository showcases the Excel skills I developed through the JPMorgan Chase & Co. course. The tasks completed here demonstrate my ability to work efficiently in Excel, automate tasks using VBA, and create data-driven stories through visualization.