Reporting Automation with Microsoft Excel training centre in Bangladesh

Get 20% discount

Reporting Automation with Microsoft Excel

  • Date : Friday, March 23, 2018
  • Duration : Day(9.30 AM-5.30 PM)
  • No. of Classes/ Sessions : Day Long
  • Last Date of Registration : 22 March, 2018
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 20% Discount at bKash or Online Payment, Seats are Limited



This training program builds upon advanced level knowledge and skills of Microsoft Excel 2016 sets you on the road to creating dynamic reports, dashboard, macros as well as discover the power of nesting functions. Reduce work load and reporting errors by creating and modifying macros is our main objective.


Upon successfully completion of this training, participants will be able to create dynamic reports and dashboard along with modifying macros.


Our training program assure you to implement the knowledge that we transfer to you. We strictly follow KSA process. K – Knowledge, S – Skill & A – Ability


Hands on training with practice sessions.

Contents of Training:

Excel data visualization and data tools
Cells referencing or addressing
Custom number formatting
Custom date formatting
Conditional formatting

Microsoft Excel functions
IF, And, Or function
Match, Search function
Sumifs, Countifs, Averageifs function
Lookup, Vlookup function
Indirect, Offset function
Edate, Eomonth, Weeknum function
Forecast, Trend, Growth function
Precedent and dependent

Microsoft Excel PivotTables
Creating and pivoting PivotTables
Summarizing PivotTable data
Managing subtotals and grand totals
Using PivotTable data in a formula
Sorting and Filtering PivotTable Data
Formatting PivotTables
Visualization using Slicer and Timeline
Grouping PivotTable data
Using formulas in PivotTable

Microsoft Excel Charts or Graphs
Excel chart elements
Plotting secondary axis in chart
Excel charts customization
Creating charts using custom template

Microsoft Excel macros & VBA
What is macro?
Trace developer tab
Macro recording
Excel VBA editor
Excel VBA dot notation
Excel VBA methods
Excel VBA range properties
Adding buttons
Assigning macros to a button
Excel VBA active cell properties

Dynamic reports and dashboard
Static and dynamic data
Dynamic reports stand for
Automated report creation for Daily, Weekly, Monthly, Quarterly and Yearly
Exercise of dynamic Dashboard

Mail merge using MS Excel
Mail merge stands for
Mail merge process

Wrapping up the session
Top Tips
Open Forum
Evaluation and follow-up
*** Queries excluding above mentioned list will be entertained based on available time.

Related Courses

Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 18 Mar - 16 Apr 2018

Muhammad Arif-ur-Rahman
  • 20 Mar - 3 Apr 2018

If you are a new comer in Excel or after all these years of ...

Price 6,000 Tk + VAT
Muhammad Arif-ur-Rahman
  • 21 Mar - 2 Apr 2018

SPSS Statistics is a GUI and syntax based statistical ...

Price 10,000 Tk + VAT
Mahadi Hasan Sagor
  • 22 Mar - 17 Apr 2018

This Course Facebook Marketing for Professionals is an ...

This training is intended for a person who has experience working with Microsoft Excel and would like to learn more about creating dynamic reports and dashboards which Increase one’s productivity as well as reduce work load and reporting errors by creating and modifying macros.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Resource Person

Mostofa Monower, MCP, MCSAM

Analyst, Contact Experience, CSD Robi Axiata Limited

Mostofa is a Microsoft Certified Professional (MCP) and Microsoft Certified System Administrator with Messaging (MCSAM). He has been completed on Cisco Certified Network Associate (CCNA) form American International University (AIUB). Other courses that he has completed and specialized are Red Hat Certified Engineer (RHCE), ComTIA A+, ComTIA Network+, and International Computer Driving License (ICDL).
Mr. Mostofa Monower has over 9 years of working experiences in Network Infrastructure, Workforce Management and MIS reporting. He has started his career with Gemcon Group in early 2007 and also has working experience with TK Group as System Administrator. Currently he is working as Analyst, Contact Experience, CSD in Robi Axiata Limited. He is proficient of creating dynamic MIS Reports, templates, dashboards and maintaining database. He has excellent knowledge in Microsoft Office, especially in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook and Microsoft Word. He has been providing training on Microsoft office package since 2011. He has given consultancy to develop reporting systems for some renowned organizations of Bangladesh. He is dedicated to develop and improve professional skills and unlock resource potential in order to increase efficiency and productivity.

Hands on training with practice sessions.