Skip to content

Krishnapal-rajput/MS-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

28 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📊 MS Excel – Business & Financial Analysis Projects

Welcome to my MS Excel repository, where I document and showcase my hands-on work using Microsoft Excel for business analysis, financial analysis, data handling, and decision-making.

This repository serves as a structured collection of daily Excel practice files, academic projects, analytical models, and real-world business problem simulations, developed alongside my MBA journey and professional experience.


🎯 Purpose of This Repository

The primary objective of this repository is to:

  • Strengthen analytical thinking and data interpretation skills
  • Apply Excel to business, finance, and managerial decision-making
  • Build a practical reference for MBA coursework, interviews, and analyst roles
  • Demonstrate consistent learning and real-world application of Excel tools

📁 Contents You Will Find Here

This repository includes (but is not limited to):

  • ✔️ Daily Excel practice sheets
  • ✔️ Business data analysis exercises
  • ✔️ Financial calculations and statements
  • ✔️ Pivot tables and pivot charts
  • ✔️ Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • ✔️ Logical and statistical functions
  • ✔️ Data validation and conditional formatting
  • ✔️ What-if analysis (Goal Seek, Scenarios, Data Tables)
  • ✔️ Dashboards and summary reports
  • ✔️ Case-based Excel problems aligned with MBA subjects

Each file is created with a business-use mindset, focusing on clarity, accuracy, and usability.


🧠 Skills & Concepts Covered

  • Data Cleaning & Organization
  • Business Analysis using Excel
  • Financial Analysis Basics
  • Descriptive Statistics
  • Reporting & Visualization
  • Decision Support using Excel Tools
  • Problem Solving with Spreadsheets

🛠 Tools Used

  • Microsoft Excel
  • MS Office Suite
  • Business & Financial datasets (academic and practice-based)

👨‍🎓 About Me

I am an MBA candidate with a background in technology and business operations, actively developing skills in:

  • Business Analysis
  • Financial Literacy
  • Data-driven Decision Making

This repository reflects my learning process and practical exposure to Excel as a core analytical tool for managers and analysts.

🔗 GitHub: https://github.com/Krishnapal-rajput
🔗 LinkedIn: https://linkedin.com/in/krishnapal-rajput
🔗 Portfolio: https://krishnapal-rajput.netlify.app


📌 Note

This repository is continuously updated as I explore new Excel concepts and solve more complex business problems.
Feedback and suggestions are always welcome.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published