HTME

COURSE OVERVIEW

IE1022 : Dynamic Business Reports and Dashboards Using Excel
Dynamic Business Reports and Dashboards Using Excel
OVERVIEW
COURSE TITLE:IE1022 : Dynamic Business Reports and Dashboards Using Excel
COURSE DATE:Sep 29 - Oct 03 2024
DURATION:5 Days
INSTRUCTOR:Dr. Mike Tay
VENUE:Al Khobar, KSA
COURSE FEE:$ 7000
Request For Course Outline
OTHER SCHEDULED DATES

Course Description

This course is designed to provide participants with a detailed and up-to-date overview of Excel dashboard. It covers the insertion of graphics for a dashboard; inserting a simple chart, using sparklines with dashboards, using table to dynamically link charts and lists and linking charts across worksheets; the special functions and formulas covering OFFSET function, nested IF statements using the AND OR operators, VLOOKUPs and the MATCH function; and the dashboard navigation, creating bespoke navigation bars and dashboard links and using named objects.
During this interactive course, participants will learn to prepare workbook’s layout and structure; organize data in data tables using Ifs; use table formulas to make dynamic charts, conditional formatting, OFFSETs, VLOOKUPs and name range lists; use Excel objects for specialist dashboard views; adding data bar into your dashboards and create a window chart, advanced comparison chart and timeline chart; use macros and VBA with dashboards; and configure controls using macros.

link to course overview PDF

TRAINING METHODOLOGY

This interactive training course includes the following training methodologies:

Lectures
Workshops & Work Presentations
Case Studies & Practical Exercises
Videos, Software & Simulators

In an unlikely event, the course instructor may modify the above training methodology for technical reasons.

VIRTUAL TRAINING (IF APPLICABLE)

If this course is delivered online as a Virtual Training, the following limitations will be applicable:

Certificates:Only soft copy certificates will be issued
Training Materials:Only soft copy materials will be issued
Training Methodology:80% theory, 20% practical
Training Program:4 hours per day, from 09:30 to 13:30

RELATED COURSES

Process Control & Instrumentation

IE0030 : Process Control & Instrumentation

Process Control, Instrumentation,  Troubleshooting & Problem Solving

IE0038 : Process Control, Instrumentation, Troubleshooting & Problem Solving

PLC & SCADA for Automation & Process Control

IE0190 : PLC & SCADA for Automation & Process Control

IEC 61850 & Its Role in Smart Grid

IE0223 : IEC 61850 & Its Role in Smart Grid