# Excel — Marathi

> Marathi course content with English technical terms. Listed lessons are first-pass Marathi translations; generated course directories may also be listed.

## Lessons

- [1.1 Excel च्या screen ची ओळख](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-1-the-excel-interface.html.md)
- [1.2 Workbook, worksheet आणि आपला practice data](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-2-workbooks-worksheets-and-our-practice-dataset.html.md)
- [1.3 Relative, absolute आणि mixed references](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-3-relative-absolute-and-mixed-references.html.md)
- [1.4 Cells चं formatting](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-4-formatting-cells.html.md)
- [1.5 Rupee, numbers आणि dates चे formats](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-5-number-formats-rupees-in-indian-style-and-dates.html.md)
- [1.6 Custom number formats](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-6-custom-number-formats.html.md)
- [1.7 Freeze Panes — scroll करतानाही headings दिसू द्या](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-7-freeze-panes.html.md)
- [1.8 Named ranges — cells ना अर्थपूर्ण नावं द्या](https://ravindrabagale.com/mr/excel/ch01-excel-basics/1-8-named-ranges.html.md)
- [1. Excel ची basic ओळख](https://ravindrabagale.com/mr/excel/ch01-excel-basics/index.html.md)
- [2.1 AutoFill आणि Fill Series](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-1-autofill-and-fill-series.html.md)
- [2.2 Flash Fill — example दाखवा आणि pattern भरा](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-2-flash-fill.html.md)
- [2.3 Data Validation — योग्य values भरू द्या](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-3-data-validation.html.md)
- [2.4 Drop-down lists](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-4-drop-down-lists.html.md)
- [2.5 City निवडल्यावर त्याच शहराचे Area दाखवा](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-5-dependent-drop-down-city-area.html.md)
- [2.6 Conditional Formatting — highlight आणि Top/Bottom rules](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-6-conditional-formatting-highlight-rules-and-top.html.md)
- [2.7 Data Bars, Color Scales आणि Icon Sets](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-7-data-bars-color-scales-and-icon-sets.html.md)
- [2.8 Formula वापरून Conditional Formatting](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/2-8-formula-based-conditional-formatting.html.md)
- [2. Data entry सोपी आणि consistent करा](https://ravindrabagale.com/mr/excel/ch02-data-entry-tools/index.html.md)
- [3.1 Formula ची सुरुवात आणि operators](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-1-formula-basics-and-operators.html.md)
- [3.10 Dates — TODAY, NOW, DATE, EOMONTH आणि EDATE](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-10-date-functions-today-now-date-day-month-year.html.md)
- [3.11 Working days, DATEDIF आणि WEEKDAY](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-11-working-days-datedif-and-weekday.html.md)
- [3.12 Time calculations](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-12-time-calculations.html.md)
- [3.13 IF, nested IF आणि IFS](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-13-if-nested-if-and-ifs.html.md)
- [3.14 AND, OR, NOT आणि SWITCH](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-14-and-or-not-and-switch.html.md)
- [3.15 IFERROR आणि IFNA](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-15-iferror-and-ifna.html.md)
- [3.16 SUMPRODUCT](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-16-sumproduct.html.md)
- [3.17 Formula errors ओळखा आणि दुरुस्त करा](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-17-error-types-and-how-to-fix-them.html.md)
- [3.2 SUM, SUMIF आणि SUMIFS](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-2-sum-sumif-and-sumifs.html.md)
- [3.3 COUNT, COUNTA, COUNTBLANK, COUNTIF आणि COUNTIFS](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-3-count-counta-countblank-countif-and-countifs.html.md)
- [3.4 AVERAGE, AVERAGEIFS, MINIFS आणि MAXIFS](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-4-average-averageif-s-minifs-and-maxifs.html.md)
- [3.5 ROUND family आणि RANK](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-5-round-family-and-rank.html.md)
- [3.6 LEFT, RIGHT, MID, LEN, FIND आणि SEARCH](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-6-text-functions-left-right-mid-len-find-and.html.md)
- [3.7 SUBSTITUTE, REPLACE, TRIM, CLEAN आणि text case](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-7-substitute-replace-trim-clean-and-case-functions.html.md)
- [3.8 Text जोडणं — &, CONCAT, TEXTJOIN आणि TEXT](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-8-joining-text-and-concat-textjoin-and-text.html.md)
- [3.9 TEXTBEFORE, TEXTAFTER आणि TEXTSPLIT](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/3-9-textbefore-textafter-and-textsplit.html.md)
- [3. Formulas आणि functions](https://ravindrabagale.com/mr/excel/ch03-formulas-and-functions/index.html.md)
- [4.1 VLOOKUP — exact match](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-1-vlookup-with-exact-match.html.md)
- [4.10 Lookup errors — कारण शोधण्याची सोपी पद्धत](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-10-common-lookup-errors-and-fixes.html.md)
- [4.2 Approximate VLOOKUP आणि column index ची अडचण](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-2-vlookup-approximate-match-and-the-column-index.html.md)
- [4.3 HLOOKUP — आडव्या table मध्ये शोधा](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-3-hlookup.html.md)
- [4.4 INDEX आणि MATCH एकत्र वापरा](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-4-index-and-match.html.md)
- [4.5 Two-way lookup — City आणि Month वरून value](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-5-two-way-lookup-row-and-column.html.md)
- [4.6 XLOOKUP आणि if_not_found](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-6-xlookup-basics-and-if-not-found.html.md)
- [4.7 XLOOKUP चे match modes, search modes आणि multiple columns](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-7-xlookup-match-modes-search-modes-and-multiple.html.md)
- [4.8 XMATCH — value ची position शोधा](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-8-xmatch.html.md)
- [4.9 Amount नुसार delivery fee slabs](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/4-9-approximate-lookup-delivery-fee-slabs.html.md)
- [4. Lookup functions](https://ravindrabagale.com/mr/excel/ch04-lookup-functions/index.html.md)
- [5.1 Duplicates ओळखा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-1-duplicates.html.md)
- [5.10 Phone numbers clean करा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-10-phone-numbers.html.md)
- [5.11 Email addresses clean आणि तपासा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-11-e-mail-addresses.html.md)
- [5.12 Pincodes आणि leading zeros असलेले codes](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-12-pincodes-and-codes-with-leading-zeros.html.md)
- [5.13 Text मधून हवे ते parts काढा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-13-extracting-parts-of-text.html.md)
- [5.14 Unwanted characters काढा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-14-removing-unwanted-characters.html.md)
- [5.15 Outliers — वेगळी value म्हणजे चूकच असते का?](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-15-outliers.html.md)
- [5.16 Data मधले error values](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-16-error-values-in-data.html.md)
- [5.17 Unpivot — महिन्यांचे columns rows मध्ये आणा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-17-unpivot-wide-to-long-concept.html.md)
- [5.18 Messy export पूर्ण clean करूया](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-18-end-to-end-cleaning-a-messy-blinkit-export.html.md)
- [5.2 Blank cells आणि पूर्ण रिकाम्या rows](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-2-blank-cells.html.md)
- [5.3 Extra spaces आणि दिसत नसलेले characters](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-3-extra-spaces-and-non-printable-characters.html.md)
- [5.4 Text case consistent ठेवा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-4-inconsistent-case.html.md)
- [5.5 City spellings साठी mapping table](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-5-inconsistent-city-spellings.html.md)
- [5.6 Numbers text म्हणून साठवले असतील तर](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-6-numbers-stored-as-text.html.md)
- [5.7 Text dates आणि mixed date formats](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-7-text-dates-and-mixed-date-formats.html.md)
- [5.8 एक column वेगवेगळ्या columns मध्ये split करा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-8-splitting-columns.html.md)
- [5.9 Text columns एकत्र जोडा](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/5-9-merging-columns.html.md)
- [5. Data cleaning — सुरुवातीपासून शेवटपर्यंत](https://ravindrabagale.com/mr/excel/ch05-data-cleaning-a-z/index.html.md)
- [6.1 Excel Table — data ला व्यवस्थित structure द्या](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-1-excel-tables-ctrl-t.html.md)
- [6.2 Structured references — formula मध्ये columnचं नाव वापरा](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-2-structured-references.html.md)
- [6.3 Total Row — filterनुसार बदलणारा total](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-3-the-total-row.html.md)
- [6.4 Multi-level आणि custom sorting](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-4-sorting-multi-level-and-custom-sort.html.md)
- [6.5 AutoFilter — हवा तेवढाच data पाहा](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-5-autofilter.html.md)
- [6.6 Advanced Filter — AND / OR अटी एकत्र](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-6-advanced-filter.html.md)
- [6.7 SUBTOTAL आणि AGGREGATE](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-7-subtotal-and-aggregate.html.md)
- [6.8 Subtotal command — प्रत्येक groupखाली summary](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-8-the-subtotal-feature.html.md)
- [6.9 Group आणि Outline — details हवे तेव्हा उघडा](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/6-9-group-and-outline.html.md)
- [6. Excel Tables, Sorting आणि Filtering](https://ravindrabagale.com/mr/excel/ch06-tables-sorting-and-filtering/index.html.md)
- [7.1 पहिली PivotTable बनवूया](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-1-creating-a-pivottable.html.md)
- [7.10 GETPIVOTDATA — स्थिर KPI references](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-10-getpivotdata.html.md)
- [7.11 PivotCharts — summaryचा chart](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-11-pivotcharts.html.md)
- [7.2 Rows, Columns, Values आणि Filters](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-2-field-areas-rows-columns-values-and-filters.html.md)
- [7.3 Summarize Values By — Sum की Count?](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-3-summarize-values-by.html.md)
- [7.4 Show Values As — share, growth आणि running total](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-4-show-values-as.html.md)
- [7.5 Dates आणि numbersचं grouping](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-5-grouping-dates-and-numbers.html.md)
- [7.6 Calculated fields आणि calculated items](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-6-calculated-fields-and-calculated-items.html.md)
- [7.7 Pivot sorting, filters आणि Top N](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-7-sorting-filtering-and-top-10.html.md)
- [7.8 Slicers आणि Timelines](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-8-slicers-and-timelines.html.md)
- [7.9 Report Connections, Refresh आणि Data Source](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/7-9-report-connections-refresh-and-data-source.html.md)
- [7. PivotTables आणि PivotCharts](https://ravindrabagale.com/mr/excel/ch07-pivottables-and-pivotcharts/index.html.md)
- [8.1 Chart तयार करा आणि नीट format करा](https://ravindrabagale.com/mr/excel/ch08-charts/8-1-creating-and-formatting-a-chart.html.md)
- [8.10 Filled Map chart](https://ravindrabagale.com/mr/excel/ch08-charts/8-10-map-chart.html.md)
- [8.11 Sparklines — cellमध्ये छोटा trend](https://ravindrabagale.com/mr/excel/ch08-charts/8-11-sparklines.html.md)
- [8.12 प्रश्नानुसार योग्य chart निवडा](https://ravindrabagale.com/mr/excel/ch08-charts/8-12-choosing-the-right-chart.html.md)
- [8.13 Tableवरचा dynamic chart](https://ravindrabagale.com/mr/excel/ch08-charts/8-13-dynamic-chart-from-a-table.html.md)
- [8.14 Dropdownने बदलणारा chart — INDEX / XLOOKUP](https://ravindrabagale.com/mr/excel/ch08-charts/8-14-drop-down-driven-dynamic-chart-index-xlookup.html.md)
- [8.15 OFFSET आणि INDEXने rolling chart](https://ravindrabagale.com/mr/excel/ch08-charts/8-15-named-ranges-with-offset-rolling-charts.html.md)
- [8.16 Checkboxने series दाखवा किंवा लपवा](https://ravindrabagale.com/mr/excel/ch08-charts/8-16-checkbox-to-show-hide-a-series.html.md)
- [8.2 Column आणि Bar charts](https://ravindrabagale.com/mr/excel/ch08-charts/8-2-column-and-bar-charts.html.md)
- [8.3 Line आणि Area charts](https://ravindrabagale.com/mr/excel/ch08-charts/8-3-line-and-area-charts.html.md)
- [8.4 Pie आणि Doughnut charts](https://ravindrabagale.com/mr/excel/ch08-charts/8-4-pie-and-doughnut-charts.html.md)
- [8.5 Combo chart आणि secondary axis](https://ravindrabagale.com/mr/excel/ch08-charts/8-5-combo-chart-with-a-secondary-axis.html.md)
- [8.6 Scatter chart — दोन numbersमधला संबंध](https://ravindrabagale.com/mr/excel/ch08-charts/8-6-scatter-chart.html.md)
- [8.7 Histogram आणि Box & Whisker](https://ravindrabagale.com/mr/excel/ch08-charts/8-7-histogram-and-box-and-whisker.html.md)
- [8.8 Waterfall आणि Funnel](https://ravindrabagale.com/mr/excel/ch08-charts/8-8-waterfall-and-funnel.html.md)
- [8.9 Treemap आणि Sunburst](https://ravindrabagale.com/mr/excel/ch08-charts/8-9-treemap-and-sunburst.html.md)
- [8. Charts — dataचा मुद्दा स्पष्ट दाखवा](https://ravindrabagale.com/mr/excel/ch08-charts/index.html.md)
- [9.1 Spill range आणि # operator](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-1-spill-ranges-and-the-operator.html.md)
- [9.2 FILTER — formulaने हवी ती rows](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-2-filter.html.md)
- [9.3 SORT आणि SORTBY](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-3-sort-and-sortby.html.md)
- [9.4 UNIQUE — distinct आणि exactly once](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-4-unique.html.md)
- [9.5 SEQUENCE आणि RANDARRAY](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-5-sequence-and-randarray.html.md)
- [9.6 LET — formulaच्या भागांना नाव द्या](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-6-let.html.md)
- [9.7 LAMBDA — स्वतःचं reusable function](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-7-lambda-brief.html.md)
- [9.8 VSTACK आणि HSTACK](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-8-vstack-and-hstack.html.md)
- [9.9 CHOOSECOLS, TAKE आणि DROP](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/9-9-choosecols-take-and-drop.html.md)
- [9. Dynamic Arrays — एका formulaमधून पूर्ण list](https://ravindrabagale.com/mr/excel/ch09-dynamic-arrays/index.html.md)
- [10.1 Excel किंवा CSVमधून Power Queryमध्ये data आणा](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-1-opening-power-query-data-from-a-workbook-or-csv.html.md)
- [10.2 Power Queryमधले cleaning steps](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-2-cleaning-steps-in-power-query.html.md)
- [10.3 Folderमधले monthly bank statements combine करा](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-3-get-data-from-folder-combining-monthly-bank.html.md)
- [10.4 Append — Tables एकाखाली एक](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-4-append-blinkit-amazon-now.html.md)
- [10.5 Merge — keyवर details जोडा](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-5-merge-queries.html.md)
- [10.6 Unpivot — monthly columnsच्या rows](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-6-unpivot.html.md)
- [10.7 Group By — reusable summary Table](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-7-group-by.html.md)
- [10.8 Parameters — path किंवा value एकाच ठिकाणी बदला](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-8-parameters.html.md)
- [10.9 Load options आणि Refresh](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/10-9-refresh-and-load-options.html.md)
- [10. Excelमधलं Power Query](https://ravindrabagale.com/mr/excel/ch10-power-query-in-excel/index.html.md)
- [11.1 Goal Seek — targetसाठी लागणारा input](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/11-1-goal-seek.html.md)
- [11.2 Scenario Manager — input sets सेव्ह करा](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/11-2-scenario-manager.html.md)
- [11.3 One-variable Data Table](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/11-3-one-variable-data-table.html.md)
- [11.4 Two-variable Data Table](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/11-4-two-variable-data-table.html.md)
- [11.5 Solver — constraintsमध्ये सर्वोत्तम combination](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/11-5-solver-brief.html.md)
- [11. What-If Analysis — input बदलला तर काय?](https://ravindrabagale.com/mr/excel/ch11-what-if-analysis/index.html.md)
- [12.1 Developer tab, macro settings आणि .xlsm](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-1-developer-tab-macro-security-and-xlsm.html.md)
- [12.10 For, For Each आणि Do loops](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-10-loops-for-for-each-and-do.html.md)
- [12.11 Last row आणि last column](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-11-finding-the-last-row-and-column.html.md)
- [12.12 Practical macros — code वाचा, मग copyवर तपासा](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-12-practical-macros-on-our-data.html.md)
- [12.13 UDF — worksheetमध्ये वापरायचं स्वतःचं function](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-13-user-defined-functions-a-delivery-fee-function.html.md)
- [12.14 On Error आणि cleanup](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-14-error-handling-with-on-error.html.md)
- [12.15 Debugging — प्रत्येक lineचा result पाहा](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-15-debugging-f8-breakpoints-immediate-and-locals.html.md)
- [12.16 PERSONAL.XLSB — स्वतःचे रोजचे macros](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-16-the-personal-macro-workbook.html.md)
- [12.2 Macro record करा — absolute की relative?](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-2-recording-a-macro-absolute-vs-relative.html.md)
- [12.3 Macro button, shortcut आणि dialogमधून चालवा](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-3-running-macros-button-shortcut-and-the-macros.html.md)
- [12.4 VBA Editor ओळखा](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-4-the-vba-editor-vbe.html.md)
- [12.5 Sub procedure — काम करणारा macro](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-5-sub-procedures.html.md)
- [12.6 Variables आणि data types](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-6-variables-and-data-types.html.md)
- [12.7 Range, Cells आणि Worksheets](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-7-range-cells-and-worksheets.html.md)
- [12.8 MsgBox आणि InputBox](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-8-msgbox-and-inputbox.html.md)
- [12.9 If आणि Select Case](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/12-9-if-and-select-case.html.md)
- [12. Macros आणि VBA — repeat होणारं काम automate करा](https://ravindrabagale.com/mr/excel/ch12-macros-and-vba/index.html.md)
- [13.1 Dashboard आधी कोणासाठी आणि कशासाठी?](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-1-planning-audience-questions-and-kpis.html.md)
- [13.2 Data, Calc आणि Dashboardची मांडणी](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-2-structuring-the-workbook-data-calc-dashboard.html.md)
- [13.3 Dashboardसाठी PivotTables](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-3-pivottables-that-feed-the-dashboard.html.md)
- [13.4 Live KPI cards](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-4-kpi-cards.html.md)
- [13.5 Dashboard charts](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-5-charts-for-the-dashboard.html.md)
- [13.6 सर्व संबंधित Pivotsना slicers जोडा](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-6-slicers-and-a-timeline-for-all-pivots.html.md)
- [13.7 Dashboard layout आणि readability](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-7-layout-and-design-principles.html.md)
- [13.8 Refresh आणि final checks](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/13-8-refresh-finishing-touches-and-a-checklist.html.md)
- [13. Excel Dashboard — शिकलेलं एकत्र वापरूया](https://ravindrabagale.com/mr/excel/ch13-excel-dashboards/index.html.md)
- [14.1 Input cells unlock करा, मग Protect Sheet](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-1-locked-cells-and-protect-sheet.html.md)
- [14.10 Comments आणि Notes](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-10-comments-vs-notes.html.md)
- [14.11 Version History — जुनं काम परत पाहा](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-11-version-history.html.md)
- [14.2 Formulas hide करा आणि edit ranges ठरवा](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-2-hiding-formulas-and-allow-edit-ranges.html.md)
- [14.3 Structure protection आणि file encryption](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-3-protect-workbook-structure-vs-encrypt-with.html.md)
- [14.4 Print Area आणि page breaks](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-4-print-area-and-page-breaks.html.md)
- [14.5 Orientation, scaling आणि margins](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-5-page-setup-orientation-scaling-and-margins.html.md)
- [14.6 Headers आणि footers](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-6-headers-and-footers.html.md)
- [14.7 Print Titles — प्रत्येक pageवर headers](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-7-print-titles-repeat-header-rows.html.md)
- [14.8 Excel reportचा PDF](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-8-exporting-to-pdf.html.md)
- [14.9 Sharing आणि co-authoring](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/14-9-sharing-and-co-authoring.html.md)
- [14. Protection, Sharing आणि Printing](https://ravindrabagale.com/mr/excel/ch14-protection-sharing-and-printing/index.html.md)
- [15.1 Project brief आणि fictional data](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-1-project-brief-and-data.html.md)
- [15.2 Stage 1 — raw export clean करा](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-2-stage-1-clean-the-raw-export.html.md)
- [15.3 Stage 2 — named Tables आणि lookups](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-3-stage-2-tables-and-lookup-formulas.html.md)
- [15.4 Stage 3 — पाच प्रश्नांसाठी analysis](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-4-stage-3-pivottable-analysis.html.md)
- [15.5 Stage 4 — final dashboard](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-5-stage-4-build-the-dashboard.html.md)
- [15.6 Stage 5 — Refresh आणि PDF macro](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-6-stage-5-a-small-macro.html.md)
- [15.7 Submission checklist आणि marking](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/15-7-submission-checklist-and-marking-guide.html.md)
- [15. Final Project — Maharashtra Monthly Report](https://ravindrabagale.com/mr/excel/ch15-final-project-blinkit-maharashtra-monthly-report/index.html.md)
- [16.1 Basics आणि Data Entryचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-1-modules-1-2-basics-and-data-entry.html.md)
- [16.10 What-Ifचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-10-module-11-what-if-analysis.html.md)
- [16.11 VBAचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-11-module-12-macros-and-vba.html.md)
- [16.12 Dashboardचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-12-module-13-dashboards.html.md)
- [16.13 Protection आणि Printingचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-13-module-14-protection-and-printing.html.md)
- [16.14 Mixed scenarios](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-14-mixed-scenario-exercises.html.md)
- [16.15 Challenge exercises](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-15-challenge-exercises.html.md)
- [16.2 Formulas आणि Functionsचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-2-module-3-formulas-and-functions.html.md)
- [16.3 Lookupsचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-3-module-4-lookups.html.md)
- [16.4 Data Cleaningचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-4-module-5-data-cleaning.html.md)
- [16.5 Tables, Sorting आणि Filteringचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-5-module-6-tables-sorting-and-filtering.html.md)
- [16.6 PivotTablesचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-6-module-7-pivottables.html.md)
- [16.7 Chartsचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-7-module-8-charts.html.md)
- [16.8 Dynamic Arraysचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-8-module-9-dynamic-arrays.html.md)
- [16.9 Power Queryचा सराव](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/16-9-module-10-power-query.html.md)
- [16. Practice Exercises — आधी प्रयत्न, मग hint](https://ravindrabagale.com/mr/excel/ch16-practice-exercises-with-answer-hints/index.html.md)
- [17.1 Basics आणि References — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-1-basics-and-references.html.md)
- [17.2 Functions आणि Formulas — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-2-functions-and-formulas.html.md)
- [17.3 Lookups — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-3-lookups.html.md)
- [17.4 Cleaning आणि Preparation — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-4-data-cleaning-and-preparation.html.md)
- [17.5 Tables, Pivots आणि Charts — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-5-tables-pivottables-and-charts.html.md)
- [17.6 Performance, Dashboard आणि Power tools](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-6-performance-dashboards-and-power-tools.html.md)
- [17.7 Macros आणि VBA — interview answers](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-7-macros-and-vba-basics.html.md)
- [17.8 Scenario questions — approach आणि verification](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/17-8-scenario-based-questions.html.md)
- [17. Interview questions — समजून उत्तर द्या](https://ravindrabagale.com/mr/excel/ch17-interview-questions-and-answers/index.html.md)
- [19.1 Excel for Windows — Keyboard shortcuts](https://ravindrabagale.com/mr/excel/ch19-keyboard-shortcuts-and-function-cheat-sheet/19-1-keyboard-shortcuts-excel-for-windows.html.md)
- [19.2 Function Cheat Sheet](https://ravindrabagale.com/mr/excel/ch19-keyboard-shortcuts-and-function-cheat-sheet/19-2-function-cheat-sheet.html.md)
- [19. Shortcuts आणि Function Cheat Sheet](https://ravindrabagale.com/mr/excel/ch19-keyboard-shortcuts-and-function-cheat-sheet/index.html.md)
- [20. Excel Glossary — शब्दांचा सोपा अर्थ](https://ravindrabagale.com/mr/excel/ch20-glossary/index.html.md)
- [हा Marathi Excel course कसा शिकायचा?](https://ravindrabagale.com/mr/excel/how-to-read-this-book/index.html.md)
- [Excel — मराठी lessons](https://ravindrabagale.com/mr/excel/index.html.md)