
Learn to build a scrolling table in Excel to present large data on a dashboard, navigating 10-row pages from 100 rows using a lookup.
Create an Excel dashboard by building a scrolling chart with a dynamic label that updates as you move the scroll bar, using format controls and lookup-based labels to reveal data.
Download the Exercise Files
Highlight the selected row or column in a large Excel dataset to make dashboards easy to read using conditional formatting and VBA.
Create awesome Excel graphics for dashboards by using built-in insert tab features, including illustrations and organizational charts, to build interactive, well-designed visuals with text and shapes.
Learn to build a dynamic sales dashboard in Excel by using checkboxes to select regions, updating charts instantly, and organizing data with transpose, index, and match techniques.
Create a dynamic Excel dashboard to compare regions with checkbox and combo box controls, driving line and stacked column charts to reveal regional sales trends using vlookup and transpose.
Explains how to visualize income and expenses with charts in Excel, using line and cluster bar charts, colors, labels, and accounting format to show monthly balance.
Latest: Course Updated on 25th March 2015.
Added 2 New Excel Dashboards. !!
1. Excel In Cell Chart Dashboard
2. Excel Gantt Chart Dashboard
Other:
Excel Dashboard Homework, Improved Quiz, Private Function Vs Public Function Excel Article
Over 2.5 Hours + of Dashboard content fully loaded with Advance Excel Techniques
Exercise Files which will help you to revise the content later
Over 800+ students having great content engagement !!!
Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. This complex data can be presented by creating Dashboard. Dashboard will help to quickly analyse the data, Find the draw backs, Expect the future outcomes and lots more
Master the creation of Interactive dashboard and learn to present it in a presentable format. Learn new techniques which will help to create complex Excel Dashboard.
Learn:
Learn it by Your way!!
Udemy Provides access to the course for Lifetime. Hence repeat the course as many times you want and make your concepts clear. Learn anywhere and anytime.
Get the answers ready from the discussion corner.
Is this course for me?
This course is designed for a particular type of people who are aware with the basics and looking forward to master the intermediate techniques. Check out if this course is for you:-
Practically this course is suited for anyone who knows excel. This course is generally carried in fast pace and hence one needs to familiar with the basic and advance concepts in Excel
Dashboards are ULTIMATE PRODUCTIVITY SUITES
Contents and Overview of Lectures
There are over 30 + Lectures containing video and Downloadable Materials. The downloadable material are crucial part of learning Excel Dashboards. When one wants to revise the technique learned before he can achieve this by using Exercise Files provided in the course materials
Upon the completion of the course students have a variety of techniques which can be applied to the live data and create the reports. Students will be focused on how to create a dashboard without wasting lot of time.
Click the "take this course" button, top right, now ...every hour you delay is costing you money...
-Amey Dabholkar