Designing Dashboards in Excel
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
Requirements
- Understanding of basic Excel features
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
Instructors
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!
- 4.4 Instructor Rating
- 18 Reviews
- 11,357 Students
- 1 Course