Deepak EduWorld
About the teacher: Deepak EduWorldTeacher के बारे में: Deepak EduWorld
Deepak EduWorld: Excel VBA macros and spreadsheet automation fundamentals.
Hindi practical tutorials demonstrating Excel macro operations. Suits: Excel users and beginners learning spreadsheet automation.
Deepak EduWorld के videos YUNOVA पर Accounting, AI Tools & Prompting, Data Analysis Fundamentals आदि सीखने में शामिल हैं।
YUNOVA topics taught with this channel's videosइस channel के videos से पढ़ाए जाने वाले YUNOVA topics
- Monthly profit and the bank balance: reading your own numbers · Accounting
- AI se table mein jawab kaise lein · AI Tools & Prompting
- AI se Excel formula kaise banwayein · AI Tools & Prompting
- AI se Excel formula ka matlab kaise samjhein · AI Tools & Prompting
- AI se CSV file kaise analyse karwayein · AI Tools & Prompting
- AI se spreadsheet kaise analyse karwayein · AI Tools & Prompting
- AI se chart ka matlab kaise samjhein · AI Tools & Prompting
- Data cleaning kya hoti hai · Data Analysis Fundamentals
- Excel mein duplicate kaise hataayein · Data Analysis Fundamentals
- Data ko sahi format mein kaise laayein · Data Analysis Fundamentals
- Excel dashboard kaise banayein · Data Analysis Fundamentals
- Dashboard mein kya dikhana chahiye · Data Analysis Fundamentals
- Rows/columns · Excel for work
- Identifier corruption/leading zeros/scientific notation/15-digit precision · Excel for work
- Formula errors/auditing · Excel for work
- Validation/dropdowns/constraints/error alerts · Excel for work
- Sheet protection/formula locks · Excel for work
- Name Manager/defined names · Excel for work
- Dynamic/dependent dropdowns · Excel for work
- IFERROR/IFNA · Excel for work
- SUMIFS/COUNTIFS/AVERAGEIFS · Excel for work
- INDEX/MATCH · Excel for work
- XLOOKUP · Excel for work
- XLOOKUP vs INDEX/MATCH vs VLOOKUP · Excel for work
- DATE/EOMONTH/DATEDIF/NETWORKDAYS · Excel for work
- Reconcile datasets · Excel for work
- FILTER/SORT/SORTBY/UNIQUE/SEQUENCE/spill · Excel for work
- LET optimization · Excel for work
- Ingest/clean/transform CSV/Excel · Excel for work
- GL/trial balance/chart-of-accounts mapping · Excel for work
- PMT/IPMT/PPMT · Excel for work
- Goal Seek/Solver · Excel for work
- 3-tier dashboard model/KPI cards · Excel for work
- Interactive dashboard/linked slicers/dynamic labels/view protection · Excel for work
- Record/secure/inspect/clean VBA macros · Excel for work
- Range/If/Then/button triggers · Excel for work
- What a macro is · Excel VBA & Macros
- Developer tab · Excel VBA & Macros
- Recording a macro · Excel VBA & Macros
- Using worksheet functions in VBA · Excel VBA & Macros
- Events: Workbook_Open and Worksheet_Change · Excel VBA & Macros
- Consolidating many sheets · Excel VBA & Macros
- Auto filter and copy with VBA · Excel VBA & Macros
- Emailing from Outlook with VBA · Excel VBA & Macros
- Saving sheets as PDF · Excel VBA & Macros
- Reading your own balance sheet and profit and loss · Financial Management
- SUMIFS and COUNTIFS · Google Sheets
- VLOOKUP and XLOOKUP · Google Sheets
- INDEX and MATCH · Google Sheets
- IF, AND and OR · Google Sheets
- Text and date functions · Google Sheets
- Monthly budget tracker · Google Sheets
- Form se quiz kaise banayein · Google Workspace
- Spreadsheets and data with an LLM · LLM Fundamentals
- Inventory and stock · Magento
- Monthly budget kaise banayein · Money & Financial Literacy
- Versioning · MS Office
- Formatting · MS Office
- Data entry · MS Office
- Clean data entry · MS Office
- Basic budget · MS Office
- IF/SUMIF(S) · MS Office
- Text/date functions · MS Office
- XLOOKUP concepts · MS Office
- INDEX/MATCH concepts · MS Office
- PivotTables · MS Office
- Pivot charts · MS Office
- Dates · MS Office
- IF/IFS · MS Office
- COUNTIF(S) · MS Office
- SUMIF(S) · MS Office
- Lookup concepts · MS Office
- PivotTables · MS Office
- Data cleaning · MS Office
- Formulas · MS Office
- Lookups · MS Office
- Dynamic array concepts · MS Office
- Advanced lookups · MS Office
- Expense tracker · MS Office
- Inventory/basic order tracker · MS Office
- Cash-in/cash-out view · MS Office
- Remove duplicates · MS Office
- Monthly MIS · MS Office
- Macros/VBA awareness · MS Office
- Security · MS Office
- When automation is worth it · MS Office
- Product/service deck · MS Office
- Making a monthly budget · Personal Finance
- Tracking expenses on a phone · Personal Finance
- Cutting expenses without strain · Personal Finance
- Slicer kaise lagayein · Power BI
- Dashboard kaise design karein · Power BI
- Finding bad rows in a spreadsheet · Regular Expressions
- Splitting a column with regex · Regular Expressions
- Store reports in Excel · Retail Sales
- Just in time · Supply Chain & Operations
- Excel mein duplicate kaise hataayein · Typing & Data Entry
- Excel mein data kaise clean karein · Typing & Data Entry
- Automated testing concepts · Vibe Coding with AI
- Forms and data entry · Vibe Coding with AI
- Dashboards and lists · Vibe Coding with AI