Advanced MS Office Excel Essentials

Advanced MS Office Excel Essentials | Weekend Course


– No. of Classes: 04 (Fridays only)
– Duration of Classes: 03 hours (with 15 minutes break)
– There will be pre-assignment and post assignments.
– After each class, there will be assignments for skills practice.
|| Certificate will be awarded after successful completion of the course ||
| Venue: LCBS Dhaka Training Room

Cost: BDT. 5500/- per person (Excl. VAT)
Early bird discount:
For registration, please contact us directly:
Email# training@lcbsdhaka.com
Call# 01792162927

|| Course Overview
This advanced Microsoft Excel 2013 Advanced Essentials course focuses rigorously on developing your expertise on the following functions of MS Excel:
– Advanced formulas and functions
– Named ranges
– Resolving formula errors
– Consolidating data, removing duplicates, configuring data validation, and transposing data
– Using outlining, grouping, and subtotal tools
– Working with scenarios
– Using data analysis tools (such as Solver and Goal Seek)
– Creating and using PivotTables and Pivot Charts
– Using Power Pivot to integrate data from several different sources
– Recording, editing, and using macros
|| Course Outline
Module 1: Advanced Formula Tasks
Module 2: Working with Named Ranges
Module 3: Using Advanced Functions
Module 4: Resolving Formula Errors
Module 5: Managing Data
Module 6: Outlining and Grouping Data
Module 7: Working with Scenarios
Module 8: Using Solver
Module 9: Analyzing Data
Module 10: Advanced PivotTable Features
Module 11: Using PowerPivot
Module 12: Using Macros
Trainer:
MOSTOFA JAMAL CHOWDHURY

Mr. Mostofa Jamal Chowdhury is HR professional having
more than 8 years’ experience in different industry.
Presently working in Prime Bank Ltd. as Senior Officer, HR
Training & Development Center. Before joining Prime
Bank Mr. Mostofa worked for AFC Group, Eastern Bank
Ltd. & Ananta Apparels Ltd. in Human Resources.

Obtained BBA from North South University and MBA from
Jahangirnagar University with good academic credential,
and also completed PGHRM.

During professional journey, Mr. Mostofa is expertise Data
Analytics and developing e-Learning modules. He
conducted Soft Skills, Sales Techniques, Professional
Etiquettes, Employee Orientation and several learning
interventions in his career.

Mr. Mostofa conducted Advance Excel training more than
900 participants for Eastern Bank Ltd., AFC Group
employees, Dhaka University students and others. He is
expert in developing dashboard, pivot table, data analysis,
etc tools in MS Excel.

Registration Link: http://bit.ly/AdvanceMsExcel

For More Details: Tel: 02-9142957-8, Mobile: 01792162927, Hotline: 09678 505050
Address: House: 105, Road: 9/A, West Dhanmondi, (Beside Dhanmondi party center), Dhanmondi, Dhaka-1209
Subscribe Our YouTube Channel: http://bit.ly/LCBSDhaka
Visit Our Website: https://www.lcbsdhaka.com