Advanced Excel Table, Charts, PivotTable, PivotChart and Dashboard Reporting training centre in Bangladesh

New
EMI EASY PAY

Advanced Excel Table, Charts, PivotTable, PivotChart and Dashboard Reporting

  • Date : 20 August - 01 September 2019
  • Duration : Evening(6.30 pm-9.30 pm)
  • No. of Classes/ Sessions : 4 Sessions
  • Class Schedule : Sunday & Tuesday
  • Total Hours : 12
  • Last Date of Registration : 19 August, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Microsoft Excel is most widely used productivity tool in today’s corporate world. Day to day corporate analysis, reporting tools and applications are prepared with Excel. Corporate industry requires highest level of Microsoft Excel proficiency. To managing and analyzing a group of related data easier, we can turn a range of cells into an Excel Table. And a Pivot Table gathers all the data in an Excel spreadsheet and presents a summary of this data in a table. Charts and graphs are used to make information clearer and easier to understand. And Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. It will be an advantage for course attendees to learn practical and advanced usages of this mostly renowned Excel tools for their daily task in multiple ways.

Methodology

Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.

Contents of Training:

INTRODUCTION :Various Parts of the XL Window

Advanced Excel Table:
What is an Excel Table?
Benefits of Excel Table
Preparing Data
Creating an Excel Table
Choosing Formatting Style
Naming an Excel Table
Rename an Excel Table
Sorting & Filtering Data
Remove the Filter Arrows
Show/Hide Header Rows in a Table
Show/Hide Totals in a Table
Subtotal Function in Total Row
Auto Expansion of Table Areas
Refer to Table Column in Different Formulas
Insert Slicer
Convert Table Back to a Range

Advanced Charts:
What is Charts?
Benefits of Charts
Sort Data Before Charting
Create a Chart
Change Chart Type
Switch Row/Column
Add/Remove Chart Title
Data Labels
Legend Position
Move the Legend
Display/Hide Chart Axes or Gridlines
Save a Chart as a Template
Bar Chart
Column Chart
Line Chart
Pie Charts
Area Charts
Combined Chart
Waterfall Chart
Gantt Chart
Funnel Chart
Histogram
Organization Chart
Sparkline
Remove Noise
Add Descriptive Titles
Don’t Make People Head Tilt
Clean Up Axes

Advanced PivotTable & PivotChart:
What is Pivot Table?
Benefits of PivotTable
Required Checklist for Pivot Table
Preparing Source Data in Tabular Format
Creating a PivotTable
Formatting PivotTables
Arranging / Pivoting Data
Add Columns
Changing the Way Values are Displayed
Formatting Values
Grouping Data
Calculated Fields
Sorting and Filtering Data
Refreshing a PivotTable
Extending the Dataset
Replace Blank Cells in a Pivot Table
Expand or Collapse Field Headings
Add or Remove Expand or Collapse buttons
Insert Slicers
Timelines
Change the Pivot Table Layout
Turn On or Off Subtotals
Turn On or Off Grand Totals
Recommended PivotTables
Using Various Conditional Formatting Styles
Format Numbers as Invisible Text
Add a Second Field to the Values Area
Prevent Column Width Changing on Update
GETPIVOTDATA Function
Turn Off GETPIVOTDATA
Pivot Charts

Dashboard Reporting:
What is a Dashboard?
How Dashboard Differ from a Report?
Benefits of Dashboard
Things to Consider Before Creating a Dashboard
Tips to Create a Dashboard
Interactive Tools for Dashboard
Dashboard Do’s and Don'ts
Preparing Raw Data into Tabular Format
Analyze the Data
Creating a Dashboard
Dashboard Reporting
And so on…

Related Courses

Syed Saniat Ahmmad
  • 20 Aug - 8 Sep 2019

Practical examples, exercises & case studies with ...

IT
Md. Feroz Kibria
  • 23 - 24 Aug 2019 (2 Days Long)

Participants will experience a first look of the latest ...

IT
S.M.Morshed Hemal
  • 23 Aug - 7 Sep 2019

Microsoft Excel is one of the most widely used tools for ...

IT
Course at Chattogram
Price 2,500 Tk + VAT
Fakharul Abedin (MCSA
  • Friday, August 23, 2019

The course is designed for practical Excel applications at ...

IT
This is an exclusive for them who have experience working with Microsoft Excel and would like to learn more about Pivot Table, Pivot Chart and dashboards.

Resource Person

Syed Saniat Ahmmad

Mr. Syed Saniat Ahmmad has been working in the Department of Credit Administration & Compliance in a leading Investment Bank which is a full-fledged Merchant Bank and a subsidiary of a leading NBFI for 9 years. Before starting his career at NBFI he had work in a local group as an Admin & HR Officer for about 3 years. His extensive work experience are in Credit Administration, Compliance, Operations, Administration, HR, Customer Services etc.

Before starting his career he has completed his Honour's & Master’s degree in Management and MBA in Finance from East-West University.

In addition, Mr. Saniat does provide professional training on Capital Market Compliance, Financial Modeling, Dashboard Reporting, MS Word, MS Excel, MS PowerPoint, MS Outlook etc in corporate industry for increasing professionals required skills up to advanced level.

Last but not the least Mr. Saniat has gained adequate knowledge & skills by attending many trainings and workshops on Organizational Leadership Skills, Personal Excellence, Credit Risk Management (CRM), Credit Management & Debt Collection Strategies, Compliance & Associated Issues, Securities Laws of Bangladesh, Anti Money Laundering, Effective Business Communication, Management Information System (MIS) etc.

Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.