Advanced Excel Table, Charts, PivotTable, PivotChart and Dashboard Reporting
- Date : 13 - 25 July 2022
- Duration : Evening(7:30 PM-10:00 PM)
- No. of Classes/ Sessions : 4 Sessions
- Class Schedule : Monday & Wednesday
- Total Hours : 10
- Last Date of Registration : 12 July, 2022 ( within 5pm )
- Venue : Online Virtual
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 WindowAdvanced 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
Resource Person
Syed Saniat Ahmmad
Industrial & Financial Consultant
Mr. Syed Saniat Ahmmad has been working at his own consultancy firm Strategic & Financial Consultancy Services (SFCS) as a Managing Director; providing various services e.g. Project Feasibility Study, Prepare Project Profile, Industrial & Corporate Advisory, Financial Advisory & Advocacy, Strategic Marketing Planning, Organization Restructuring, Management Restructuring, Prepare Business Loan Proposal etc.
Before starting his business career he obtained more than 13 years of working experience in different business organizations like LankaBangla, Sigma Capital, Northern Group etc. His extensive work experience are in Credit Administration, Compliance, Operations, Administration, HR, Customer Services etc. Moreover, he is a renowned Industrial & Financial Consultant in the arena of Industrial & Financial sector.
Before starting his career he has completed his Honor’s & Master’s degree in Management and MBA in Finance & Banking.
In addition, Mr. Saniat does provide professional training in different Training Institute, Corporate Houses and Bank & NBFI’s to strengthen the Interpersonal Skill, Management Skill, Business Skill, Financial Data Analysis, Financial Modeling etc for increasing professionals required skills up to the 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.
Bdjobs
Android App
Facebook
Google
Youtube
LinkedIn
Instagram
