Designing Dashboards in Excel

Focused View

Nooruddin Surani,Ambreen Reimoo

1:26:02

60 View

1. Introduction to Dashboard Reports

1.1 Introduction to the Course.xlsx

1. Introduction to the Course.mp4

04:08

2.1 Types of Excel Dashboards.pdf

2. Understanding Different Types of Dashboard Reports.mp4

03:37

3.1 31 - Dashboard Components - ClothesSales.xlsx

3. Typical Business Dashboard Components.mp4

13:08

2. Creating your first Dashboard

1.1 06 - budget dashboard.xlsx

1. Introduction To DCD.mp4

04:21

2.1 Connect with External Data Source.xlsx

2.2 sales data.csv

2. Connecting to External Data for Dashboard.mp4

02:34

3.1 calculation approaches.xlsx

3. Different Approaches for Creating Calculation Worksheet.mp4

04:19

4.1 Using ChatGPT for Dashboards.xlsx

4. Using ChatGPT for creating your dashboard.mp4

07:00

5.1 full dashboard.xlsx

5. Creating a full dashboard.mp4

10:27

3. Creating Complete Dashboards

1.1 budget dashboard.xlsx

1. Budget Dashboard - Part 2.mp4

06:48

2.1 profit and loss dashboard.xlsx

2. Finance Dashboard.mp4

06:27

3.1 hr dashboard.xlsx

3. Human Resource Dashboard.mp4

06:33

4.1 13 - non renewable resources dashboard images charts.xlsx

4. Custom Formatted Charts using Shapes & Images.mp4

10:49

5.1 09 - homeloan dashboard hyperlink - undone.xlsx

5. Using Hyperlinks to Create a Dashboard.mp4

05:51

Description

Learn how to design professional dashboards fast using the Excel features and tricks used by top gurus.

What You'll Learn?

Explore differences between Legacy & Dashboard Reporting
Understand Visual Design Principle to be applied to business Dashboards
Discover how to convert your normal calculations data into Dashboard
Learn the key features of Excel which enable you to create well formed Dashboard Reports
Uncover the secret of making your Excel Dashboard dynamic through Slicers
See how to present KPIs in the most intuitive manner

Who is this for?

Business Intelligence Professionals

CFOs

Financial Controls

Financial Analysts

Business Analysts

Head of Departments

Business Reporting Professionals

What You Need to Know?

Understanding of basic Excel features

More details

Description
Introducing a practical course for mastering the essentials of "Dashboards using Excel," perfect for those seeking a solid foundation in the subject. This comprehensive course goes beyond standard dashboard creation training by providing participants with access to four professionally designed dashboards tailored to different industries. Explore real-world case studies to understand how various professionals have effectively utilized Excel techniques to solve their challenges.
Throughout this engaging learning experience, you'll acquire hands-on experience and valuable insights from industry professionals who have used Excel to address their unique needs. Our course aims to equip you with the fundamental tools and techniques to create visually appealing and informative dashboards, transforming raw data into actionable insights for informed decision-making.
Enroll now and embark on a learning journey that blends theoretical knowledge and practical applications, providing you with a strong foundation in dashboard creation. This course is ideal for beginners and those looking to enhance their Excel dashboard design skills, offering the confidence to tackle real-world scenarios with ease. Don't miss this opportunity to elevate your understanding of Excel dashboards and unlock new possibilities for personal and professional growth.

The course is distributed in three sections.
* Introduction
* Components for creating a complete dashboard
Â Practical hands-on examples of dashboards

During the course only you will learn to create the following dashboards.
Sales Dashboard
* Budget Dashboard
* Finance Dashboard
*Â Human Resource Dashboard

We will also share our Faceboook group which have over 22,000 members, where you can share ideas, discuss themes and get answers to your queries.
Who this course is for:
Business Intelligence Professionals
CFOs
Financial Controls
Financial Analysts
Business Analysts
Head of Departments
Business Reporting Professionals

User Reviews

Rating

average 0

Total votes0

Focused display

Nooruddin Surani is an MBA in MIS, a Microsoft Certified Trainer for Office 2007 Master Program, Microsoft Excel 2010, Microsoft Excel 2013, Brainbench Master Certified for Excel 2007 (ranking 4 in world) and a Certified Information Systems Auditor (CISA). His vibrant personality combined with a unique blend of content and delivery makes the participants’ experience both educating and entertaining. Surani has been associated with the application of Information Technology for more than 18 years and is actively involved in training and teaching as a visiting faculty with multiple reputable institutes. Surani’s unique experience of working with the corporate sector includes designing & development of software solutions for medium to large sized industries, retail business management, educational, financial and banking institutions. After being engaged in consultancy assignments for leading organizations, Surani is thoroughly able to inspire and encourage those around him through his unique training style which enables maximum learning & retention in least possible time. Besides being an ardent trainer, Surani also has to his credit several articles published in multiple IT related publications. Currently, he is working as the Chief Operating Officer at Viftech Solutions (Pvt.) Ltd., a software & information technology solution provider. Driven by a mission in life, Surani aims to provide better understanding to his participants enabling them to focus better and achieve the results they seek!

Ambreen Reimoo

Instructor's Courses

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.