Excel Projects

🕰️Analog Clock in Excel :-

A fully functional real-time clock designed in Excel using 2D shapes and dynamic VBA logic. Each hand—hour, minute, and second—rotates precisely with time, creating a smooth analog experience right inside a spreadsheet. No external plugins, just pure Excel creativity and formula-driven animation.

Built with:

• VBA timers and angle calculations

• Shape rotation for smooth movement

• Manual refresh toggle for custom testing

🧠Excel Quiz System :-

A fully interactive, automated quiz platform built entirely in Excel using VBA and UserForms. This system simulates the entire exam experience—right from student login to real-time scoring—within a single workbook, showcasing the true power of logic-driven design inside a spreadsheet.

Key Features:

• Login Panel – Collects student details like Name, Reg. No., Subject, and Mobile Number before starting the test

• Multiple-Choice Questions – Displays timed, randomized questions with selectable options

• Countdown Timer – Tracks total exam duration and auto-submits once time is up

•  Real-Time Evaluation – Grades are calculated instantly upon submission

• Results Panel – Shows total marks, evaluation remarks, and performance scale

• Human Verification Badge – Adds a touch of realism and tech credibility

Built With:

• VBA scripting for control flow, scoring, and form management

• UserForms for a clean, guided interface

• Modular question logic with dynamic option

🔢Calculator in Excel :-

A fully interactive calculator built using Excel UserForms and custom VBA scripting. Designed for precision and usability, this tool handles real-time input through clickable buttons, dynamic display, and logic-based operators—all without touching the keyboard.

Key Features:

• Virtual Keypad Interface – On-screen numeric and operator buttons

• Backspace & Clear Functions – Custom logic for real-time correction

• Decimal Control – Supports floating-point calculations with precise input handling

• Smart Display – Clean, user-friendly screen that updates with each button press

Built Using:

• Excel VBA and UserForm controls

• CommandButton logic mapping to functions

• Custom display formatting and error handling

🔍 Excel Search Box System :-

A smart and responsive search utility built inside Excel using VBA. This system allows users to instantly filter a structured list of names, countries, and cities by typing into a custom search bar—no formulas or filters required

Key Features:

• Live Search Capability – Instantly filters rows based on typed input

• User-Friendly Interface – Sleek input box with a magnifying glass icon

• Structured Table – Displays names, countries, and cities clearly

• Scalable Design – Easily extendable to support more records

Built With:

• VBA code triggered by the Change event of a TextBox

• Looping logic to compare input against each row

• Hidden row toggling for real-time filtering effect

📅 Excel Calendar System :–

A visually organized, fully interactive calendar built entirely in Excel using VBA and shape formatting. This system allows users to navigate through months, view dates in a grid format, and integrates clean weekday headers with a modern, minimal design.

Key Features:

• Month Navigation – Buttons to move between months with real-time updates

• Styled Calendar Grid – Clean formatting with aligned day labels and colored weekends

• Auto Refresh – Changes are triggered dynamically on month toggle or startup

• Utility-Ready Layout – Can be adapted for scheduling, event logs, or attendance trackers

Built Using:

• VBA scripting for date population and month logic

• Shape objects and cell formatting for layout aesthetics

• Conditional logic for highlighting weekends or special dates

This isn’t just a static display—it’s a calendar that responds and updates with logic, crafted entirely inside the Excel environment. A great example of how form and function come together through clever scripting.

❌⭕ Tic Tac Toe in Excel :-

A fully interactive version of the classic Tic Tac Toe game, built entirely in Excel using VBA and shape-based interface design. This project blends intuitive gameplay with smart logic handling, all within the familiar grid of a spreadsheet.

Gameplay Features:

• Two-Player Mode – Players take alternate turns as X and O

• Clickable Cells – Each square responds to clicks, updating the board dynamically

• Win/Draw Detection – Auto-checks for victory lines (rows, columns, diagonals)

• Visual Feedback – Highlights winning combinations and displays match result

• Game Reset Button – Instantly clears the board for a new match

Built With:

• VBA event handlers to track moves and enforce game rules

• Conditional logic to evaluate game state and prevent illegal moves

• 3×3 grid design using cell borders or 2D shapes for a polished UI

This game proves that Excel can be more than numbers—it’s a platform for playful creativity and real-time interactivity.

Note :

How to Download this :-

1. Click the Download Button
   Your browser will begin downloading the .xlsm file directly. Open the File in Microsoft Excel
   Do not open it in Google Sheets—macros won’t work there.

2. Enable Editing & Macros 

   • If a yellow bar appears, click “Enable Editing”

   • Then click “Enable Content” to allow macros

💡 Tip: If Excel still blocks the macros, right-click the file → Properties → check "Unblock", then reopen it.

  "Macro-powered. Code-fueled. Innovation delivered."