Create OpenAI chat completions from Excel formulas

This repository showcases my capstone projects, featuring four distinct initiatives that demonstrate my analytical and problem-solving skills. Each project reflects a comprehensive approach to research and execution, addressing unique challenges across various domains. I plan to expand this collection with additional projects in the coming days.

VBA functions to allow storage, retrieval and changing of an encrypted password within excel. Used in conjuction with excel's protect feature to design protected features or priviliges.

This file contains advanced excel formulas and functions like Vlookup with match function, index and match function, offset & counta, logical operators, max if function, formula formatting, text functions, Date and time functions, data cleaning, etc. which I have worked on to take my excel skills at the high level.

Get NPV same as that of excel NPV calculations.

A Framework for Excel based reports to allow rapid & simple automation

This repository serves as a showcase of the skills I've acquired through Datacamp's "Data Analysis in Excel" course.

Common utility functions to extend VBA language and to speed up developement.

The aim of this project is to analyse healthcare data to extract actionable insights using Microsoft Excel that could help improve patient care and healthcare resource management.

Sales analysis of the vrinda store for the better understanding of business and requirements.

Assignment completed 2:30 10/19/20

Used advanced Excel functions, created a pivot table and designed an interactive dashboard with custom formatting. Generated insights that Target women customer of age group (30-49) years living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, flipkart and Myntra.

This analytics Excel dashboard provides a comprehensive overview of Liverpool's forward players' performance across all competitions in the 2024/2025 season. Key metrics include total goals, assists, big chances created/missed, shooting accuracy, dribbling efficiency, and player availability due to injuries.

Функции Excel.

VBA functions for regular use

Excel

This captures an in-depth analysis of the Cost of National Health Insurance Scheme (NHIS) services covered by ALMADINA CLINIC & PHARMACY

The Interactive Budget Analyzer is a powerful Excel-based tool designed to streamline the personal finance management. It features dynamic tracking of income and expenses, real-time updates, and intuitive visualizations. With detailed dashboards and customizable charts, this tool provides a comprehensive overview of your financial health.

⚡ Excel Plugin for Google Gemini 🤖 — Now with Ultra-Fast Parallel Processing 🚀 Custom AI functions right in your spreadsheet. Smarter, faster, better.

We all know the magic of Excel, hence, using this tool the most. Here are another few assignments with another important formulas of Excel called VOOKUP, IF, IFERROR, AND, OR, IFS and IFNA.