Data analytics · Course by Ravindra Bagale
Excel Course
Excel from basics to job-ready: formulas, PivotTables, dashboards, Power Query, VBA, Copilot and Python.
A free online Excel course for beginners, from basics and formulas to PivotTables, dashboards and VBA. The lessons are in simple English with Marathi phrases, and Ravindra Bagale's online and offline Excel classes are taught in Marathi and Hindi.
Start with “How to Read This Book” → Continue → Read in Marathi · मराठीत वाचा Become certified, sign up
Trainer: Ravindra Bagale
Learning roadmap
Follow the steps top to bottom. Each step builds on the one above.
-
1
Basics & data entry
Interface, references, AutoFill, validation, conditional formatting
Ch 1–2 -
2
Formulas & lookups
SUMIFS to XLOOKUP, cleaning, Tables
Ch 3–6 -
3
Pivots, charts & arrays
PivotTables, charts, dynamic arrays, Power Query
Ch 7–10 -
4
Automation & dashboards
What-if, VBA, dashboards, final project, practice
Ch 11–16 -
5
Interview & advanced
Interview Q&A, KPIs, Power Pivot, Copilot, Python, stats, forecasting
Ch 17–32
Course chapters
The main handbook — 31 chapters in the course count, 341 concepts listed below. Open a chapter, or expand its concept list.
Part 1 · Foundations & analysis
Show 9 concepts
Show 17 concepts
- 3.1 Formula Basics and Operators
- 3.2 SUM, SUMIF and SUMIFS
- 3.3 COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS
- 3.4 AVERAGE, AVERAGEIF(S), MINIFS and MAXIFS
- 3.5 ROUND Family and RANK
- 3.6 Text Functions: LEFT, RIGHT, MID, LEN, FIND and SEARCH
- 3.7 SUBSTITUTE, REPLACE, TRIM, CLEAN and Case Functions
- 3.8 Joining Text: &, CONCAT, TEXTJOIN and TEXT
- 3.9 TEXTBEFORE, TEXTAFTER and TEXTSPLIT
- 3.10 Date Functions: TODAY, NOW, DATE, DAY/MONTH/YEAR, EOMONTH, EDATE
- 3.11 Working Days, DATEDIF and WEEKDAY
- 3.12 Time Calculations
- 3.13 IF, Nested IF and IFS
- 3.14 AND, OR, NOT and SWITCH
- 3.15 IFERROR and IFNA
- 3.16 SUMPRODUCT
- 3.17 Error Types and How to Fix Them
- Practice and Answer Key: SUMIFS, COUNTIFS and IF
Show 10 concepts
- 4.1 VLOOKUP with Exact Match
- 4.2 VLOOKUP Approximate Match and the Column-Index Trap
- 4.3 HLOOKUP
- 4.4 INDEX and MATCH
- 4.5 Two-way Lookup (Row and Column)
- 4.6 XLOOKUP Basics and if_not_found
- 4.7 XLOOKUP Match Modes, Search Modes and Multiple Returns
- 4.8 XMATCH
- 4.9 Approximate Lookup: Delivery Fee Slabs
- 4.10 Common Lookup Errors and Fixes
- Practice and Answer Key: XLOOKUP and Delivery Fee Slabs
Show 18 concepts
- 5.1 Duplicates
- 5.2 Blank Cells
- 5.3 Extra Spaces and Non-printable Characters
- 5.4 Inconsistent Case
- 5.5 Inconsistent City Spellings
- 5.6 Numbers Stored as Text
- 5.7 Text Dates and Mixed Date Formats
- 5.8 Splitting Columns
- 5.9 Merging Columns
- 5.10 Phone Numbers
- 5.11 E-mail Addresses
- 5.12 Pincodes and Codes with Leading Zeros
- 5.13 Extracting Parts of Text
- 5.14 Removing Unwanted Characters
- 5.15 Outliers
- 5.16 Error Values in Data
- 5.17 Unpivot: Wide to Long (Concept)
- 5.18 End-to-End: Cleaning a Messy Blinkit Export
- Practice and Answer Key: Cleaning a Messy Export
Show 13 concepts
- 6.1 Excel Tables (Ctrl + T)
- 6.2 Structured References
- 6.3 The Total Row
- 6.4 Sorting: Multi-level and Custom Sort
- 6.5 AutoFilter
- 6.6 Advanced Filter
- 6.7 SUBTOTAL and AGGREGATE
- 6.8 The Subtotal Feature
- 6.9 Group and Outline
- 6.10 Range vs Excel Table
- 6.11 Writing Formulas in a Normal Range vs in an Excel Table
- 6.12 Sorting and Filtering Inside an Excel Table
- 6.13 Slicers on an Excel Table (Not a Pivot)
- Practice and Answer Key: Ranges, Tables and Slicers
Show 11 concepts
- 7.1 Creating a PivotTable
- 7.2 Field Areas: Rows, Columns, Values and Filters
- 7.3 Summarize Values By
- 7.4 Show Values As
- 7.5 Grouping Dates and Numbers
- 7.6 Calculated Fields and Calculated Items
- 7.7 Sorting, Filtering and Top 10
- 7.8 Slicers and Timelines
- 7.9 Report Connections, Refresh and Data Source
- 7.10 GETPIVOTDATA
- 7.11 PivotCharts
- Practice and Answer Key: PivotTable by City and Platform
Show 16 concepts
- 8.1 Creating and Formatting a Chart
- 8.2 Column and Bar Charts
- 8.3 Line and Area Charts
- 8.4 Pie and Doughnut Charts
- 8.5 Combo Chart with a Secondary Axis
- 8.6 Scatter Chart
- 8.7 Histogram and Box & Whisker
- 8.8 Waterfall and Funnel
- 8.9 Treemap and Sunburst
- 8.10 Map Chart
- 8.11 Sparklines
- 8.12 Choosing the Right Chart
- 8.13 Dynamic Chart from a Table
- 8.14 Drop-down Driven Dynamic Chart (INDEX / XLOOKUP)
- 8.15 Named Ranges with OFFSET (Rolling Charts)
- 8.16 Checkbox to Show/Hide a Series
Show 20 concepts
- 9.1 Spill Ranges and the # Operator
- 9.2 FILTER
- 9.3 SORT and SORTBY
- 9.4 UNIQUE
- 9.5 SEQUENCE and RANDARRAY
- 9.6 LET
- 9.7 LAMBDA (Brief)
- 9.8 VSTACK and HSTACK
- 9.9 CHOOSECOLS, TAKE and DROP
- 9.10 GROUPBY: A Summary Table with One Formula
- 9.11 PIVOTBY, and PIVOTBY vs PivotTable
- 9.12 REGEXTEST, REGEXEXTRACT and REGEXREPLACE: Pattern Matching for Messy Text
- 9.13 TOCOL and TOROW: Turn a Grid into One List
- 9.14 WRAPROWS and WRAPCOLS: Turn One Long List into a Grid
- 9.15 EXPAND: Make an Array a Fixed Size
- 9.16 TRIMRANGE and the Trim Ref (Dot) Operator
- 9.17 IMAGE: Pictures Inside Cells
- 9.18 Named LAMBDA Functions in Name Manager, with Optional Arguments (ISOMITTED)
- 9.19 MAP, REDUCE, SCAN, BYROW, BYCOL and MAKEARRAY with Real Examples
- 9.20 Recursive LAMBDA and a Small Reusable Function Library
- Practice and Answer Key: New Dynamic Array and LAMBDA Functions
- Practice and Answer Key: FILTER, SORT and UNIQUE
Show 9 concepts
- 10.1 Opening Power Query: Data from a Workbook or CSV
- 10.2 Cleaning Steps in Power Query
- 10.3 Get Data from Folder: Combining Monthly Bank Statements
- 10.4 Append: Blinkit + Amazon Now
- 10.5 Merge Queries
- 10.6 Unpivot
- 10.7 Group By
- 10.8 Parameters
- 10.9 Refresh and Load Options
- Practice and Answer Key: Append, Unpivot and Group By
Show 21 concepts
- 12.1 Developer Tab, Macro Security and .xlsm
- 12.2 Recording a Macro: Absolute vs Relative
- 12.3 Running Macros: Button, Shortcut and the Macros Dialog
- 12.4 The VBA Editor (VBE)
- 12.5 Sub Procedures
- 12.6 Variables and Data Types
- 12.7 Range, Cells and Worksheets
- 12.8 MsgBox and InputBox
- 12.9 If and Select Case
- 12.10 Loops: For, For Each and Do
- 12.11 Finding the Last Row (and Column)
- 12.12 Practical Macros on Our Data
- 12.13 User-Defined Functions: a Delivery Fee Function
- 12.14 Error Handling with On Error
- 12.15 Debugging: F8, Breakpoints, Immediate and Locals Windows
- 12.16 The Personal Macro Workbook
- 12.17 Office Scripts: What They Are and Who Can Use Them
- 12.18 Recording an Office Script and Reading the Code
- 12.19 Writing a Small Office Script: Colour the Late Orders
- 12.20 Running a Script from Power Automate: On a Schedule or When a File Arrives
- 12.21 VBA vs Office Scripts: Which One When?
- Practice and Answer Key: An Office Script that Summarises Orders by Status
- Practice and Answer Key: A Macro that Tags Late Orders
Show 8 concepts
- 13.1 Planning: Audience, Questions and KPIs
- 13.2 Structuring the Workbook: Data, Calc, Dashboard
- 13.3 PivotTables that Feed the Dashboard
- 13.4 KPI Cards
- 13.5 Charts for the Dashboard
- 13.6 Slicers and a Timeline for All Pivots
- 13.7 Layout and Design Principles
- 13.8 Refresh, Finishing Touches and a Checklist
- How to use the Top 10 Companies Dashboard
- Practice and Answer Key: KPI Cards for a City Dashboard
Show 11 concepts
- 14.1 Locked Cells and Protect Sheet
- 14.2 Hiding Formulas and Allow Edit Ranges
- 14.3 Protect Workbook Structure vs Encrypt with Password
- 14.4 Print Area and Page Breaks
- 14.5 Page Setup: Orientation, Scaling and Margins
- 14.6 Headers and Footers
- 14.7 Print Titles (Repeat Header Rows)
- 14.8 Exporting to PDF
- 14.9 Sharing and Co-authoring
- 14.10 Comments vs Notes
- 14.11 Version History
Show 15 concepts
- 16.1 Modules 1–2: Basics and Data Entry
- 16.2 Module 3: Formulas and Functions
- 16.3 Module 4: Lookups
- 16.4 Module 5: Data Cleaning
- 16.5 Module 6: Tables, Sorting and Filtering
- 16.6 Module 7: PivotTables
- 16.7 Module 8: Charts
- 16.8 Module 9: Dynamic Arrays
- 16.9 Module 10: Power Query
- 16.10 Module 11: What-If Analysis
- 16.11 Module 12: Macros and VBA
- 16.12 Module 13: Dashboards
- 16.13 Module 14: Protection and Printing
- 16.14 Mixed Scenario Exercises
- 16.15 Challenge Exercises
Part 2 · Interview, projects & advanced
Show 11 concepts
- 21.1 Sales vs Target Tracker
- 21.2 Budget vs Actual Report
- 21.3 Inventory Reorder Sheet
- 21.4 HR Attendance and Payroll Sheet
- 21.5 GST Invoice Register
- 21.6 Bank Reconciliation
- 21.7 Marketing Campaign Performance
- 21.8 Customer Repeat and Cohort Table
- 21.9 One-Page Executive MIS
- 21.10 Multi-Outlet Roll-up
- 21.11 Salary Slip Creation
Show 20 concepts
- 22.1 How to Read a KPI
- 22.2 Retail and Quick Commerce
- 22.3 E-commerce
- 22.4 Sales
- 22.5 Finance and Accounting
- 22.6 Banking
- 22.7 Insurance
- 22.8 Healthcare
- 22.9 Pharma
- 22.10 Manufacturing
- 22.11 Inventory and Supply Chain
- 22.12 Logistics
- 22.13 HR
- 22.14 Marketing and Digital Ads
- 22.15 Education
- 22.16 Hospitality
- 22.17 Real Estate
- 22.18 Telecom
- 22.19 IT Services
- 22.20 Government and NGO
Show 8 concepts
- 23.1 Referencing Another Sheet
- 23.2 Referencing a Normal Range on Another Sheet
- 23.3 Referencing an Excel Table on Another Sheet
- 23.4 3D References: One Formula Across Many Sheets
- 23.5 INDIRECT for Sheet Names (and Its Pitfalls)
- 23.6 Links to Another Workbook (External References)
- 23.7 Workbook Links: Change Source, Break Links and Fix Broken Links
- 23.8 Consolidate: Combine Sheets with Different Layouts
- Practice and Answer Key: Quarter Report Across Sheets
Show 10 concepts
- 24.1 Turn On Power Pivot and Meet the Data Model
- 24.2 Load Tables into the Data Model
- 24.3 Diagram View and Relationships
- 24.4 Fact and Dimension Tables: the Star Schema
- 24.5 A Date Table (Calendar)
- 24.6 Relationships Across Multiple Files (Power Query from a Folder)
- 24.7 DAX Measures: SUM, COUNTROWS, DISTINCTCOUNT and CALCULATE
- 24.8 A Simple Time-Intelligence Measure
- 24.9 PivotTables from the Data Model, and CUBE Functions
- 24.10 When to Move to Power BI
- Practice and Answer Key: A Two-Month Data Model
Show 10 concepts
- 25.1 Navigation Shortcuts
- 25.2 Selection Shortcuts
- 25.3 Data Entry and Editing Shortcuts
- 25.4 Formatting Shortcuts
- 25.5 Formula Shortcuts
- 25.6 Tables, Filter and Data Shortcuts
- 25.7 Charts and PivotTable Shortcuts
- 25.8 Ribbon KeyTips: the Alt Keys (Windows)
- 25.9 Ctrl+Shift Combinations
- 25.10 Function Keys F1 to F12
- Practice and Answer Key: A Keyboard-Only Order Report
Show 8 concepts
Show 20 concepts
- 27.1 Retail and Quick Commerce: City Sales and On-Time Delivery
- 27.2 E-commerce: Gross Sales, Returns and Net Sales
- 27.3 Sales: Target vs Actual by Sales Rep
- 27.4 Finance and Accounting: Budget vs Actual Variance
- 27.5 Banking: Loan Book and NPA Tracker
- 27.6 Insurance: Premium, Claims and Loss Ratio
- 27.7 Healthcare: Hospital Revenue and Length of Stay
- 27.8 Pharma: Stock Value and Near-Expiry Batches
- 27.9 Manufacturing: Production Attainment and Rejects
- 27.10 Inventory and Supply Chain: Days of Cover and Reorder List
- 27.11 Logistics: On-Time Delivery by Route
- 27.12 HR: Headcount, Attrition and Salary
- 27.13 Marketing and Digital Ads: Campaign ROAS and Cost per Order
- 27.14 Education: Pass Rate, Scores and Attendance
- 27.15 Hospitality: Occupancy, ADR and RevPAR
- 27.16 Restaurants: Spend per Cover and Food Cost
- 27.17 Real Estate: Units Sold and Price per Square Foot
- 27.18 Telecom: Churn, ARPU and Data Usage
- 27.19 IT Services: Utilisation and Billing
- 27.20 Government and NGO: Fund Utilisation and Cost per Beneficiary
- Practice and Answer Key: Cloud Kitchen Weekly Report
Show 8 concepts
- 28.1 What Copilot in Excel Is and Who Can Use It
- 28.2 Get Your Data Ready: Copilot Works Best on a Clean Excel Table
- 28.3 Ask Copilot About Your Data (Chat Only Mode)
- 28.4 Edit with Copilot (Formerly Agent Mode) and Plan Mode
- 28.5 The COPILOT Function: Retired in September 2026, and What to Use Now
- 28.6 Prompt Patterns for Analysts
- 28.7 Verify AI Output: A Checklist and Recomputing with Formulas
- 28.8 Copilot Data Privacy, Limits and Licensing
- Practice and Answer Key: Check a Copilot Summary Before It Goes Out
Show 8 concepts
- 29.1 What Python in Excel Is: Availability and Licensing
- 29.2 Your First =PY Cell: Insert Python, Ctrl+Alt+Shift+P and Ctrl+Enter
- 29.3 xl() References and DataFrames: Reading a Whole Table into Python
- 29.4 Python Object or Excel Value: Choosing the Output Type
- 29.5 pandas groupby in Excel: Totals, Several Measures and a Pivot Table
- 29.6 Charts with Matplotlib and seaborn in Python in Excel
- 29.7 Calculation Order, Cloud Execution, Errors and Limits
- 29.8 Mini Project: A Weekly City Report with Python in Excel
- Practice and Answer Key: Analyse 8 Orders with Python in Excel
Show 9 concepts
- 30.1 Descriptive Statistics with Functions: Centre, Spread and Shape
- 30.2 The Analysis ToolPak: Load It and Read the Descriptive Statistics Output Line by Line
- 30.3 Distributions and Histograms: FREQUENCY, the Histogram Chart, NORM.DIST and Outliers
- 30.4 CORREL and a Correlation Matrix: Which Numbers Move Together
- 30.5 Simple Regression with SLOPE, INTERCEPT and LINEST: Predict Orders from Ad Spend
- 30.6 The ToolPak Regression Output Read Line by Line
- 30.7 T.TEST and an A/B Test Walkthrough: Did the New Checkout Page Raise Basket Value?
- 30.8 CHISQ.TEST in Brief: Comparing Conversion Rates and Counts
- 30.9 Common Statistics Mistakes Analysts Make (and the Fix for Each)
- Practice and Answer Key: Describe, Correlate, Predict and Test a Kolhapur Store
Show 7 concepts
- 31.1 Forecasting Basics: Trend, Seasonality and a Clean Time Series
- 31.2 FORECAST.LINEAR and TREND: Straight-Line Forecasts
- 31.3 FORECAST.ETS: Seasonal Forecasts with Exponential Smoothing
- 31.4 FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY and FORECAST.ETS.STAT
- 31.5 Forecast Sheet: Data › Forecast › Forecast Sheet
- 31.6 Seasonality by Hand: Trend plus Weekday Offsets with TREND and AVERAGEIFS
- 31.7 Forecast Accuracy: MAE, MAPE, RMSE and a Holdout Test
- Practice and Answer Key: Forecast Weekly Orders for a Kolhapur Store and Test the Forecast
Show 1 concepts
More chapters
Course series
Extra series that sit with the handbook — every link kept.
Start here & appendices
Classroom chapters 38
Kept compact so the main course chapters stay first.
Show classroom chapters
- What Is Data Analytics? The 5 Steps Explained with Instagram and Flipkart Examples
- Excel Basics for Beginners: Workbook, Sheets, Cells, AutoFill and Date Series
- Excel Date Formats Explained: DD-MM vs MM-DD, Locale, Format Cells (Ctrl+1) and Custom Lists
- Excel Flash Fill (Ctrl+E) with Real Examples: Names, Emails, Phone Numbers and Masking
- Excel COUNT, COUNTA, COUNTBLANK and COUNTIF: Total Students, Absentees and Pass Percentage (with MAX and MIN)
- Excel IF, Nested IF and AND Function: Pass or Fail in All Subjects
- Relative vs Absolute vs Mixed Cell Reference in Excel (F4 Key) with GST Example
- Excel IFS Function: Student Grades A+, A, B, C with Total and Percentage (IFS vs Nested IF)
- Excel VLOOKUP Explained: Exact Match, Column Number, Duplicates and #N/A (with HLOOKUP and TRANSPOSE)
- Excel XLOOKUP Tutorial: Search Right to Left, Last Match, Not Found Message and Drop-Down List
- Return Multiple Columns with XLOOKUP, HSTACK and CHOOSECOLS in Excel
- Excel INDEX and MATCH Function Explained (with XMATCH): Lookup Without XLOOKUP
- Excel FILTER Function: Return All Matching Rows, Multiple Conditions, Starts With and #SPILL! Error
- How to Understand a Dataset Before Analysis: Blinkit Quick Commerce Example (Business Questions)
- Analyse Blinkit Orders in Excel: Total Orders, Cities, Products and Payment Mode with COUNTA, UNIQUE and COUNTIF
- Excel SORT, FILTER and TAKE Together: Top 3 Profit Orders and Biggest Losses by City
- Excel SUMIF, SUMIFS, COUNTIFS, AVERAGEIF(S) and MAXIFS: Profit Analysis of Delivered Orders
- Excel Conditional Formatting Tutorial: Highlight Cells, Top 3, Duplicates, Data Bars, Color Scales and Icon Sets
- How to Highlight an Entire Row in Excel with Conditional Formatting (Formula Rule)
- How to Create an Employee Attendance Sheet in Excel with Tick and Cross Icons (Present Days with COUNTIF)
- Employee Salary Calculation in Excel: Basic, HRA, DA, TA, Gross, PF, Net Salary and CTC
- Excel Data Validation Tutorial: Allow Only Numbers, Dates and Text Length with Input Message and Error Alert
- Excel Custom Number Format: Add kg, gram, ₹ and Rs to Numbers, Thousands Separator and Red Negative Numbers
- Split Quantity and Unit in Excel (2 kg, 500 gram) with TEXTBEFORE, TEXTAFTER and NUMBERVALUE: Convert Grams to Kg
- Excel Table vs Range: Ctrl+T, Sort, Filter, Table Name and Structured References like =MAX(marks[Total])
- Excel Structured References Explained: [@Column] This Row, Calculated Columns and Table Name Inside vs Outside the Table
- SUBTOTAL vs SUM in Excel: Ignore Hidden and Filtered Rows (Function Codes 9 vs 109) and the Table Total Row
- How to Use Slicers in Excel Tables: Insert, Multi-Select, Clear Filter and Arrange Buttons in Columns (with UNIQUE and COUNTIFS)
- How to Create a PivotTable in Excel for Beginners: Rows, Values, Count vs Sum and Report Filter (Blinkit Orders Example)
- How to Build a Sales Dashboard in Excel with PivotTables, Pivot Charts, Slicers and Timeline (Step by Step)
- Excel PivotTable with Multiple Values, Nested Rows and Columns: Count and Sum Side by Side, City by Payment Mode
- Change Sum to Average in an Excel PivotTable and Create a Pivot Chart (Clustered Column) for a Dashboard
- Power Query in Excel for Beginners: Import a CSV, Remove Top Rows, Remove Duplicates, Column Quality and Date Locale
- Clean Data in Excel Power Query: Extract Text Before Delimiter, Replace NA with 0, Data Types, Remove Columns and Close & Load
- How to Sort a PivotTable in Excel: Largest to Smallest, Move Items Manually, Expand/Collapse and Show Details (Drill Down)
- How to Create a KPI Card in Excel: Link a Shape to a Cell (Total Orders and Profit) for a Dashboard
- Power Query: Fix DataFormat.Error with NA, US Dates (M/D/YYYY) with Locale, Decimal Sales and Duplicate Rows vs Keys
- How to Group Dates by Month in an Excel PivotTable and Make a Monthly Revenue Pivot Chart
Excel in Daily Life 50
Kept compact so the main course chapters stay first.
Show excel in daily life
- How to Make a Monthly Home Budget in Excel (Planned vs Actual, Savings and Overspending Alerts)
- Daily Expense Tracker in Excel: Log Spending by Category and See Monthly Totals Automatically
- How to Calculate Home Loan EMI in Excel with PMT (and Make a Month-by-Month Repayment Schedule)
- Bill Payment Reminder in Excel: Highlight Due and Overdue Bills Automatically with TODAY
- How to Make a Habit Tracker in Excel with Checkboxes (Monthly Grid, Totals and Streaks)
- Grocery List in Excel with Prices: Auto Total, Category Drop-Down and Tick Items as You Shop
- Savings Goal Calculator in Excel: How Much to Save Each Month (PMT, NPER and Goal Seek)
- Trip Budget in Excel: Plan vs Actual, Expense Log and Split Costs Among Friends (Who Owes Whom)
- Weight Loss and Fitness Tracker in Excel: BMI Formula, Progress % and a Line Chart with a Goal Line
- Weekly Meal Planner in Excel That Builds Your Shopping List Automatically (No Macros)
- SIP Calculator in Excel: Future Value of a Monthly SIP with the FV Function (and a Yearly Step-Up)
- FD Calculator in Excel: Maturity Amount and Interest with Quarterly Compounding (Compare 3 Offers)
- Compare Personal Loan Offers in Excel: EMI, Total Interest, Processing Fee and the Cheapest Loan
- Electricity Meter Reading Tracker in Excel: Units Used per Month, Bill Estimate and Usage Chart
- Fuel Mileage Tracker in Excel: km per Litre and Cost per km for Your Bike or Car
- Milk Bill Calculator in Excel: Daily Litres Calendar, Monthly Bill and Missed Days
- Birthday and Anniversary Reminder in Excel: Age, Next Birthday and Days Left (DATEDIF)
- Home Inventory in Excel: Appliance List with Warranty Expiry Dates and Alerts (EDATE)
- To-Do List in Excel with Priority, Due Dates, a Done Checkbox and a Progress Bar
- Exam Study Planner in Excel: Countdown to the Exam, Syllabus Progress and a Weekly Study Log
- Net Worth Tracker in Excel: Assets, Liabilities and Monthly Net Worth (with a Chart)
- Rent Collection Tracker in Excel: Monthly Rent Received, Pending Dues and Late Tenants
- Guest List and Budget in Excel for a Function: RSVP Count, Plates to Order and Total Cost
- Medicine Refill Reminder in Excel: Tablets Left, Days of Stock and Refill-by Dates
- Pocket Money Tracker in Excel for Kids: Running Balance, Spending and a Savings Goal
- Car and Bike Service Log in Excel: Next Service Due by km or Date, and Maintenance Cost
- Gas Cylinder Tracker in Excel: How Many Days Each LPG Cylinder Lasts and When to Book the Next
- Sleep Tracker in Excel: Calculate Hours Slept (Even Past Midnight) and Weekly Averages
- Household Chores Roster in Excel: Rotate Chores Every Week Automatically (INDEX and MOD)
- Recipe Cost Calculator in Excel: Scale a Recipe for More Guests and Find the Cost per Plate
- Credit Card Bill Tracker in Excel: Due Dates, Pending Amount and Credit Utilisation
- Insurance Policy Renewal Tracker in Excel: Next Premium Due Date with EDATE and Yearly Cost
- Walking Steps Tracker in Excel: Daily Goal, Weekly Average with AVERAGEIFS and Km Walked
- Customer Credit (Khata) Book in Excel: Udhaar Balance per Customer with SUMIFS
- Unit Price Comparison in Excel: Which Pack Size Is Cheaper per Kg or Litre?
- Blood Pressure Log in Excel: Morning and Evening Averages and High Readings Flagged
- Reading Log in Excel: Pages per Day, % Done and Expected Book Finish Date
- Flatmate Expense Split in Excel: Share Rent by Room Size and Bills by Days Stayed
- Freelance Timesheet in Excel: Hours Worked, Overtime and Invoice Total per Project
- CAGR Calculator in Excel: Compare Investment Returns with a Formula and the RRI Function
- Emergency Fund Calculator in Excel: How Many Months of Expenses Are You Covered For?
- Shopping Offer Comparison in Excel: Buy 2 Get 1 Free vs % Off vs Flat ₹ Off
- Gym Workout Log in Excel: Sets, Reps, Volume and Personal Bests with MAXIFS
- Screen Time Tracker in Excel: Daily Leisure Limit, Weekday vs Weekend and Stacked Chart
- Gift Register for a Function in Excel: Cash Gifts, Items and What We Gave Them Earlier
- Money Lent Tracker in Excel: Simple Interest by Days, Total Due and Overdue Loans
- Vegetable Stall Profit Tracker in Excel: Daily Profit, Margin, Waste % and Break-even Price
- Cricket Batting Stats in Excel: Batting Average, Strike Rate and Player Rank
- Appliance Electricity Cost Calculator in Excel: Watts to Units (kWh) and Monthly Cost
- Own Car vs Cab Cost in Excel: Monthly Cost per Km and Break-even Distance
Excel Business Management Systems 50
Kept compact so the main course chapters stay first.
Show excel business management systems
- Employee Attendance Management System in Excel: Monthly Codes, Leave Balance, Late Marks and Dashboard
- Salary Slip Generator in Excel: Employee Master, Monthly Inputs and a Printable Payslip for Any Employee
- Payroll Calculator in Excel with PF, ESI and Professional Tax: Employer Cost, Statutory Dues and Bank Transfer List
- Software Project Management System in Excel: Task Tracker, Sprint Burndown, Risk Register and Project Dashboard
- Vendor Management System in Excel: Purchase Orders, Bills, Payments, Payable Ageing and Vendor Scorecard
- Restaurant Management System in Excel: Menu, Orders, GST Bills, Printable Bill, Food Cost and Sales Dashboard
- Hotel Management System in Excel: Room Bookings, Daily Occupancy, ADR, RevPAR, GST Room Bill and Dashboard
- Salon Management System in Excel: Appointments, Client History, Repeat Clients, Stylist Sales and Commission
- Shop Billing and Inventory System in Excel: Items, Purchases, Sales, Stock Reorder, Profit and Daily Cash Book
- Clinic Patient Management System in Excel: Patient Register, Visits, Fees, Follow-up Reminders and Receipts
- Gym Membership Management System in Excel: Plans, Renewals, Check-ins, Receipts and Dashboard
- School Fee Management System in Excel: Fee Structure, Instalments, Overdue List, Receipts and Dashboard
- Tuition Centre Management System in Excel: Groups, Monthly Fees, Test Marks, Progress Card and Dashboard
- Inventory and Warehouse Management System in Excel: Stock In, Stock Out, Days of Cover, Reorder, ABC and Challan
- Rental Property Management System in Excel: Units, Rent Roll, Arrears, Lease Expiry, Receipts and Net Yield
- Event Management System in Excel: Budget vs Actual, Vendor Expenses, Task List, Quotation and Profit
- Transport and Fleet Management System in Excel: Trips, Km per Litre, Cost per Km, Document Expiry and Profit
- Construction Site Management System in Excel: BOQ, Progress, Materials, Labour, Budget vs Actual and RA Bill
- CA Office Compliance Management System in Excel: GST and TDS Due Dates, Filing Status, Fees and Staff Report
- Beauty Parlour Management System in Excel: Packages, Sessions, Product Stock, Staff Incentive and Bills
- Bakery Management System in Excel: Recipe Costing, Daily Production, Sales, Waste and Dashboard
- Pharmacy Management System in Excel: Items, Sales Bills, Stock, Expiry Alerts and Dashboard
- Dairy Milk Collection System in Excel: Fat and SNF Rate Chart, Shift Entries, Farmer Bills and Dashboard
- Cloud Kitchen Management System in Excel: Menu Costing, Orders, App Commission, Net Margin and Dashboard
- Boutique and Tailoring Management System in Excel: Measurements, Orders, Delivery Dates, Job Cards and Dashboard
- Hardware Store Management System in Excel: GST Invoices, Contractor Credit, Ageing, Stock and Dashboard
- Mobile Repair Job Card System in Excel: Jobs, Parts Stock, Status Flags, Warranty and Dashboard
- Car Service Garage Management System in Excel: Job Cards, Parts and Labour, GST Invoice, Service Reminders and Dashboard
- Laundry Management System in Excel: Price List, Order Lines, Express Surcharge, Due Dates, Receipts and Dashboard
- Printing Press Management System in Excel: Job Estimator, Paper and Plates, Quotation, Delivery Status and Dashboard
- Hostel and PG Management System in Excel: Rooms, Residents, Rent, Late Fee, Occupancy and Dashboard
- Co-working Space Management System in Excel: Plans, Members, Meeting Room Bookings, Monthly Billing and Dashboard
- Housing Society Maintenance System in Excel: Quarterly Bills, Sinking Fund, Interest on Arrears, Receipts, Expenses and Dashboard
- Travel Agency Management System in Excel: Tour Packages, Bookings, Payments, Balance Due and Dashboard
- Courier Management System in Excel: Zone Rate Chart, Weight Slabs, Fuel Surcharge, Delivery Status and Dashboard
- Catering Management System in Excel: Packages, Events, Payments, Kitchen Quantities, Margin and Dashboard
- Photography Studio Management System in Excel: Packages, Bookings, Date Clash Check, Delivery Tracking and Dashboard
- Interior Design Costing System in Excel: Rate Card, Room Estimate, Budget vs Actual, Payment Schedule and Quotation
- Manufacturing Production Planning System in Excel: Machine Hours, Planned Finish Date, Progress, Rejects and Machine Load
- Farm Management System in Excel: Plot-wise Expenses, Crop Sales, Profit per Acre, Cost per Quintal and Dashboard
- Poultry Farm Management System in Excel: Flocks, Daily Deaths and Feed, Bird Sales, Mortality %, FCR and Profit
- Petrol Pump Shift Management System in Excel: Meter Readings, Litres Sold, Cash and UPI Collection, Shortage and Tank Dip
- Library Management System in Excel: Books, Members, Issue and Return, Due Dates, Late Fines and Availability
- Day-care Management System in Excel: Children, Daily Attendance, Late Pickup Charges, Monthly Fees and Fee Bill
- NGO Donor and Fund Management System in Excel: Donors, Donations, 80G Checks, Fund-wise Spending, Balance and Receipt
- Sales CRM System in Excel: Leads, Stages, Weighted Pipeline, Follow-up Reminders, Win Rate by Source and Dashboard
- Complaint Ticket Management System in Excel: Priorities, Due-by Time, Hours Taken, Met or Breached and Agent Report
- IT Asset Management System in Excel: Asset Register, Assigned To, Warranty Alerts, Book Value, Repairs and Report
- Expense Reimbursement System in Excel: Claims, Km Rates, Category Limits, Bill Check, Approval and Payment Status
- Small Business Accounts Receivable System in Excel: Invoices, Part Payments, Due Dates, Ageing Buckets, Credit Limits and Statement
Guides, dashboards & more
Every guide, dashboard and template link from the old hub - kept here so the chapters stay near the top.
Industry dashboards: Banking (xlsx) · Hospitals (xlsx) · Retail (xlsx) · Education (xlsx) · Logistics (xlsx) · Hotels (xlsx) · Pharma (xlsx) · Real Estate (xlsx) · Restaurants (xlsx) · Telecom (xlsx). All of these workbooks use fictional teaching data.
Industry templates: Retail quick commerce (xlsx) · Ecommerce (xlsx) · Sales (xlsx) · Finance and accounting (xlsx) · Banking (xlsx) · Insurance (xlsx) · Healthcare (xlsx) · Pharma (xlsx) · Manufacturing (xlsx) · Inventory and supply chain (xlsx) · Logistics (xlsx) · HR (xlsx) · Marketing and digital ads (xlsx) · Education (xlsx) · Hospitality (xlsx) · Restaurants (xlsx) · Real estate (xlsx) · Telecom (xlsx) · IT services (xlsx) · Government and NGO (xlsx). Ready-to-fill workbooks with drop-downs, formulas and a dashboard. All of these workbooks use fictional teaching data.
How-to guides: Excel Table vs Normal Range · Formulas Across Sheets and 3D References · XLOOKUP with Multiple Criteria · SUMIFS with Dates · Conditional Formatting with Formulas · Dependent Drop-Down List · Named Ranges in Excel · Text Functions for Data Cleanup · Age and Service with DATEDIF · NETWORKDAYS and WORKDAY · Percentage Formulas in Excel · IFERROR vs IFNA · SUMPRODUCT Examples · Link Workbooks and Fix Broken Links · Power Query Merge · Power Pivot Relationships · PivotTable Slicers and Timelines · Which Chart to Use · Dynamic Charts · Data Validation Rules · Flash Fill and Text to Columns · Multi-level Sort and Advanced Filter · UNIQUE, SORT and SORTBY · RANK, LARGE and SMALL · ROUND, ROUNDUP and MROUND · Relative, Absolute and Mixed References · Goal Seek · Data Tables (What-If) · Scenario Manager · PMT EMI and Loan Schedule · NPV and IRR · GST Calculation Formulas · Protect Sheet and Lock Cells · Print Setup · SUBTOTAL and AGGREGATE · LET Function · IFS, SWITCH and CHOOSE · Fix Formula Errors · Record Your First Macro · Copilot prompt cookbook. Step-by-step guides with practice files and fictional example data.
Customer analytics: RFM analysis in Excel (xlsx) · Cohort retention in Excel (xlsx) · Customer LTV in Excel (xlsx). Guides with ready-to-fill templates; fictional teaching data.
Real-data case studies: Case study: US e-commerce (Census data) · Case study: online retail RFM (UCI data) · Case study: NYC restaurant inspections · Case study: flight delays at Boston Logan. Each uses a real public dataset; the source and licence are cited on the page.
Comparisons: Excel vs SQL · Excel vs Python pandas · VLOOKUP vs XLOOKUP vs INDEX-MATCH · PivotTable vs GROUPBY/PIVOTBY · Excel vs Google Sheets · Excel: Mac vs Windows vs web. Feature differences checked against the official documentation.
Free guides for this course
Short guides that answer one question each, with the exact steps. Read them next to the chapters.
- Formulas everyone needsExcel XLOOKUP Basics for BeginnersXLOOKUP finds a value in a range and returns from another — cleaner than VLOOKUP.
- Formulas everyone needsExcel VLOOKUP Exact Match (FALSE) for BeginnersVLOOKUP + FALSE → exact product or city match from a lookup table.
- PivotTables, charts and Power QueryHow to Create a PivotTable in Excel from ScratchSelect data → Insert PivotTable → Rows + Values → city totals.
- Formulas everyone needsExcel IF Function for Decisions (Pass/Fail, High/Low)IF(test, then, else) — High/Low or Pass/Fail in one cell.
- Formulas everyone needsExcel SUMIF and SUMIFS for Conditional TotalsSUMIF one filter · SUMIFS many filters — conditional totals.
- Formulas everyone needsFix Excel Formula Errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NAME? and #SPILL!What each error means, why it happens and how to fix it, with broken examples.
Frequently asked questions
Is this Excel course free?
Yes. All 34 chapters and 340 concept pages are free to read online, and you do not need an account.
Is the Excel course in Marathi?
The lessons on this website are written in simple English with some Marathi phrases in the trainer's voice. In his online and offline classes, Ravindra Bagale teaches in Marathi, with some Hindi.
What does the Excel course cover?
Excel basics and references, data entry tools, formulas and functions, lookups (VLOOKUP to XLOOKUP), data cleaning A–Z, Tables, PivotTables, charts, dynamic arrays (including GROUPBY, PIVOTBY, REGEX functions, TOCOL, WRAPROWS, EXPAND, TRIMRANGE and IMAGE), full LAMBDA with MAP, REDUCE, SCAN and recursion, Power Query, what-if analysis, Macros and VBA, Office Scripts with Power Automate, Copilot and AI in Excel (with a checking habit for every AI number), Python in Excel with pandas and charts, statistics for analysts (descriptive statistics, the Analysis ToolPak, histograms, correlation, LINEST and regression output, T.TEST A/B tests, CHISQ.TEST), forecasting (FORECAST.LINEAR, TREND, FORECAST.ETS with confidence intervals, Forecast Sheet, seasonality, MAE and MAPE), dashboards, a final project, real-world project briefs (including a salary slip), industry KPIs with worked fictional sample rows, formulas across sheets and workbooks, Power Pivot and the Data Model with DAX measures, keyboard shortcuts for Windows and Mac, analyst tricks, 20 industry projects with expected results, and interview questions.
Is this Excel course for beginners?
Yes. It goes from beginner to job-ready, starting with 1. Excel Basics.
Does it cover VLOOKUP and XLOOKUP?
Yes. 4. Lookup Functions covers the lookup functions, from VLOOKUP to XLOOKUP.
Are there Excel practice and interview questions?
Yes: 16. Practice Exercises with Answer Hints, 17. Interview Questions and Answers and 18. Interview Questions Asked in MNC Interviews. There is also a final project: 15. Final Project: Blinkit Maharashtra Monthly Report.
Does the Excel course cover Copilot and Python in Excel?
Yes. 28. Copilot and AI in Excel covers the Copilot pane, editing and plan modes, prompt patterns, how to check AI numbers with formulas, privacy and licences. 29. Python in Excel covers =PY cells, xl(), pandas groupby, charts, calculation order and a weekly report project.
Does the Excel course teach statistics and forecasting?
Yes. 30. Statistics for Analysts covers descriptive statistics with functions and the Analysis ToolPak, histograms and outliers, correlation, LINEST and the ToolPak regression report line by line, A/B tests with T.TEST and CHISQ.TEST, and common mistakes. 31. Forecasting in Excel covers FORECAST.LINEAR, TREND, FORECAST.ETS with confidence intervals and seasonality, the Forecast Sheet, a trend plus weekday-offset method and accuracy testing with MAE and MAPE.
How do I join online or offline Excel classes?
Send an enquiry on the enquiry page, or chat on WhatsApp. Ravindra Bagale runs online and offline batches for Excel, Power BI and Data Analytics.
Join an online / offline batch — Enquire now
Ravindra Bagale runs online and offline batches for AWS Cloud, DevOps, DevSecOps, Power BI, Excel, Data Analytics, Data Science and Cyber Security.