20. Glossary
Ha glossary tumchya sathi shabdakosh aahe. Pratyek term sobat tyacha English meaning aani Marathi arth (Devanagari madhe) dila aahe. Je shabd standard English aahet aani roj vaparle jatat (Cell, Filter, Chart vagaire), tithe "— (English madhech vapra)" asa lihila aahe – te English madhech vapra. Kontahi shabd visarla tar ithe patkan bagha.
| Term | Meaning | मराठी अर्थ |
|---|---|---|
| Absolute reference | A cell reference with $ signs ($F$1) that does not change when copied. |
स्थिर संदर्भ |
| Active cell | The currently selected cell where typing goes. | सध्या निवडलेला सेल |
| Advanced Filter | Filter that uses a criteria range for complex AND/OR conditions and can copy results elsewhere. | प्रगत फिल्टर |
| Aggregate | To summarise many values into one (sum, count, average). | एकत्रीकरण करणे |
| Append | Stacking rows of two or more tables with the same columns (Power Query). | ओळी एकाखाली एक जोडणे |
| Applied Steps | The recorded list of transformations in a Power Query query. | नोंदवलेल्या पायऱ्या |
| Argument | An input value given to a function, e.g. the range in SUM(range). |
फंक्शनला दिलेली मूल्ये (घटक) |
| Array | A set of values in rows and/or columns treated together in a formula. | मूल्यांचा संच (रचना) |
| AOV | Average Order Value = Net Sales ÷ Delivered Orders. | — (English madhech vapra) |
| AutoFill / Fill handle | Dragging the small square at a cell's corner to copy or continue a series. | — (English madhech vapra) |
| Break-even | The level of sales at which profit is zero. | ना नफा ना तोटा बिंदू |
| Calculated field | A PivotTable field defined by a formula on other fields. | गणना करून तयार केलेले फील्ड |
| Cell | Intersection of a row and a column, e.g. B2. | — (English madhech vapra) |
| Chart | A visual representation of data. | — (English madhech vapra) |
| Co-authoring | Several people editing the same workbook at the same time (OneDrive/SharePoint). | एकाच वेळी एकत्र संपादन |
| Column | A vertical line of cells (A, B, C…). | — (English madhech vapra) |
| Concatenate | Joining text from several cells into one (&, CONCAT, TEXTJOIN). |
मजकूर जोडणे |
| Conditional formatting | Formatting applied automatically when a cell meets a rule. | अटीनुसार स्वरूपण |
| Criteria | Conditions used to filter, count or sum (e.g. City = "Pune"). | निकष |
| Dashboard | A one-screen summary of KPIs and charts. | — (English madhech vapra) |
| Data Model | Excel's in-memory store of related tables used by Power Pivot. | — (English madhech vapra) |
| Data Table (What-If) | A grid showing a formula's result for many values of one or two inputs. | — (English madhech vapra) |
| Data validation | Rules that restrict what can be entered in a cell. | डेटा पडताळणी (नोंदींवर नियंत्रण) |
| Delimiter | A character that separates parts of text, such as a comma or hyphen. | विभाजक चिन्ह |
| Duplicate | A repeated row or value. | — (English madhech vapra) |
| Dynamic array | A formula that returns several values which spill into neighbouring cells. | आपोआप पसरणारा ॲरे |
| Encryption | Protecting a file so it cannot be opened without the password. | कूटबद्धीकरण |
| Filter | Showing only rows that meet conditions. | — (English madhech vapra) |
| Flash Fill | Filling a column automatically from a pattern shown in examples (Ctrl + E). | — (English madhech vapra) |
| Formula | An expression starting with = that calculates a value. |
— (English madhech vapra) |
| Function | A built-in named calculation such as SUM or XLOOKUP. | — (English madhech vapra) |
| Goal Seek | Finds the input value needed to reach a target result. | लक्ष्य शोध |
| Granularity | The level of detail of data (per order, per day, per month). | तपशीलाची पातळी |
| Helper column | An extra column used for an intermediate calculation. | सहाय्यक कॉलम |
| Immediate window | A VBA Editor pane for printing values and testing statements. | — (English madhech vapra) |
| Iteration | Repeating a calculation or loop step many times. | पुनरावृत्ती |
| KPI | Key Performance Indicator – a number that measures progress towards a goal. | मुख्य कामगिरी निर्देशक |
| Lookup | Finding a value in one table and returning related information. | शोध घेऊन संबंधित माहिती आणणे |
| Loop | VBA code that repeats (For, For Each, Do While). | पुनरावृत्ती होणारा कोड-भाग |
| Macro | A recorded or written set of instructions that automates tasks. | — (English madhech vapra) |
| Merge (Power Query) | Joining two tables side by side on a common key. | दोन टेबल्स सामायिक कीवर जोडणे |
| Mixed reference | A reference fixing only the row or only the column ($A2, A$2). |
अंशतः स्थिर संदर्भ |
| Module (VBA) | A container in the VBA project where procedures are written. | — (English madhech vapra) |
| Named range | A name given to a cell or range, e.g. GST_Rate. |
नाव दिलेली रेंज |
| Nested formula | A function used inside another function. | एकात एक गुंफलेले सूत्र |
| Outlier | A value far away from most other values. | असामान्य (टोकाचे) मूल्य |
| PivotChart | A chart connected to a PivotTable. | — (English madhech vapra) |
| PivotTable | An interactive summary of data by categories. | — (English madhech vapra) |
| Power Pivot | Excel feature for the Data Model, relationships and DAX measures. | — (English madhech vapra) |
| Power Query | Excel's tool to import, clean and reshape data with repeatable steps. | — (English madhech vapra) |
| Print titles | Rows/columns repeated on every printed page. | — (English madhech vapra) |
| Procedure | A named block of VBA code – a Sub or a Function. | प्रक्रिया (कोडचा भाग) |
| Range | A group of cells, e.g. A2:G100. | — (English madhech vapra) |
| Reconciliation | Checking that counts and totals match before and after a process. | ताळमेळ |
| Relative reference | A reference that changes when copied (A2). |
सापेक्ष संदर्भ |
| Report | A document or sheet that presents results. | — (English madhech vapra) |
| Row | A horizontal line of cells (1, 2, 3…). | — (English madhech vapra) |
| Scenario Manager | Tool to save and compare named sets of input values. | परिस्थिती व्यवस्थापक |
| Sheet / Worksheet | One grid tab inside a workbook. | — (English madhech vapra) |
| Slicer | A button-style visual filter for Tables and PivotTables. | — (English madhech vapra) |
| Solver | Add-in that finds the best values for variables under constraints. | — (English madhech vapra) |
| Sort | Arranging rows in ascending or descending order. | — (English madhech vapra) |
| Sparkline | A tiny chart inside a single cell. | — (English madhech vapra) |
| Spill | When a dynamic array formula fills several cells; #SPILL! means it is blocked. |
निकाल पुढील सेल्समध्ये पसरणे |
| Structured reference | Referring to Table columns by name, e.g. tblOrders[Amount]. |
नावाने दिलेला टेबल संदर्भ |
| Table (Excel Table) | A structured range created with Ctrl + T that expands automatically. | — (English madhech vapra) |
| Timeline | A slicer for dates (days, months, quarters, years). | — (English madhech vapra) |
| Transpose | Switching rows to columns and columns to rows. | ओळी-स्तंभांची अदलाबदल |
| UDF | User-defined function written in VBA and used in cells like a built-in function. | वापरकर्त्याने तयार केलेले फंक्शन |
| Unpivot | Turning column headers (such as months) into row values. | स्तंभांचे ओळींमध्ये रूपांतर |
| Variable | A named storage place for a value in VBA (Dim lastRow As Long). |
चल (मूल्य साठवण्याची जागा) |
| VBA | Visual Basic for Applications – the programming language behind Excel macros. | — (English madhech vapra) |
| Volatile function | A function that recalculates on every change (TODAY, OFFSET, INDIRECT). | सतत पुन्हा गणना होणारे फंक्शन |
| Wildcard | * or ? used to match any text in criteria. |
कोणत्याही अक्षरांसाठी वापरले जाणारे चिन्ह |
| Workbook | An Excel file containing one or more worksheets. | — (English madhech vapra) |