PROFESSIONAL DEVELOPMENT PROGRAM

 

Note:

-- Lunch, Tea Break & Refreshment will be arranged by the organizer
-- Training Materials will be provided by the organizer
-- Seats are limited and will be served on 'First Come-First Serve' basis
-- Participants will be awarded certificates at the end of the session

Who Should Attend

Regular Excel users, data analyzers, management reporters, project managers, decision makers, financial/business modelers and the professionals who are engaged to prepare periodical reports from various data sources.

Master Class on Dashboard Reporting Using MS Excel



Date : 14 Jan 2017
Time : 10:00AM to 6:00PM
Fee  : 4000.00 BDT
Training venue :
UPDATE
UTC Tower (Ground Floor), 8 Panthapath, Dhaka (Beside Basundhara Shopping Complex)
Training Objective
Overview of this Training:
This one day’s professional workshop will help you through various functions, tools, tips and tricks to boost up your Excel productivity and you will learn how to map and handle big data that will work for you and generate the interactive reports describing the core information professionally. You will also learn how to produce information into a logical framework, summarize it into a meaningful format, and then display the summary into easy-to-read tables and graphs. Then you will be able to build up various types of data model to analyze business more critically using various tools, objects and controls.

Objective of this Training:
You can prepare any kind of report very easily within short time if you have sound knowledge in data mapping, various formula building techniques, direct and indirect linking, data connection, data consolidation and summarization, visual presentation, use of object & controls, dashboard techniques, Business Intelligence (BI) tools, techniques to handle millions of data and Excel’s amazing productive tricks. These wonderful features will definitely enhance your productivity and make your life easy.

Thinking about the above necessities, this professional workshop schedule has been designed so that you can learn the techniques to prepare various types of interactive reports from different types of data sources.

Learning Methodologies
Presentation with Excel 2010 (If you use Excel 2007, 2013, 2016 or mac, no problem; you will get instant guideline)
Hand working with real case study
Completely interactive and participative
Training booklet that will be interactively connected with working files
Problem solving, Practical projects and Brainstorming
Open discussion (Q & A session)
Training Content
INTRODUCTION OF DASHBOARD REPORT IN MS EXCEL
What is Dashboard reportand how to develop?
Components of Dashboard report
Purposes and benefits
Essential rules should be maintained to develop dashboard in Excel
Summary report interaction using various parameters
What to do and what not to do for developing Dashboard report

DATA SUMMARIZATION AND INTERACTION TECHNIQUES
Data summarizing using multiple criteria and conditions
Advanced SUMPRODUCT function
COUNTIFS, SUMIFS and AVERAGEIFS functions
Data summarizing using INDIRECT linking

DASHBOARD PROJECT-1

USING PIVOTTABLES, PIVOTCHARTS AND SLICERS TO DESCRIBE DATA
Data mapping to prepare a PivotTable
Understanding PivotTable Field Lists
Row Labels, column labels, values area, report filter
Fixing PivotTable’s output area
Fixing PivotTable’s data format
Techniques to apply conditional formatting to a PivotTable
Creating PivotChart from existing workbook data
Make your PivotTable data source dynamic
What is slicer in PivotTable?
Creating, linking, changing and formatting slicer
Dashboard techniques using PivotTable Components

DASHBOARD PROJECT-2

ADDING CONTROLS AND LINKING WITH SUMMARY TO INTERACT REPORT DYNAMICALLY
Get introduced with Form Controls
Inserting and Controlling Form Controls
Button, Check Box, Option Button, List Box,
Drop-down, Spin Button and Scroll Bar
Where will you use form controls?
Interaction of tables and graphs using controls
Linking drop-down or option button with summary and charts

DYNAMIC GRAPHICAL OR VISUAL PRESENTATION
Data visualization using Sparklines and charts
Choosing the right chart for your dashboard
Using static and dynamic chart
Make your chart data source dynamic
Creating and customizing layout and design
Special chart (thermometer) for target/growth/progress analysis
Link your chart with drop-down or option button
Interact your chart using various objects

DASHBOARD PROJECT-3

USING ADVANCED CONDITIONAL FORMATTING IN DASHBOARD
Multiple Conditional Formatting-manage rule
Using Data Bars and icons for great presentation
Changing Data Bars and Icons parameter
Formula based Conditional Formatting

PROTECT AND VALIDATE DASHBOARD REPORT AND RAW DATA
Locking and protecting Dashboard report sheet
Restriction incorrect data entry with data validations
Creating list with static values or a dynamic range
Create your dashboard password protected

ERROR HANDLING AND CLEANING DASHBOARD
Error handling techniques in different ways
Formula tracing and debugging techniques
Make your dashboard clean avoiding errors

EXCLUSIVE MASTER PROJECT SESSION TO BUILD AN INTERACTIVE DASHBOARD REPORT
DASHBOARD PROJECT-4

PROBLEM SOLVING AND BRAINSTORMING SESSION AND OPEN DISCUSSION
Share your Excel problems
Open discussion regarding Excel issues
Facilitator(s) Profile
 

MD. NAZMUL MUNEER
Excel Automation Expert & Professional Trainer
  Md. Nazmul Muneer is one of the key contributors in the Accounts & Finance department of Beximco Pharmaceuticals Ltd. with 8 years job experience and has previous work experience in Energypac Power Generation Ltd. Mr. Muneer also works as a freelance Excel automation consultant and trainer. In the last few years he has conducted various professional Excel training programs in many national and multinational corporate houses and educated in Excel more than 1,000 participants through effective training. He is a regular Excel trainer of some leading professional training institutes as a popular Excel trainer. He has also been providing consultation and technical services to different companies in the UK and USA on Excel Automation, helping them to create new processes, reports and streamlines those are already in live environment. He is expertise in developing automated formula based Excel dashboard, macro enabled & VBA based Excel workbook, strategic business model, various problem solving calculators, What-if Analysis model, data analysis dashboard using Business Intelligence (BI) tools, KPI automation etc. Mr. Muneer has obtained educational experience in two different disciplines. He is a post graduate in Accounting and has a Diploma in Professional Software Engineering. These have enabled him to acquire vast IT knowledge on developing Database Software, Advanced Excel with VBA, Access with programming, VB, SQL server, Crystal report, IBM AS/400, ORACLE E-Business Suit as well as various accounting packages.
Registration Details
Registration payment can be made by cash or A/C Payee cheque in favor of Business Express, before January 15, 2017, till 05:51 am

Registration Point
Business Express H:38/A (3rd Floor),R: 9/A Dhanmondi, Dhaka-1209

Mob: 01717801435
E-Mail: businessexpressbd24@gmail.com

Last date of registration: Sunday, 15 Jan 2017
We offer In-House/Customized training on Sales, Leadership, Finance, HR, RMG or any Soft Skill Topics.