When you hear the term “Microsoft Excel”, you may automatically think of number-crunching careers like accounting or finance. But you could potentially use it in other fields as well to transform your data into a business decision or to maintain a simple to complex database in an easy & faster manner or analyze the data with graphs, pivot table or macro. Excel training can help organization to improve the productivity and efficiency. It can manage huge amount of transactions and data with the help of hyperlinks, lookup and advanced formulas. In nutshell, excel is a powerful application which can make your tasks easier, faster and secured.
The course is designed for the working class who have basic knowledge in MS Excel and wish to be master in it. It will cover the intermediate & advanced modules i.e. Formula, Graphs, Security, Pivot Table, Macro, Dashboard, Security, Validation etc. It has been a very widely applied spreadsheet. Excel is a part of Microsoft Office.
We follow a blended learning methodology with case-based hands-on training. The course coverage is given below-
| Course Coverage |
|
Trainer's Profile |
- Linking Workbooks
- Data Consolidating
- Combining & Extracting Text
- Absolute Cell Refs
- Nested IF(Including AND, OR)
- Count if
- Sumif
- Practice & Solution.
- Data Formatting
- Apply Name range
- Table Format
- Sparklines
- Advance filter & Sorting
- Conditional Formatting
- Remove Unwanted Spaces (TRIM, CLEAN)
- Pivot Table
- Pivot Chart
- Slicer
- Advanced Charting
- Lookup Function
- Solver
- Macro
- VBA
- Dashboard Design
- Protecting Workbooks and Worksheets
- Power Pivot
- Power Query
|
|
 |
Md. Nazmul Muneer is a Microsoft Certified Professional “Microsoft Excel (Excel and Excel 2019)” and also obtained the prestigious Certificate from Microsoft “Microsoft Certified Trainer (MCT)”.
Md. Nazmul Muneer is one of the key contributors in the Accounts & Finance department of Beximco Pharmaceuticals Ltd. with 12+ years job experience and has previous work experience in Energypac Power Generation Ltd. Mr. Muneer also works as a freelance Excel automation consultant and Facilitator. In the last few years, he has conducted more than 350 professional Excel training programs in many national and multinational corporate houses and educated in Excel more than 7,000 participants through effective training.
He is expertise in Power BI, developing automated formula-based Excel dashboard, VBA/Macro based Excel application, strategic business model, various problem-solving calculators, What-if Analysis model, data analysis dashboard using Business Intelligence (BI) tools, KPI automation etc.
Mr. Muneer has obtained educational experience in two different disciplines. He is a post graduate in Accounting and has a Diploma in Professional Software Engineering. These have enabled him to acquire vast IT knowledge on developing Database Software, Advanced Excel with VBA, Access with programming, VB, SQL server, Crystal report, IBM AS/400, ORACLE E-Business Suit functional and implementation, etc.
|
| Course Schedule |
Duration: 14 Hours
|
| Course Fee & Payment Mode |
Fee:
BDT 3,750+VAT
Payment Options: 1. bKash: 01738442377
2. Bank:
MEEK Technologies Ltd.,
A/C: 7022-0212000985,
Trust Bank Ltd,
Millennium Corporate Branch,
Dhaka.
|
| Contact Us |
Phone: 01910607050, 01738442377
email: meektechnologies@gmail.com
|
| Register Now |
| |
|