Create OpenAI chat completions from Excel formulas

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.

This repository contains all the necessary files and documentation for a detailed analysis of bank loan data using a combination of SQL, Power BI, Excel, and Tableau. The project aims to uncover insights related to loan applications, funding, repayments, and borrower demographics, facilitating data-driven decision-making in the banking sector.

Assignment completed 2:30 10/19/20

VBA functions for regular use

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

Функции Excel.

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.

A set of Python functions completely written in VBA macros that can be added as an excel add-ins, or run via a macro enabled workbook.

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

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

Data Analysis of Mandalle Restaurant with respect to different factors.

Reference Repo - Coding Skills Practice

Uncover insights from Zomato's restaurant data using Excel, SQL, Power BI, and Tableau. Analyze location trends, opening patterns, ratings distribution, and price ranges for a comprehensive understanding of the dining landscape. Dive into this repository and unlock the flavors waiting to be explored. Your culinary adventure starts here!

To calculate the pressure losses, cuttings transport ratio (hole cleaning performance) and graphically show sensitivity analysis by considering multiple factors. involved in wellbore cleaning..