Microsoft Excel Dashboard and Reporting Techniques training centre in Bangladesh

New

Microsoft Excel Dashboard and Reporting Techniques

  • Date : 06 - 07 August 2021
  • Duration : Evening(7:00 PM-10:00 PM)
  • No. of Classes/ Sessions : 2 Sessions
  • Class Schedule : Friday & Saturday
  • Total Hours : 6
  • Last Date of Registration : 4 August, 2021 ( within 5pm )
  • Venue : Online Virtual
  • (10% Off on Bkash or Online payment)

Introduction

Microsoft Excel has proven to be advantageous for day to day business activities. The knowledge of Microsoft Excel particularly in analyzing data and reporting has become essential for every company to carry out day to day business and reap the best results.

Reporting in Excel is the most vital role for every manager especially in Business Analysis, People Management, Managing Operations, Performance Reporting, Office Administration, Strategic Analysis, Project Management, Managing Programs, Production / Manufacturing, Contract Administration, Sales / Profit Center / Cost Center / Accounts Management, etc.

Reporting in Excel using Dashboard: A dashboard is an information management tool that is used to track KPIs, metrics, and other key data points relevant to a business, department, or specific process. Using data visualizations, dashboards simplify complex data sets to provide users with at a glance awareness of current performance. An Excel dashboard is one-pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. It contains charts/tables/views that are backed by data. A dashboard is often called a report, however, not all reports are dashboards. Moreover, a dashboard is a communication platform that displays key reports in a single presentation.

Excel is widely used. Having good spreadsheet skills therefore gives you the ability to work on all sorts of different tasks. And you can more easily get value out of information that’s being shared in workbooks. Once you know how to use Excel, you’ll find yourself using it more and more. It’s an accessible platform that can be used to do both simple and highly sophisticated business tasks.

Methodology

Live class via ZOOM, Interactive class

Contents of Training:

Content / What You’ll Learn…
• How to automate a Report in Excel
• Reporting using Excel Functions
• Sumifs
• Countifs
• Magical Formula to Generate Reports from Calendar Years (January to December) to Financial Years (July to June) automatically
• Reporting Without !!! Excel Function / Formula using Excel Built-in Tools (Smart Reporting Tools without knowing any formula)
• Subtotal
• Pivot Table
• Pivot Chart
• Generate Reports automatically using Excel Tools for Subtotal, Min, Max, Average • Dig down Reports with the variables for example, company name, division, departments, profit center, cost center, location, job positions, etc. • How to make an Excel spreadsheet look like a report
• Introducing Excel Dashboards for Management Reporting
• How to build a Well-Designed and Interactive Excel Dashboard
• Design Tips for Better Excel Reports & Dashboards

Related Courses

Syed Saniat Ahmmad
  • 11 - 25 Aug 2021 (5 Sessions)

Practical examples, exercises & case studies with ...

IT
Rony Saha
  • 29 Aug - 7 Sep 2021

This Power BI course is best suited for Business ...

IT
Price 3,000 Tk + VAT
Engr. Mohammad Hasibul Haque
  • 30 Aug - 8 Sep 2021

he goal of the course is to increase knowledge and ...

IT
Syed Saniat Ahmmad
  • 9 - 21 Sep 2021 (4 Sessions)

Practical examples, exercises & case studies with ...

IT
Who Should Participate…
◻Anyone who is involve in reporting: Sales, Marketing, Manufacturing / Production Managers, Compensation & Benefits / Training / HR Professionals, Administrative Managers, Accountants, Supply Chain / Procurement / Store / Warehouse Managers, Auditors, Professors, Teachers, Teaching Assistants, Project coordinators, project and construction managers, bankers, financial analysts, Market researchers, Business and Management Analysts
◻Managers and Directors, CEOs and business executives
◻Professionals seeking advancement to managerial position

Resource Person

Md. Feroz Kibria

Soft Skills Trainer Specialist, Human Resources

Md. Feroz Kibria has been involved in training, coaching and consulting for more than 10 years with the intention of dramatically increasing profit, productivity and the performance of people.

After completing his MBA & BBA in HR & Accounting, Feroz joined the corporate world and gaining experience in Human Resources Management and training in diversified industries e.g. Telecommunications, Networking Accessories, Customer Services, Engineering and Automobiles.

He also completed a certificate course on “People Management Skills for Professionals (PMSP)” from IBA, University of Dhaka under MDP (Management Development Program).

Through the experience from the local and multinational businesses operating in Bangladesh, Feroz has gained a versatile knowledge for the requirement of core development areas to build the strongest career.

Today, Feroz trains a wide range of Soft Skills like Microsoft Office Programs (Excel, PowerPoint, Access, Publisher, Visio, Word, Outlook and others), Time Management, Strategic Compensation & Benefits, Financial Modeling, Leadership & Team Building, Corporate Etiquettes, etc.

Feroz is passionate in inspiring lives and transforming people. Because of the dedication, he is well known for his energetic and power-packed training sessions.

His quest for continuous Human & Talent Development promises highly energizing and power-packed training style. He helps clients transferring knowledge into ready-to-use skills.



Live class via ZOOM, Interactive class