Dynamic MIS Reporting by MS Excel

Dynamic MIS Reporting by MS Excel

The objective of this course is to help the audiences develop their skills and knowledge on MS Excel on the purpose that they can manage their data related tasks more efficiently and productively.

course at a glance

  • Date : 12 Mar - 5 Apr 2022
  • No. of Classes/ Sessions : 12
  • Total Hours : 24
  • Last Date of Registration : 10 Mar 2022
  • Class Schedule :
    • Saturday - 7:00 PM - 9:00 PM
    • Monday - 7:00 PM - 9:00 PM
    • Tuesday - 7:00 PM - 9:00 PM
  • venue : BASIS Institute of Technology & Management (BITM) BDBL Bhaban (3rd Floor - East), 12 Kawran Bazar, Dhaka -1215.

Price: TK. 5,750
(including VAT & TAX)

This training is organized by BITM. Training will be held in BITM.

The objective of this course is to help the audiences develop their skills and knowledge on MS Excel on the purpose that they can manage their data related tasks more efficiently and productively, and add more value to their organization.

Specialties of This Course:

  • Pre and Post assessment will be taken
  • Worksheet along with Practice Sheet will be provided
  • Case Study in relation to the application of different formulas will be solved
  • Collective discussion & interactive session in the following day to complete the assignment given on discussed topics in earlier class
  • Dashboard project will be conducted
  • As post training support, any questions in relation to MS Excel from the attended participants will be responded
  • Each participant will be awarded certificate only when he/she qualifies the assessment

Course Content:





Manage Workbook and Worksheet

a. Manage Workbook: Save a Workbook as Template, Office Theme, Customize Ribbon, Quick Access Toolbar

b. Manage Worksheet: Create a New Sheet, Format Sheet, Move or Copy Sheet, Delete Sheet

c. Navigation: Cell Movement


Commands of Main Tabs

a. Home Tab: Paste, Paste Special, Format Painter, Pattern Fill

Orientation, New Line, Merge Across, Data Formatting, Format

Clear, Fill, Find and Select

b. Insert Tab: Hyperlink

c. Page Layout Tab: Page Set up and Print, Theme

d. Formula Tab: Name Manager, Formula Auditing, Watch Window

e. Data Tab: Filter, Text to Columns, Remove Duplicates, Data Validation, Goal Seek Group by Subtotal

f. View Tab: Navigation, New Window & Arrange All, Freez Panes, Hide and Unhide, Switch Windows


Tips and Notes on Formula, Cell Reference, and Formula Copy

a. Some Important Tips on Excel Formula

b. Some Important Tips on Excel Cell Reference

c. Other Important Notes


Basic Mathematical Calculation

a. Summation, Subtraction, Multiplication, Division, Percentage, Average

b. Simplification Rule

c. Round- Roundup and Rounddown


Let’s Start with Basic Formulas

a. Find Max and Min Value

b. Rank Value in a Range

c. Find Top Largest and Smallest Value

d. Difference between Count and Counta

e. Make SL/Index number using Row and Column Formula


Manipulating Text

a. Setting text to sentence case

b. Flash fill

c. Join text string

d. Removing space from a text string

e. Counting characters in a cell

f. Extracting parts of a text string

g. Finding a particular character

h. Substituting text string

i. Finding similar multiple characters

j. Make Extracting parts of a text string automatic


Conditional Analysis

a. Simple and multiple conditions

b. Logical condition with AND & OR

c. Summing and Counting that meet conditions


Matching and Lookups

a. Looking up on a left lookup column

b. Looking up horizontally

c. Hiding errors returned by lookup functions

d. Looking up on a two-way matrix

e. Looking up by changing the referencing column

f. Looking up from multiple tables

g. Looking up by returning a reference to a range


Array Formulas

a. Finding Large and Small value

b. Transposing in an array

c. Summing in a range

d. Summing Largest and Smallest value in a range

e. Summing in a range that meet conditions

f. Finding Max and Min in an array


Conditional Formatting

a. Highlight cells that meet criteria

b.  Manage rules


Dates and Times

a. Current date and time

b. Extracting parts of a date

c. Text Function

d. Finding Next month and End of Month

e. Make a date

f. Length of Service

g. Find deadline and Working Days



a. Data Sorting

d. Row and column sorting


Data Validation

a. Different validation criteria

b. Input message and Alert criteria

c. Checking duplicate value


Protect Work

a.  Unlock cells

b. Sheet protection options


Making Formulas Error-Free

a. Finding and Correcting Formula Error

b. Formulas returning an error


VBA Macro

a. How to record Macro

b. How to run Macro

c. How to assign Macro

d. Dynamic Advance Filtering



a. Call Macro

b. Protect Coding

c. Unhide multiple sheets


Introducing Pivot Table

a. Creating a Pivot Table

b. Analysing Data with Pivot Table



a.  Creating a Slicer

b. Report Connections


Creating Chart

a. Creating Chart

b. Modifying and designing chart using format task


Dashboard Project

Making a beautiful dashboard


Dynamic MIS Reporting by MS Excel Dynamic MIS Reporting by MS Excel 24 Hrs

Tentative Class Start

12th March, 2022

Available Seat

10 / 20

who can join

  • Anyone who have interested to develop their skills and knowledge on MS Excel. 
  • Must Have Basic computer Knowledge.

Meet the Instructor