"এক্সেল পাঠশালা"র হাতে কলমে "MICROSOFT EXCEL"

img
CENTRE FOR DIGITAL 5Days

"এক্সেল পাঠশালা"র হাতে কলমে "MICROSOFT EXCEL"

Course Information

Description

MODULE -1:

Getting familiar with Excel window; Managing Excel professionally; Managing data in Excel; Page setup & printing techniques; Formula writing techniques in easiest way; Start working with most using basic functions; Magic of $ (dollar sign) sign in formula; Data conversion from unusable data to usable data; Use Essential Functions for Restructuring data; IF condition with AND, OR; Using custom NAME in Excel; VLOOKUP and HLOOKUP with other conditions; Date functions and date conversions; Data Validation and controlling data; Excel protection and managing sheets; Handling big data in Excel easily; Amazing Conditional Formatting; Data sorting & filtering in different way; ERRORS - When and how it happens and managing; Data linking with other Sheets/Excel workbooks; PivotTable, PivotChart and Slicer; COUNTIFS, SUMIFS – Build your automated summary report; Data consolidation from multiple sheets; Creating charts in Excel.

MODULE -2:

Knowing Excel and Start Working; Cell Reference (Absolute Vs Relative); Lookup and References; Data Summarizing Techniques; Most Using Essential Functions for Data Structuring; Bullet Proofing Your Reports and Workbook; What-If Analysis (Goal Seek, Data Table, Solver, Scenario; Describe Your Data Using PivotTable with Slicers and PivotChart; Dynamic Graphic Presentation; Decorate Your Report Using Advanced PivotChart; Dynamic Graphic Presentation; Decorate Your Report Using Advanced Conditional Formatting; Excel VBA and Macro; Error Handling Techniques.

MODULE -3:

Advanced use of Excel to Dashboard Reporting.

Key Facilitators:

Leading Excel Automation Expert and Professional Trainers of Bangladesh.

Who Can Join !

Fresh Graduate/New joiners/ Interns/ Management Trainee/Young Professional

Course Outline

Title Course Time Spent Time Status
1. Topic 1 00:00 00:00 Waiting
2. Topic 2 00:00 00:00 Waiting
3. Topic 3 00:00 00:00 Waiting
4. Topic 4 00:00 00:00 Waiting
5. Topic 5 00:00 00:00 Waiting
6. Topic 6 00:00 00:00 Waiting