October Sale - 20% of all courses - Book Today

Excel Specialist Nexacu Asia

Excel Analysis and Dashboards Training

Learn to use Excel tools to build effective actionable dashboards.

Courses running live online, join our instructor via remote login. 

Excel’s ability to integrate and visualize data is the focus of this day long course, using the latest features in Excel. Work through multiple exercises to learn to master the tools of data modelling, analysis and building visuals for effective Dashboards.

Participants will create a data model with a range of data sources using Power Pivot and use Get and Transform to connect and manipulate a range of data sources including cloud databases, websites and Facebook. Learn how to fully utilize Excel to create interactive Dashboards, Charting tools and Visualization techniques.

We complete the course by working through a Case Study pulling all the aspects we teach on the day together.

  • Business Case Study – We start with raw sales data for a Comedy Roadshow. We model the data using PowerPivot, creating relationships and the necessary calculations to build our interactive Dashboard for assessing Sales performance and profitability across various cities. Read our full course outline here.

Excel Analysis and Dashboards Training

4.8

Analyse your data in Excel with Power Pivot and build effective dashboards. Led by our experienced trainers.

$320 $265 USD
10 max
1 day
$320 $265 USD
10 max
1 day
$320 $265 USD
10 max
1 day
$320 $265 USD
10 max
1 day
$320 $265 USD
10 max
1 day
$320 $265 USD
10 max
1 day

Bangkok

Kuala Lumpur

Manila

Hong Kong

Singapore

Jakarta

Upcoming Courses:
Bangkok
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Bangkok
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Bangkok
Status: Scheduled
Scheduled
Kuala Lumpur
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Kuala Lumpur
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Kuala Lumpur
Status: Scheduled
Scheduled
Manila
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Manila
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Manila
Status: Scheduled
Scheduled
Hong Kong
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Hong Kong
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Hong Kong
Status: Scheduled
Scheduled
Singapore
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Singapore
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Singapore
Status: Scheduled
Scheduled
Jakarta
Date
Course
City
Status
Mon 23-Nov-20
Mon 23 Nov
Analysis & Dashboards
Jakarta
Status: Scheduled
Scheduled
Tue 2-Feb-21
Tue 2 Feb
Analysis & Dashboards
Jakarta
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
53, Siwatel Tower, 1st Floor, Witthayu Road, Lumphini, Khet Pathum Wan, Bangkok, 10330
microsoft_gold
deloite_logo

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
3, Jalan Stesen Sentral, Kuala Lumpur Sentral, 50470 Kuala Lumpur
microsoft_gold
deloite_logo

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
Glorietta Mall, Palm Dr, Ayala Center, Makati, 1224 Metro Manila
microsoft_gold
deloite_logo

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
Pacific Place, 88 Queens Way, Hong Kong
microsoft_gold
deloite_logo

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
9 Wallich Street 078885 SINGAPORE
microsoft_gold
deloite_logo

Excel Analysis and Dashboards Course Details

Price
$318 $265 USD
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
Address
Jl Pegangsaan Timur No.17 Cikini Jakarta 10310, ID
microsoft_gold
deloite_logo

Excel Specialist Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Excel Specialist Training Courses
Microsoft SharePoint Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Microsoft Excel Specialist Training Courses
Microsoft SharePoint Training Courses
Microsoft Power Apps Training Courses
Microsoft Project Training Courses
Microsoft Visio Training Courses
Data Analytics Training Courses
Python Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Course Rating
Microsoft Excel Specialist Training Courses

4.8 5 Microsoft Excel Specialist Training Courses
4.8 out of 5
23577 Student Reviews

Contact Us



What do I need to know to attend?

This Excel Analysis & Dashboards training course is suitable for those who already have an intermediate level knowledge of Excel.

The course is aimed at those who want to use the latest features of Excel to their full capability.

Attendance of our other courses is not a pre-requisite for this course.

This course is not recommended for MAC users.

Excel Analysis and Dashboards Learning Outcomes

  • Connect to cloud databases and websites
  • Create relationships using a Power Pivot data model
  • Effectively analyse data in Excel
  • Create interactive visualisations

 

  • Review Pivot Tables and Charts within a data model
  • Extend Pivot Table and Chart technical skills and features
  • Use a from web data forlive share price connection
  • Manipulate data sources using query editor

Excel Analysis and Dashboards Course Content

  • Data Modelling
  • Starting a dataset in Excel
  • Multiple Tables
  • Data Modelling
  • Get & Transform
  • Understanding Get & Transform
  • Understanding the Navigator Pane
  • Creating a New Query From a File
  • Creating a New Query From the Web
  • Understanding the Query Editor
  • Displaying the Query Editor
  • Managing Data Columns
  • Get & Transform (cont'd)
  • Reducing Data Row
  • Adding a Data Column
  • Transforming Data
  • Editing Query Steps
  • Merging Queries
  • Working With Merged Queries
  • Saving and Sharing Queries
  • The Advanced Editor
  • Power Pivot
  • Understanding Relational Data
  • Common Sense Data Modelling
  • Enabling Power Pivot
  • Connecting to a Data Source
  • Working with The Data Model
  • Working with Data Model Fields
  • Changing A Power Pivot View
  • Power Pivot (cont'd)
  • Creating A Data Model PivotTable
  • Using Related Power Pivot Fields
  • Creating A Calculated Field
  • Creating A Concatenated Field
  • Formatting Data Model Fields
  • Using Calculated Fields
  • Creating A Timeline
  • Adding Slicers
  • Great functions for Analysis
  • Understanding Data Lookup Functions
  • Using CHOOSE
  • Using VLOOKUP
  • Using VLOOKUP For Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using SUMIF
  • Using SUMIFS
  • Using SUMPRODUCT
  • Data Validation
  • Validation Criteria
  • Input Messages & Error Messages
  • Drop-Down Lists
  • Formulas
  • Customised Validation Criteria
  • Creating A Number Range Validation
  • Data Validation (cont'd)
  • Testing A Validation
  • Creating an Error Message
  • Creating a Drop Down List
  • Using Formulas as Validation Criteria
  • Circling Invalid Data
  • Removing Invalid Circles
  • Using Sparklines to show trends
  • What is a Sparkline?
  • Types of Sparklines
  • Showing Sparklines only
  • Specifying a Date Axis
  • Hidden Data and Sparklines
  • Sparklines and Targets
  • Using Conditional formatting
  • Using Conditional Formatting with a Dashboard
  • Top 10 & Custom Formatting
  • Data Bars
  • Show data bars outside the data cell
  • Colour Scales
  • Icon Sets
  • Creating Rules Based Icon Set
  • Removing unnecessary icons
  • Using Symbols in Reporting
  • Using the Camera Tool
  • Pivot Tables
  • Structure of Pivot Tables
  • Using Compound Fields
  • Counting in A PivotTable
  • Formatting PivotTable Values
  • Working with Grand Total & Subtotals
  • Finding the Percentage of Total
  • Finding the Difference From
  • Grouping in PivotTable Reports
  • Creating Running Totals
  • Pivot Tables
  • Creating Calculated Fields
  • Providing Custom Names
  • Creating Calculated Items
  • PivotTable Options
  • Sorting in a PivotTable
  • Top and Bottom Views
  • Date Grouping Options
  • Hiding or Showing Data Items
  • Conditional Formatting and Sparklines in Pivot Tables
  • Pivot Caches and File Size
  • PivotCharts
  • Inserting a PivotChart
  • Defining the PivotChart Structure
  • Changing the PivotChart Type
  • Using the PivotChart Filter Field Buttons
  • Moving Pivot Charts to Chart Sheets
  • Moving Pivot Charts to Chart Sheets
  • Slicers in Reports
  • What are Slicers?
  • Creating Slicers
  • Using a Slicer on Multiple Pivot Tables
  • Renaming Pivot Tables
  • Timeline Slicer
  • Trending Charts
  • Why do we use Trending Charts?
  • Appropriate Chart Types for Trending
  • Vertical or Y-Axis Scales
  • Chart Titles linking to a Cell
  • Comparative Trending
  • Labelling
  • Using a Secondary Axis
  • Formatting Key Data Points
  • How to display Actuals and Forecasts
  • Averages and Data Smoothing
  • Other Report Charts
  • Top and Bottom Charts
  • How to show Top or Bottom in Data Labels
  • Waterfall Charts
  • Histograms
  • Creating Histograms using Formulas
  • Creating Histograms using Pivot Tables
  • Creating Histograms using Excel’s Statistical Charts
  • Charting performance against a target
  • Performance against Targets
  • Creating Thermometer Chart
  • Bullet Graph
  • Defining Dashboards
  • Purpose of a Dashboard
  • Working out what is needed
  • What are the data sources
  • Will the audience need further data to drill-down to?
  • How often will/can the data refresh?
  • Does it need to be maintained?
  • How easy will it be to maintain?
  • Dashboard Design Principles
  • Thirteen common mistakes in dashboard design
  • Making an Interface
  • Using Macros with Dashboards
  • Recording a Macro
  • Navigation using Macros
  • Macros to Change Chart types
  • Macros and Pivots
  • Pulling it all together – Case Study
  • We start with raw sales data for a Comedy Roadshow. We model a the data using PowerPivot, creating relationships and the necessary calculations to build our interactive Dashboard for assessing Sales performance and profitability across various cities.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23577 Reviews
Excellent training course really filled in the gaps for me as a SharePoint administrator -SharePoint Site Owner Brisbane
Kristy - SharePoint Site Owner, .
Great course with very useful content. But also made me realise that Sharepoint is a massive tool with endless capabilities. -SharePoint Site Owner Brisbane
Richard - SharePoint Site Owner, .
Very good -Office365 Beginner Brisbane
Liem - Office365 Beginner, .
Great training - really good pace and so clear - enjoyed this training very much and learnt more than I knew before Thanks -Excel Customised Remote Online
Tricia - Excel Customised, .
Fantastic -Excel Customised Remote Online
Angie - Excel Customised, .
Learnt a lot thank you -Excel Customised Remote Online
Ann - Excel Customised, .
Amazing Trainer very patient and took the time to go through things thoroughly. Thank you Jason -Excel Customised Remote Online
Carly - Excel Customised, .
Very well structured course, easy to understand and follow. Highly recommended !! -Power BI Intermediate Sydney
Josep - Power BI Intermediate, .
Insightful Training. Trainer extremely helpful and took time to sort out any issues on the program. Trainer offered extra tuition if required. Trainer clear and concise in explanation. -Power BI Intermediate Sydney
Aishling - Power BI Intermediate, .
It is a good course. I learned a lot from this. Thank you -Power BI Intermediate Sydney
Eric - Power BI Intermediate, .
Very engaging, enjoyed and learned a lot. -Power BI Intermediate Sydney
Roman - Power BI Intermediate, .
Jagg teach method made the day very informative and interesting. Would have liked some notes to take away on tips and tricks. -Power BI Beginner Adelaide
Allison - Power BI Beginner, .
Very, very good. Extremely knowledgeable, very good communication, loved the hand gestures. -Power BI Beginner Adelaide
Rhett - Power BI Beginner, .
Extremely insightful and very helpful. For someone who has not had a lot of exposure to Power BI, I now feel quite confident with the basics of the program. -Power BI Beginner Adelaide
Ryan - Power BI Beginner, .
Jagg was excellent and have a good sense of humer!!. Learned a lot. Thanks Jagg. -Power BI Beginner Adelaide
Hikkaduwa - Power BI Beginner, .
Great introduction to Power BI, easy to follow along with, lots of good insight and well presented. Instruction was clear and good examples provided. -Power BI Beginner Adelaide
Linda - Power BI Beginner, .
great overview of the building of beginner power BI reports and dashboards. cant wait to build more reports -Power BI Beginner Adelaide
Louise - Power BI Beginner, .
That was very informative and well paced. Thank you -Power BI Beginner Adelaide
Hina - Power BI Beginner, .
Excellent course, Jagg was very informative and clear - thank you -Power BI Beginner Adelaide
Emma - Power BI Beginner, .
very knowledgeable -Office365 Beginner Brisbane
David - Office365 Beginner, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us