Dynamic Reporting, Template, Dashboard and More with MS Excel 2013

  • Date : 01 - 14 April 2017
  • Duration : Evening(6:30 PM-9:30 PM)
  • No. of Classes/ Sessions : 4 evenings
  • Class Schedule : Friday and Saturday
  • Total Hours : 12
  • Last Date of Registration : 30 March, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.


This training program builds upon advanced level knowledge and skills of Microsoft Excel 2013 sets you on the road to creating dashboard, template, 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 because smart worker is always better than hard worker.

In this training we will describe theoretical information via Microsoft PowerPoint presentation. Exercise files is available for practicing which helps you to understand the topics as well as build your confidence for further implementation.

Upon successfully completion of this training, participants will be able to create dynamic reports, templates 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

To ensure your success, you will need to have a comfort level with the basic skills, working with data, functions and formulas. To meet this prerequisite, you can take our basic level training of Microsoft Excel 2013.


The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:

Getting Started
Exploring MS Excel
Cells referencing and addressing
Moving or coping a worksheet
Text wrapping in Excel
Excel key board shortcut
Data modeling concept

Excel Operations
Formatting stands for
Advanced conditional formatting
Advanced data formatting
Advanced date formatting
Remove duplicates
Text to column
Data validation
Importing data from text
Importing data from access

Creating and Pivoting PivotTables
Introducing PivotTables
Formatting data for use in a PivotTable
Creating a PivotTable
Creating a Recommended PivotTable
Pivoting a PivotTable
Configuring a PivotTable
Connecting to an external data source
Consolidating data from multiple sources
Managing PivotTables

Summarizing PivotTable Data
Managing subtotals and grand totals
Changing the data field summary operation
Summarizing more than one data field
Creating a calculated field
Grouping PivotTable fields
Using PivotTable data in a formula
Drilling down to the underlying data

Slicer and Timeline
Basic Description
What are Slicers?
Slicer Features
Using Slicers
Formatting Slicers
Create a Standalone Slicer
Format Slicer
Share a Slicer
Use Slicer From Another Pivot Table
Disconnect or Delete a Slicer
Pivot Table Timeline
Customize a Timeline

Excel Chart or Graphs
MS Excel charts stands for
Select data for a chart
Create an Excel Chart
Excel Chart Elements
Ignoring error or blank cells in chart
Plotting secondary axis in chart
To switch row / column data in chart
Modifying and Customizing Charts

Excel Functions and Formulas
Trim Function
Concatenate Function
Left, Right and Mid Function
Len and Search Function
If, Iferror Function
And, Or Function
Date and Time Function
Edate and Eomonth function
Datedif Function
Hlookup and Vlookup function
Offset and Match function
Sumif, Countif, Averageif function
Sumifs, Countifs and Averageifs function

Playing With VBA
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
Excel VBA Variables
Variables with Math Operators

Playing With Macros
What is Macro?
Trust Center and Macros
Setting up Excel to Allow Macros
Excel Macro Security Setting
Excel Macro Trust Locations
Trace Developer Tab
Macro Recording
Use Relative Reference Option

Dynamic Reports, Templates and Dashboard
Dynamic name range
Static and dynamic data
Dynamic reports stand for
Exercise – 1: Dynamic report
Exercise – 2: Dynamic report
Exercise – 3: Dynamic report
Dynamic templates stand for
Exercise – 1: Dynamic templates
Exercise – 1: Dynamic templates
Dynamic dashboard stand for
Exercise – 1: Dynamic dashboard
Exercise – 2: Dynamic dashboard

Related Courses

Muhammad Arif-ur-Rahman
  • 24 - 25 Feb 2017 (2 Days Long)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

Price 3,000 Tk + VAT
Moshiur Rahman
  • Saturday, February 25, 2017

Advertising on Facebook is easy for you and your customers. ...

Moshiur Rahman
  • 26 Feb - 6 Apr 2017

This course will help you to know how to promote your ...

Samiul Huq
  • 28 Feb - 9 Mar 2017

This course will walk you through the world of business ...



9140345, 9117179


Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

This training is intended for a person who has experience working with Microsoft Excel and would like to learn more about creating dynamic reports, dynamic dashboard, dynamic template and Charts which Increase one’s productivity as well as reduce work load and reporting errors by creating and modifying macros.

Resource Person

Muhammad Arif-ur-Rahman

Management Consultant, Trainer and Speaker

Muhammad Arif-ur-Rahman is an independent consultant having expertise on traditional and Islamic finance, Accounting Information System, Cost Accounting, Management Information System, Project Management, Data Driven Business Research, Quality Management, Business Process Outsourcing, Business Deve.....

Courses from this trainer 189

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.