৩০ মিনিটের কাজ ৩ মিনিটে শেষ করতে চান? Excel এর বস হতে চান? Qlearn 2026 - New Course
Автор: Qlearn
Загружено: 2026-01-06
Просмотров: 93
Описание:
🟩 কোর্সের ধরন ➡ লাইভ কোর্স
▶️ ক্লাসের সংখ্যা ➡ ১৫টি
🔓 কোর্স এক্সেস ➡ কোর্সটি কেনার পর থেকে ২ বছর পর্যন্ত দেখতে পারবেন (যতবার ইচ্ছা)
✅কোর্সটি থেকে যা যা শিখবেন
I. Excel Fundamentals & Data Management
Core skills for efficient data entry, organization, and collaboration
▸ Productivity: Essential Keyboard Shortcuts
▸ Data Handling: AutoFill, Flash Fill, Transpose, Skip Blanks
▸ Workbook Management: Freeze Panes, Split, Group Sheets, Data Consolidation
▸ Formatting: Custom Number Formats, Fractions, Format Painter, Merge & Wrap Text
▸ Data Validation: Date & Budget Controls, Drop-down and Dependent List
▸ Output & Security: Print Titles/Area, PDF Export, OneDrive Sharing, Sheet Protection
II. Advanced Formulas & Functions
Building powerful and dynamic calculations
▸ Lookup Functions: VLOOKUP, INDEX–MATCH, XLOOKUP, Two-way & Case-sensitive Lookup
▸ Logical Functions: IF, IFS, SWITCH, AND, OR
▸ Aggregation: COUNTIF, SUMIF, SUMPRODUCT
▸ Text Functions: Text to Columns, Case Conversion, Trim, Concatenation
▸ Date & Time: Age Calculation, Date Difference, Month-End Calculations
III. Data Analysis & Visualization
Turning data into insights and reports
▸ Advanced Filtering: Custom Sort, Color Sort, Advanced Filter, Remove Duplicate
▸ Data Structuring: Excel Tables, Structured References
▸ Pivot Tables: Multi-level Pivots, Grouping, Calculated Fields, Slicers
▸ Conditional Formatting: Data Bars, Color Scales, Heat Maps
▸ Charts: Combo Charts, Gantt Charts, Pareto Charts, Sparklines
IV. Analytics, Modeling & Optimization
Financial, statistical, and decision analysis
▸ Financial Functions: PMT, NPV, IRR, CAGR, Loan Amortization
▸ Statistics: Descriptive Analysis, Correlation, Regression, ANOVA, t-Test
▸ What-If Analysis: Data Tables, Goal Seek
▸ Solver Optimization: Linear Equations, Transportation & Assignment Problems
V. Automation & Advanced Excel
Modern tools for scalable and efficient workflows
▸ Dynamic Arrays: SORT, FILTER
▸ Advanced Logic: LET, LAMBDA
▸ Automation Basics: Developer Tab Overview
▸ Error Handling: IFERROR, IFNA, Formula Auditing
☎️যেকোনো প্রয়োজনে
09638-441144 (Only Call)
01885-973770 (Call & WhatsApp)
[email protected]
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: