- Course Price $60.00
- Place Dhanmondi,Dhaka
- Total Students 500
- Course Duration 2 or 5 Days
- Course Start June 25, 2019
- Enrollment Status OPEN FOR REGISTRATIONDOWNLOAD MODULE-1DOWNLOAD MODULE-2
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 & ﬁltering 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.
Knowing Excel and Start Working; Cell Reference (Absolute Vs Relative); Lookup and References; Data Summarizing Techniques; Most Using Essential Functions for Data Structuring; Bullet Prooﬁng 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.
Advanced use of Excel to Dashboard Reporting.
Leading Excel Automation Expert and Professional Trainers of Bangladesh.
Join ! Fresh Graduate/New joiners/ Interns/ Management Trainee/Young Professional
|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|