Admission Now
- Skill Level: Beginners
- Duration: 4 Months
- Class Per Week: 2 Day
- Total Class: 32
- Certificate: Yes
- Provide Class Video
- Language: Bangla & English
Overview:
“Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.”
“Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.”
Level 1: Foundations
Getting Started: Navigating the interface, creating workbooks, and entering data.
Basic Calculations: Writing formulas, using basic functions, and reusing formulas.
Worksheet Management: Inserting/deleting cells, rows/columns, and adjusting sheets.
Formatting: Fonts, borders, number formats, styles, themes, and basic conditional formatting.
Printing & Large Workbooks: Page layout setup, managing multiple worksheets, and workbook views.
Level 2: Intermediate
Customization: Configuring Excel options, customizing the Ribbon and Quick Access Toolbar.
Advanced Formulas: Using range names, specialized functions, and array formulas.
Data Analysis: Text and logical functions, advanced conditional formatting.
Data Management: Creating tables, sorting, filtering, and using SUBTOTAL functions.
Visualization: Creating and formatting basic charts.
PivotTables: Building PivotTables, using slicers, and creating Pivot Charts.
Level 3: Advanced
Multi-Workbook Management: Using 3-D references, external links, and data consolidation.
Protection & Sharing: Protecting worksheets/workbooks and collaborating.
Automation: Data validation, form controls, and introductory macros.
Advanced Functions: Lookup functions (VLOOKUP, etc.), combining functions, and conditional formatting with formulas.
Auditing: Tracing cell relationships, error checking, and evaluating formulas.
What-If Analysis: Data tables, scenarios, Goal Seek, and the Solver tool.
Advanced Visualization: Advanced chart features and creating sparklines.
Rowshon Al Mamun