Advanced Certificate Course on Report Writing Management training centre in Bangladesh

New
EMI EASY PAY

Advanced Certificate Course on Report Writing Management

  • Date : 11 - 24 May 2019
  • Duration : Evening(6.30 pm-9.30 pm)
  • No. of Classes/ Sessions : 6 Sessions
  • Class Schedule : Friday & Saturday of every week
  • Total Hours : 18
  • Last Date of Registration : 10 May, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

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.

Methodology

Interactive

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

Related Courses

Israt Jahan
  • Friday, March 22, 2019

Methodology Interactive Lecture, Video clips, Role Play, ...

Next Stage/ Career
Price 1,200 Tk + VAT
Half Day Course
Asif Yeasin Kabir
  • Saturday, March 23, 2019

This workshop has been designed for the Fresh Graduates and ...

Next Stage/ Career
M. Hifzur Rahman
  • 3 - 22 Apr 2019 (6 Sessions)

This course would focus on improving Professional English ...

Next Stage/ Career
Course at Chattogram
Price 2,000 Tk + VAT
Ridwanul Karim Chowdhury
  • Friday, April 5, 2019

The role of a leader starts with a thorough understanding ...

Next Stage/ Career
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.

Resource Person

M. Hifzur Rahman

Research, Communication, Media & Documentation Specialist

Born 1954. Obtained Masters in Economics from the Rajshahi University and was involved in many socio-economic research activities. Hifzur has successfully completed number of training courses e.g. Management and Leadership Development from Australia and other training courses on Environmental Economics, ToT on Security issues and Journalism from Bangladesh and different countries of the world. He has 37 years of writing experience for the national & international organizations and different publication houses.
He completed a Certificate Course on Environmental Economics and Natural Resource Management organized by the World Bank Institute and SANDEE (South Asian Network for Development of Environmental Economics). Hifzur had also completed a ToT (Training of Trainers) recently by a British Development organization Saferworld, UK on peace and security issues and had been selected as a core trainer to impart training on peace and security issues, especially for the journalists. He had been trained at the Bangladesh Institute of Management on Research Methodology under SPSS Windows.

Hifzur served in print media as a senior journalist from 1977 before he joined the Australian High Commission as the Political/Economic Research Officer and served there for about 9 years. While working in the Australian High Commission he was in charge of the Direct Aid Program of the Australian Government in Bangladesh apart from his regular research work on politics and Economy, and also was responsible for Bangladesh National Budget Analysis for about 9 years while served Political/Economic Research Officer of the High Commission.

Later, he had served in a multinational power company LIPPS as a Director (Corporate Affairs). He was in-charge of running the Mymensingh 140 MW Power Station (MPS) as LIPPS was the Operation and Maintenance Contractor of MPS.
He has written numerous articles on socio-economic affaires in Bangla & English, published in national dailies and Weeklies. Hifzur had also developed & written the Country Report 2007-2008 for the then Caretaker Government, while he worked directly with the Chief Adviser Dr. Fakhruddin Ahmed. He has authored about 29 books in Bangla and English. He was also a presenter of a talk-show in ATN Bangla.

Hifzur had done a research for the Saferworld, UK on peace and security issues and also completed 10 FGDs (Focus Group Discussions) throughout the country again for another research project of the Saferworld, UK. He has numerous experiences in project evaluation, monitoring, report & project proposal writing and documentation for NGOs as he was involved with research activities and project management for different UN & International agencies including World Bank ADB & national NGOs. He is also involved with important development agencies e.g. UNICEF, Save the Children, Bandhu and South Asia Partnership-Bangladesh, as a resource person/consultant.

He has visited many countries including Japan, Australia, U.K, United States, Germany, Netherlands, Denmark, Indonesia, Malaysia, Singapore, Hongkong, China, Russia, Thailand, Korea, India, Nepal and Sri Lanka.

FIELD OF EXPERTISE (ISSUES & ACTIVITIES)
Human Rights ; Child Rights ; Women Empowerment ; Gender ; Organizational Development ; Project Planning & Management; Human Resource Development; Professional English Writing Skills; Art of Professional Excellence; Advocacy; Monitoring and Evaluation; Advocacy; Research-Qualitative & Quantitative and Research Methodology; Communication; Documentation; Leadership & Management Development and Team Building; Socio-Economic Development; Human Security; Facilitation and Reporting on Training/Workshops; Media Engagement; Translation both from Bangla & English; Writer/Author.

Interactive