Microsoft Office Excel Dashboard for Business Intelligence – Available Online

CLASS TRAINING SCHEDULE IN 2025
January 7th-8th, 2025 | IDR 3 million | Hotel Kuretakeso, Jakarta Selatan
February 6th-7th, 2025 | IDR 3 million | Hotel Kuretakeso, Jakarta Selatan
March 6th-7th, 2025 | IDR 3 million | Hotel Kuretakeso, Jakarta Selatan
April 10th-11th, 2025 | IDR 3 million | Hotel Kuretakeso, Jakarta Selatan
May 8th-9th, 2025 | IDR 3 million | Hotel Kuretakeso, Jakarta Selatan

ONLINE TRAINING SCHEDULE IN 2025
January 7th-8th, 2025 | IDR 2 million | Online Training  (via zoom)
February 6th-7th, 2025 | IDR 2 million | Online Training  (via zoom)
March 6th-7th, 2025 | IDR 2 million | Online Training  (via zoom)
April 10th-11th, 2025 | IDR 2 million | Online Training  (via zoom)
May 8th-9th, 2025 | IDR 2 million | Online Training  (via zoom)

Target Student:

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Prerequisites:

To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® : Basic level or have the equivalent knowledge and experience.

Course Objectives

• At the end of this course you will understand what makes a dashboard.

• You will learn how to build some of the most useful components when constructing your own dashboard reports.

• During the course you will build three complete dashboard projects to give you inspiration for your own solutions.

Course Content

Unit 1: What is a dashboard?
Why use a dashboard?
Common features of a dashboard
Preparing to build a dashboard

Unit 2: PivotTables and PivotCharts
Creating PivotTables
Formatting a PivotTable
Refreshing a PivotTable
Grouping fields
Slicers and Timelines
PivotCharts

Unit 3: Useful functions
Nested IFs
COUNTIFS & SUMIFS
EDATE
INDEX & MATCH
OFFSET
CHOOSE

Unit 4: Conditional Formatting
Formatting values
Colour Scales to show heatmaps
Icon Sets to show at a glance performance

Unit 5: Form Controls
Understanding the different controls
Using them on a dashboard

Unit 6: Working with Charts
Creating charts
Formatting charts
Secondary Axes
Combination charts
Creating chart templates

Unit 7: Working with Sparklines
Creating & modifying Sparklines
Customizing Sparklines

Unit 8: Design & Layout
Gridlines & outlines
Lining up Excel objects
Theming a dashboard

Appendix I: Sample Dashboard Projects
Worldwide Salary Index
Sales Performance Analysis
Helpdesk Efficiency

Appendix II: External Data Sources
Importing Data from the Web

Appendix III: Advanced Charts
Create a Speedometer chart
Create a Tornado chart
Create a Waterfall or Step chart
Format mini-charts

Appendix IV: Dealing with Dynamic Data Sources
Use a dynamic range name
Understand Table formatting

Facilitator

Abdul Gofur

CLASS & ONLINE TRAINING SCHEDULE

Schedule in 2025

1. June 12th-13th, 2025
2. July 7th-8th, 2025
3. August 7th-8th, 2025
4. September 11th-12th, 2025
5. October 16th-17th, 2025
6. November 13th-14th, 2025
7. December 11th-12th, 2025

Venue

1. Class Training : Hotel Kuretakeso, Jakarta Selatan
2. Online Training : via zoom

Investment Cost

1. Class Training :
   IDR 3 million per participant (excluding VAT)
2. Online Training :
   IDR 2 million per participant (excluding VAT)