Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 27 Minute(s)
Language
English
Taught by
Damon Martin
Rating
Course Overview
You will Build a Highly Attractive ITSM Incident Excel Dashboard with Automated Commentary, Dynamic Charts & Data.
This course will take you Step-by-Step through Planning, Designing and Building a Highly Attractive Application Support Incidents & Requests Excel Dashboard that will impress your managers and colleagues. You’ll learn how to design beyond the ordinary look and feel of traditional Microsoft Excel dashboards and will learn cool techniques using my Design and Data Visualization Methodology.
The skills you learn will enable you to create new and exciting dashboards on your own using simple Excel formulas, pivot tables, dynamic tables, shapes and pictures to pull off some really cool data visualization tricks.
You do not have to have any Microsoft Excel or dashboard development experience for this course because we will be doing everything step-by-step.
This course will be easy to follow and will include the completed Excel Dashboard, Design Guide and Sample Data Excel Worksheets.
Course Content
- 10 section(s)
- 34 lecture(s)
- Section 1 Introduction
- Section 2 Dashboard In Action
- Section 3 Drafting a Dashboard Design
- Section 4 How to Create, Build and Update the Database Table
- Section 5 Building the Formulas for Database Table
- Section 6 Adding Conditional Formats and Hyperlinks to the Database Table
- Section 7 Updating the Database Table
- Section 8 Pivot tables
- Section 9 Commentary
- Section 10 The Dashboard Front-end
What You’ll Learn
- How to create an Excel Dashboard.
- How to build a corporate quality - dynamic Resolved Incidents and Requests ITSM Dashboard.
- How to design a clean web application look and feel dashboard.
- How to utilize the same space to show difference set data sets without dashboard crowding.
- How to build automated commentary - dynamically calculate and automatically display analytical commentary.
- Skills and a design style that will carry over to future projects.
- Excel Dashboard template and raw data files included.
Skills covered in this course
Reviews
-
AArt Lopez
GREAT JOB EXPLAINING
-
DDawn Reider
So far so good - familiar with these concepts but looking forward to seeing how they are being used
-
AAndrew Peacock
This course was a great practical training that I can use immediately in my line of work. If you report to a client and want to validate your recommendations or if you need to demonstrate to management the environment progress under your control, what you learn from Damon will allow you do that eloquently and proficiently.
-
SSyed Anwar Kamal
stuff is good , instructor is knowledgeable, but two things are not good.First the video quality, the actual excel sheet is not clear and visibility is not 100%. Secondly, the instructor has taken much time in cosmetics and repeating same things and he literally ruined the quality content by dragging in unnecessary talks. Otherwise , course is worth to take
