excel-functions

There are 40 repositories under excel-functions topic.

  • robatwilliams/openai-excel-functions

    Create OpenAI chat completions from Excel formulas

    Language:JavaScript42395

  • virajbhutada/capstones

    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.

    19105

  • Salmankadiwal/Advanced-Excel-Formulas-and-Functions

    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.

    7100

  • cchheang/Excel-VBA-Password-Manager-and-Changer

    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.

    Language:Visual Basic5106

  • JPKW/Excel-Report-Automation-Framework

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

    Language:Visual Basic4101

  • govardhan-srinivas/excel-npv

    Get NPV same as that of excel NPV calculations.

    Language:JavaScript3000

  • Mabrar92/Data-Analysis-in-Excel

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

    3100

  • opi1101/VBA-extensions

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

    Language:VBA2100

  • gusenov/excel-functions

    Функции Excel.

    Language:Shell100

  • ibrahim030398/Vrinda_Store_sales_analysis

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

    1100

  • IsraelVow/Health-Insurance-Cost-Analysis-Dashboard

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

    1200

  • JPKW/VBA

    VBA functions for regular use

    1101

  • Komal-Deoghare/ecommerce_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.

    1100

  • randyaajr/JavaScript-Assignment

    Assignment completed 2:30 10/19/20

    Language:HTML110

  • Ujjwal-Jaiswal-UJ/Interactive-Budget-Analyzer

    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.

    1100

  • UjjwalGupta245/Vrinda-Store-EDA

    Excel Dashboard

    1

  • vignesh4005/Healthcare_Data_Analysis

    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.

    1100

  • atwyburde/Delivery-Time-Analysis

    Prediction model for Delivery Time by Simple Linear Regression

    Language:Jupyter Notebook0100

  • Bhushan148/Forecasting-in-Excel

    This project leverages Excel 📊 to forecast YouTube views 📈 for the next 7 days using three methods: FORECAST Function 📉 Graph Trendlines 📈 Forecast Sheet Tool 📅 By comparing these methods, the project aims to identify the most accurate forecasting technique 🎯 and enhance predictive accuracy 🔍 for future view counts.

    0100

  • Hannah-Aji/Bank-Loan-Segmentation-using-SQL-Excel-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.

    0100

  • Krishna1594/Pressure-Losses-Across-BHA-and-Wellbore-Cleaning-Efficiency

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

    0100

  • MDrica1/Excel-spreadsheets

    0100

  • sharkutilities/py2excel

    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.

    Language:Visual Basic .NET0110

  • shaziasheikh-2025/Coffee-Sales-Dashboard

    I developed a comprehensive project in Excel, creating multiple pivot charts, slicers and tables to analyze the data. This process involved several stages including data processing, data cleaning, data visualization.

    0100

  • atwyburde/Excel-1

    Excel is an important tool in the field of Data Science. It provides us with so many formulas and makes our time consuming and complicated calculations easy. So, here are some questions based on formulas like Sum, Sumif, Sumifs, Count, Countif, Countifs.

    10

  • atwyburde/Excel-2

    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.

    10

  • atwyburde/Excel-3

    Excel has now become an important part of our professional as well as personal life because it can use easily and it provides many functions in one single tool. Here is another assignment based on very important, very interesting and very attractive feature i.e. Pivot Table and Pivot Charts.

    10

  • atwyburde/Mandalle-Restaurant-Analysis

    Data Analysis of Mandalle Restaurant with respect to different factors.

    10

  • atwyburde/Salary-Hike-Analysis

    Prediction model for Salary Hike by Simple Linear Regression

    Language:Jupyter Notebook10

  • atwyburde/Travel-Data-Analysis

    Data Analysis of 200 trips of Travel Times Pvt. Ltd.

    10

  • AyushAI/Pizza-Plaza-

    This repository contains an in-depth analysis of sales data from Pizza Plaza, a fictitious fast-casual pizza chain. Using Excel, the project explores key business metrics such as total orders, revenue trends, average discounts, and product performance. The analysis is complemented by an interactive dashboard to visualize insights & decision making.

  • AyushAI/Suplex-Store-Excel-Analysis

    This repository features a detailed sales analysis of Suplex Store, a fictional retail chain. Using Excel, the project examines daily sales trends, average sales values, price bucket comparisons, and product-level insights. An interactive dashboard enhances the analysis by providing clear visualizations to support strategic decisions.

    10

  • edingfield391/Microsoft-Excel-Spreadsheet-Software

    Microsoft Excel is a powerful spreadsheet software used for data analysis, financial modeling, and organizing information. 📊💻

    10

  • lynnewu/vba-utility

    VBA code modules for Microsoft Office desktop applications for doing things like fixing ISO-8601 dates, time conversions, IPv4 address functions

    Language:VBA10

  • mulhalahelm72/Microsoft-Excel-Spreadsheet-Software

    Microsoft Excel is a powerful spreadsheet software used for data analysis, financial modeling, and organizing information. 📊💻

    10

  • robert-z-lehr/Example-Excel-Functions

    Reference Repo - Coding Skills Practice

    10