Advanced Certificate Course on Report Writing Management training centre in Bangladesh


Advanced Certificate Course on Report Writing Management


This course is a combination of professional report writing skills and Excel tools.

This course will help participants learn (1) the key concepts, stages, structures of report writing, case study writing, project progress reporting; (2) Excel tools for report writing including data visualization and data tools, functions, PivotTables, Charts or Graphs, macros & VBA, Mail merge and lot more.

How it benefits the participants:

1. A complete package of management and tech-savvy skills that prepare the participants to manage large-scale reports.
2. It saves costs and time to attend two courses separately.



Contents of Training:

Session 01:
1.1. Understanding communication
1.2. Functions of communication and barriers of effective communication
1.3. Value of good written communication
1.4. Understanding reports
1.5. Key concepts of report writing
1.6. Purpose of report
1.7. Scope of report
1.8. Type of reports
1.9. Structure of reports
1.10. Stages of report production

Session 02:
2.1. Effective communication and report writing
2.2. Data collection and analysis for report writing
2.3. How to present information differently: text, graphs, tables, flow charts and diagrams.
2.4. Analyzing audience or reader
2.5. Taylor made report as per organizational need
2.6. Writing case study and success story

Session 03:
3.1. Advanced Report writing skills
3.2. Overcoming writer`s block: subjectivity; objectivity and bias
3.3. Writing of project proposals based and technical reports
3.4. Project progress report templates
3.5. Revising and editing
3.6. Checklist for editing reporting work

Session 04:
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

Session 05:
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

Session 06:
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
High, Mid and Entry level Executives and Managers who are intended for a person who has experience working with Microsoft Excel and would like to learn more about creating Reports and dashboards which Increase one’s productivity as well as reduce work load and reporting errors by creating and modifying macros.