COURSE OVERVIEW
IE1022 : 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
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.
TRAINING METHODOLOGY
This interactive training course includes the following training methodologies:
LecturesWorkshops & 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
IE0030 : Process Control & Instrumentation
- Date: Dec 01 - Dec 05 / 3 Days
- Location: Doha, Qatar
- Course Details Register
IE0038 : Process Control, Instrumentation, Troubleshooting & Problem Solving
- Date: Nov 24 - Nov 28 / 3 Days
- Location: Istanbul, Turkey
- Course Details Register
IE0190 : PLC & SCADA for Automation & Process Control
- Date: Nov 25 - Nov 28 / 3 Days
- Location: Abu Dhabi, UAE
- Course Details Register
IE0223 : IEC 61850 & Its Role in Smart Grid
- Date: Dec 08 - Dec 12 / 3 Days
- Location: Dubai, UAE
- Course Details Register