Data Analysis and Interactive Dashboard Reporting in Excel

“Discover how to tame your data and make it work for you”
In past spreadsheets where used to only perform some basic mathematical operations like adding, subtracting and dividing etc. However with the gigantic amount of information accessible to us every day, spreadsheets today can be incredibly different and far more advanced and the most eminent spreadsheet without a doubt is Microsoft Excel. Excel allows professionals to manipulate vast amounts of data, automate tasks and present complex information in a comprehensive manner. Learn how to synthesize information into a logical framework, summarize it into a meaningful format, and then display the summary into easy-to-read tables and graphs.


DURATION : 2 Day(s)
EXCEL TRAINING FEE: Rm1500 / pax (HRDF Claimable)
DATE : 25th & 26th June


There is a tremendous amount of data generated every day in the current age of information technology and most of us often struggle to understand this vast information. Excel is designed to do much more than using it as a personal whiteboard or to perform simple calculations. Participants following the basic fundamental rules will be able to extract, change, modify, report, add and manipulate data in different ways. This course is very hands-on and practical. Each participant will be expected to create their own reports, charts and models utilizing the tools and techniques covered during the course. By the end of the day, participants will:

  • understand the principles of Data analysis and Dashboards
  • learn to synthesize and summarize information into logical framework
  • consider when to use a chart or a table
  • know how to use visual effects to improve their reports and presentations
  • explore how to summarize,present and communicate data clearly and concisely
  • learn the principles of good dashboard design and presenting data graphically
  • discover the tools to analyze data & build reports using your existing Excel tools and skills (and perhaps a few you didn’t know you had!)


  • Managers and other professionals who are constantly operating on the data to make it more presentable and exhaustive
  • Students with intermediate skills are likely to enhance their knowledge of excel tools and functions and assimilate these into complex dashboards and reports


  • Those who would have a minimum insight about the Excel
  • Those who possess adequate skills are believed to benefit most from it
  • Those who have daily access to Excel and are comfortable with using its tools and functions


  • navigate confidently in Excel
  • use absolute cell reference(e.g=$A$1)
  • create and use advanced Excel tools and functions on regular basis


  • Understanding How Pivot table’s Work
  • Working With Pivot tables
  • Creating A Pivot table Report
  • Creating A Pivot table With Multiple Columns
  • Using The Pivot table And Pivotchart Wizard
  • Creating A Pivotchart
  • Using Excel Data From The Same Workbook
  • Using Excel Data From Another Workbook
  • Using Data From Other Sources
  • Using Data From An Existing Data Connection
  • Creating Pivot table Report From Data In An Access Database
  • Using Other External Data Sources
  • Using Multiple Consolidation Ranges
  • Letting Excel Create A Single-Page (Report Filter) Field
  • Creating Your Own Page (Report Filter) Field
  • Creating A Single-Page Field Pivottable Report From Multiple Consolidation Ranges
  • Creating A Multiple Page-Field Pivottable Report From Multiple Consolidation Ranges
  • Basing A Pivot table On Another Pivot table Report
  • Understanding The Pivot table Field List
  • Using The Field List
  • Setting Field List Options
  • Using Classing Pivot table Layout
  • Using The Pivottable Ribbons
  • Setting Pivottable Options
  • Formatting Pivottables
  • Applying Formatting To A Pivot table Report
  • Using Report Areas
  • Using The Row Labels Area
  • Using Multiple Row Fields
  • Using The Column Labels Area
  • Creating A Pivot table With Two Columns Fields And Two Row Fields
  • Filtering And Sorting A Pivot table On Row And Column Fields
  • Using The Value Area
  • Using Multiple Value Fields
  • Using The Report Filter Area
  • Creating A Pivottable With Three Report Filter Fields
  • Working With Field Settings
  • Understanding The Settings For Value Fields
  • Using Different Summary Functions
  • Working With Settings For Row And Column Fields
  • Working With Settings  For Report Filter Fields
  • Using Value And Label Filters
  • Using A Value Filter And Custom Sort
  • Working With Calculated Fields And Items
  • Creating And Using A Calculated Field
  • Creating And Using A Calculated Items
  • Showing And Hiding Detail
  • Grouping Pivottable Items
  • Grouping Dates
  • Grouping Category Data
  • Understanding Pivot charts
  • Creating A Pivot chart
  • Understanding The Parts Of A Chart
  • Working With The Pivot chart Ribbon
  • Understanding And Changing Pivot chart’s Structure
  • Creating A 3-D Pivot chart
  • Using The Pivot chart Filter Pane
  • Using Multidimensional Data
  • Understanding Multidimensional Data
  • Multidimensional Data Terminology
  • Creating A Pivot table From An Online Cube
  • Understanding The Get pivot data Function
  • Referencing Pivot table Cells By Address
  • Using Get pivot data To Analyse Pivot table Data
  • Copying And Moving Pivottables
  • Working With Subtotals
  • Nesting Subtotals
  • Hiding And Showing Subtotals Details
  • Working With Database Functions
  • Defining Criteria
  • Working With Filter
  • Tool selection
  • What’s new in Office 2013
  • Shortcuts
  • Tables & PivotTables
  • Power Pivot
  • Essential Excel tools & functions
  • Specialist Functions and Formulas
  • Creating a robust formula
  • Working with text
  • Cleaning your data

Leave A Comment