Subu Data Labs

Home About Contact Privacy Terms Disclaimer

Free Excel Course Part 3 — 57 Formulas | VLOOKUP, INDEX MATCH, SUMIFS, NPV, PMT, Logical & Text Functions

Subham G August 11, 2026

Subu Data Labs | Free Excel Templates, Dashboards & VBA Tools

Free Excel templates, VBA tools, Power BI dashboards, and a complete Excel training course by Subham Ghadge. Download ready-to-use workbooks for office management, billing, payroll, and inventory tracking.

Home
About Us
Contact Us

Footer Menu Widget

Home
About
Privacy Policy
Terms & Conditions
Disclaimer

Social Plugin

Search This Blog

Featured Post

Pivot Tables

Free Excel Course Part 5 — Pivot Tables | Slicers, Multi-Sheet Data, & Filter Pages

Subham GAugust 26, 2026

📺 YouTube Channel

Subscribe to SubuDataLabs

Stay updated with data tutorials, tips, and open-source projects!

▶️ Subscribe on YouTube

Free Excel Course Part 5 — Pivot Tables | Slicers, Multi-Sheet Data, & Filter Pages

Free Excel Course Part 5 — Pivot Tables | Slicers, Multi-Sheet Data, & Filter Pages By Subham Ghadge | Subu Data Labs | Excel Training & Free Workbooks | July 2026 Part 5 of 6 4 Topics Intermediate Level Data Analysis Free Download Microsoft Excel Table of Contents 01 - What is a Pivot Table 02 - Slicers in Pivot Tables 03 - Combining Data from Multiple Sheets 04 - Create Report Filter Pages Welcome to Part 5 of our complete Excel training series! Having covered formatting in Part 1, functions in Part 2, advanced formulas in Part 3, and data visualization in Part 4, this module covers the primary data summarizing tool in Excel: Pivot Tables . Pivot tables allow you to summarize, group, and analyze large datasets containing thousands of transaction rows in seconds—without writing complex conditional array formulas. In this guide, we walk through building structured...

Tea & Coffee Supply Manager — Free Excel to Web App Conversion | Browser-Based Tracker with Login, Dashboard & CSV Export

Tea & Coffee Supply Manager — Excel to Web App Conversion By Subham Ghadge | Subu Data Labs | Office Automation & Web Tools | July 2026 Version 4.0 Excel + Web App No Server Needed 100% Free localStorage Role-Based Login In almost every corporate office, pantry supplies like tea and coffee machines require continuous monthly tracking. Administrative staff need to monitor milk carton usage, coffee bean orders, stirrer counts, and tea bag consumption, then cross-charge these costs accurately to participating companies or internal departments. Traditionally, this tracking happens inside a shared Excel spreadsheet. While Excel works initially, managing multiple users, concurrent access, user permissions, and month-end vendor reports over email becomes slow and prone to formatting errors. To solve this, I converted our master Excel tracking workbook into a standalone, browser-based web application. It...

Personal Finance Tracker | Excel Budget Planner & Expense Management System

📅 Published by Subham Ghadge | Category: Financial Analytics, Excel Templates, Personal Finance | Free Download Excel Arrays Budget Planner Data Privacy Personal Finance & Budget Analytics Tracker in Excel Checking your bank statement at the end of the month tells you where your money went, but it doesn't help you plan where your money should go. Relying only on delayed bank SMS alerts makes it easy to overspend and fall into credit card debt or zero savings. While mobile budget apps promise to track your expenses automatically, many demand full read access to your SMS messages, upload your financial data to cloud servers, or lock basic features behind monthly subscriptions. To keep my financial data completely private and offline, I built the SUBU Personal Finance Tracker in Excel. It tracks multi-bank account balances, monitors daily expenses against budget targets using SUMIFS formulas, and calculates your true monthly...

Property Rental Management Excel Template: Income & Tenant Tracker

📅 Published by Subham Ghadge | Category: Real Estate, Financial Modeling, Property Management | Free Download Excel Dashboard Rent Tracker Asset Management Real Estate Rent & Property Income Tracker in Excel Managing a multi-unit property portfolio—whether residential apartments or commercial spaces—requires keeping careful track of cash flow. When landlords and property managers rely on fragmented WhatsApp messages, paper notebooks, or scattered bank statements, tracking rent payments quickly becomes confusing. Keeping track of partial rent payments across multiple tenants while calculating electricity sub-meter readings manually often leads to missed dues and billing arguments. Without a clear tracking system, property owners lose sight of their true net rental income and struggle to compile clean records for annual tax filings. To solve this, I designed the Panchwa Rent Income Analysis System in Excel. It consolidates l...

Conference Room Booking System Excel Free Template

📅 Published by Subham Ghadge | Category: Facility Management, Office Administration, Excel Analytics | Free Download Excel VBA Resource Allocation Data Architecture Conference Room Booking & Calendar System in Excel (VBA) Managing meeting rooms and conference spaces in a busy corporate office can get chaotic fast. When different teams rely on verbal promises, whiteboards, or unorganized chat threads, double-booking is almost inevitable. Two departments end up showing up for the main boardroom at the exact same time right when an important client presentation is about to start. Buying expensive corporate room-scheduling software isn't always necessary for managing office meeting spaces. What facility managers need is a simple, central system that locks room choices, prevents scheduling overlaps, and gives everyone clear visibility. To solve this, I designed the Conference Room Booking System in Excel. It uses data validatio...

Free Sales Performance Dashboard Power BI Template India

📅 Published by Subham Ghadge | Category: Business Intelligence, Data Analytics, Corporate Strategy | Power BI DAX Sales Analytics Data Architecture Sales Performance Power BI Dashboard & DAX Analytics As a business grows, tracking regional sales performance across thousands of transactions using traditional Excel spreadsheets can quickly become slow and frustrating. When spreadsheets get bloated with thousands of rows and complex `VLOOKUP` or `SUMIFS` formulas, files freeze, calculation lags occur, and getting clear answers takes too long. While Excel is great for quick tracking, enterprise-level sales reporting requires a proper relational data model that can compress large datasets and update interactive reports instantly. To solve this, I designed the Corporate Sales Performance Power BI Dashboard . It replaces heavy flat spreadsheets with a clean Star Schema data model, uses Power Query (M Language) for automated data c...

Free Excel Course Part 3 — 57 Formulas | VLOOKUP, INDEX MATCH, SUMIFS, NPV, PMT, Logical & Text Functions

Free Excel Course Part 3 — 60 Formulas Explained By Subham Ghadge | July 2026 Part 3 of 3 60 Formulas Advanced Reference Free Download Microsoft Excel Welcome to Part 3 of our complete Excel training series. Having covered shortcuts and formatting standards in Part 1, and intermediate functions in Part 2, this module provides an exhaustive reference guide to 60 essential Excel formulas used across financial modeling, accounting audit, data cleaning, and statistical reporting. Table of Contents 01 - UPPER, LOWER, PROPER 02 - TRANSPOSE 03 - SUMIF 04 - COUNTIF 05 - AVERAGEIF 06 - SUMIFS 07 - COUNTIFS 08 - AVERAGEIFS 09 - SUMPRODUCT 10 - INDEX 11 - MATCH 12 - SUMIF(INDEX(MATCH)) 13 - INDEX(MATCH) and DGET 14 - TEXTJOIN 15 - MIN, MAX, MEDIAN 16 - MINIFS, MAXIFS 17 - IF 18 - IF(AND) 19 - IF(OR) 20 - ABS 21 - ROUND, ROUNDUP, ROUNDDOWN 22...

Free Excel Course Part 2 — Functions | Goal Seek, Data Validation, Scenario Manager, INDIRECT & More

Free Excel Course Part 2 — Functions | Goal Seek, Data Validation, Scenario Manager, INDIRECT & More By Subham Ghadge | Subu Data Labs | Excel Training & Free Workbooks | July 2026 Part 2 of 3 7 Topics Intermediate Level What-If Analysis Free Download Microsoft Excel Table of Contents 01 - Goal Seek 02 - Data Validation 03 - Scenario Manager 04 - Name Manager 05 - Advanced Filter 06 - Dependable Drop Down Lists 07 - INDIRECT Formula Building upon Part 1—which focused on navigation shortcuts, formatting standards, and date math—this second module introduces intermediate Excel functions used extensively in corporate analysis, financial planning, and operational modeling. Functions like Goal Seek, Scenario Manager, and INDIRECT allow you to automate what-if analysis, build dynamic summary dashboards, and enforce strict data entry validation rules. This guide...

Free Excel Course Part 1 — Navigation & Formatting | 14 Topics, 40+ Shortcuts & Formulas Explained

Free Excel Course Part 1 — Navigation & Formatting | 14 Topics, 40+ Shortcuts & Formulas Explained By Subham Ghadge | Subu Data Labs | Excel Training & Free Workbooks | July 2026 Part 1 of 3 14 Topics 40+ Shortcuts Beginner to Intermediate Free Download Microsoft Excel Table of Contents 01 - Navigation Shortcuts 02 - Formatting Tips 03 - Dates & Date Formulas 04 - Workday Formula 05 - Common Errors 06 - Copy vs. Cut 07 - Precedents & Dependents 08 - Group & Ungroup 09 - Protect Ranges 10 - Screenshot Function 11 - Sorting 12 - Remove Duplicate Values 13 - Text to Columns 14 - Conditional Formatting If you use Excel every day at work—whether in finance, accounting, HR, office administration, or data management—and find yourself repeating tasks manually or searching for shortcuts, this guide is designed for you. ...

Vehicle Customer Tracker Excel System | CRM, Sales & Order Management

📅 Published by Subham Ghadge | Category: Automotive Operations, Showroom Workflow, Excel Templates | Free Download Excel System Dealership Tools Data Validation Vehicle Customer Tracker & EV Dealership System in Excel In an automotive dealership or vehicle showroom, customer booking details often get scattered across multiple places—the main corporate CRM logs the initial booking, sales consultants write accessory choices in personal notebooks, and promised delivery dates are discussed over messaging threads. When the stockyard team prepares a vehicle chassis for final customer delivery under tight deadlines, piecing together this scattered information often leads to mistakes—like a missed accessory installation or an incorrect EV charger dispatched with the vehicle. To solve this operational friction, I created the Vehicle Customer Tracker System in Excel. It connects customer bookings, vehicle variants, accessory add-ons...

Your trusted source for corporate Excel automation tools, interactive dashboards, payroll management systems, and web applications built from real business workflows by Subham Ghadge.

Quick Links

Home
About Us
Contact Us

Legal

Privacy Policy
Terms & Conditions
Disclaimer

Connect

YouTube

Contact form

Name

Email *

Message *