How to make advanced dashboards in Excel

[fusion_builder_container background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_aspect_ratio=”16:9″ overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” padding_top=”20″ padding_bottom=”20″ hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no”][fusion_builder_row][fusion_builder_column type=”1_2″ layout=”1_2″ last=”no” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=”” min_height=””][fusion_slider hover_type=”none” width=”100%” height=”100%”][fusion_slide type=”image” link=”” linktarget=”” lightbox=””]https://www.excelcharts.com/wp-content/uploads/courseimg/dd-lookup-excel-dashboard1-300x211base.png[/fusion_slide][fusion_slide type=”image” link=”” linktarget=”” lightbox=””]https://www.excelcharts.com/wp-content/uploads/courseimg/ddvba-excel-dashboard-300×200.png[/fusion_slide][fusion_slide type=”image” link=”” linktarget=”” lightbox=””]https://www.excelcharts.com/wp-content/uploads/2011/07/ddvbafree-300×200.png[/fusion_slide][fusion_slide type=”image” link=”” linktarget=”” lightbox=””]https://www.excelcharts.com/wp-content/uploads/2011/07/walmart-map-300×185.png[/fusion_slide][/fusion_slider][/fusion_builder_column][fusion_builder_column type=”1_2″ layout=”1_2″ last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” hover_type=”none” link=”” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ animation_offset=”” class=”” id=”” min_height=””][fusion_title size=”2″ content_align=”left” style_type=”default”]Learn how to make great Excel dashboards and get my book for free![/fusion_title][fusion_text]

Now, while you learn how to make Excel charts like a pro, you can apply these best practices to your dashboards. Get access to two dashboard tutorials, more than three hours of step-by-step videos that will help you unleash your creativity and create great dashboards using Excel. And you also get access a growing number of bonus files that you can explore and use to improve your Excel skills.

I’m and updating the dashboard tutorials to better reflect what I wrote in my data visualization book and to take advantage of Excel 2013 and 2016. To mark this I’m giving the Kindle version of my book away to new users. Hurry! Grab one of the remaining digital copies! Kidding, but this campaign will not last for long. Seriously.

(Two dashboard courses only $97.00 and a free electronic copy of my book. 24-month access to the tutorials, 30-day, no questions asked, full money-back guarantee. Pay securely with your Paypal account. You’ll get a message from Amazon with a link to your gift a few hours after your purchase.)

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_repeat=”no-repeat” background_position=”left top” video_aspect_ratio=”16:9″ overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”0px” padding_top=”20″ padding_bottom=”20″ hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”no”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none” last=”no” hover_type=”none” link=”” border_position=”all”][fusion_content_boxes layout=”icon-with-title” columns=”3″ icon_align=”left” animation_direction=”left” animation_speed=”0.1″ hide_on_mobile=”small-visibility,medium-visibility,large-visibility”][fusion_content_box title=”Excel Dashboard Lookup” icon=”fa-tablet” iconspin=”no” link=”https://www.excelcharts.com/data-visualization-courses/demographic-dashboard-lookup-edition/” linktext=”Learn More” animation_type=”0″ animation_direction=”left” animation_speed=”0.1″]Confuse (and delight) your managers with an Excel dashboard that doesn’t look like an Excel dashboard. This course shows you how to use advanced Excel functions to aggregate data and make an interactive dashboard. And you can even display your data on a map![/fusion_content_box][fusion_content_box title=”Excel Dashboard VBA” icon=”fa-random” iconspin=”no” link=”https://www.excelcharts.com/data-visualization-courses/demographic-dashboard-vba-edition/” linktext=”Learn More” animation_type=”0″ animation_direction=”left” animation_speed=”0.1″]VBA? No way! Wait. If you want a more powerful Excel dashboard there are two things that you can’t avoid: pivot tables and recorded macros. In this tutorial you’ll learn how to make advanced pivot tables. If you haven’t used them yet you’ll be amazed of how powerful they are. Then you’ll need a few recorded macros to synchronize them. Record your actions and assign the macro to a button. It’s simple, really.[/fusion_content_box][fusion_content_box title=”Two Bonus Dashboards” icon=”fa-tint” iconspin=”no” animation_direction=”left” animation_speed=”0.1″]

There are no tutorials for for these ones. You must download them and figure out they work. In the Growth of Walmart dashboard you’ll see each store, each county, total population covered within a given radius. You can apply the same principles and techniques to your own list of stores.

[/fusion_content_box][/fusion_content_boxes][/fusion_builder_column][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none” last=”no” hover_type=”none” link=”” border_position=”all”][fusion_tagline_box shadow=”no” shadowopacity=”0.1″ border=”1px” highlightposition=”left” linktarget=”_self” title=”Better Data Visualization” description=”These dashboards are free from 3D pie charts, speedometers and other stupid and useless effects. If you want to know why they are bad for business please read the blog, you’ll find many reasons. A good chart can dramatically improve the way you use and make sense of your data. Always apply the best practices and visualization principles when designing your dashboards.” animation_type=”0″ animation_direction=”down” /][/fusion_builder_column][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none” last=”no” hover_type=”none” link=”” border_position=”all”][fusion_title size=”2″ content_align=”left”]What Users Say[/fusion_title][/fusion_builder_column][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none” last=”no” hover_type=”none” link=”” border_position=”all”][fusion_testimonials][fusion_testimonial name=”Daniele” avatar=”” image=”” image_border_radius=”” company=”” link=”” target=””]In less than half an hour, I have learned more than I ever imagined with your dashboard, and that is the start. Thanks you so much, and yes, the price is really nothing compared to what you get.[/fusion_testimonial][fusion_testimonial name=”Jeff” avatar=”” image=”” image_border_radius=”” company=”” link=”” target=””]Great job. It has helped me get a dashboard project off the ground in record time. Thanks![/fusion_testimonial][fusion_testimonial name=”Imran” avatar=”” image=”” image_border_radius=”” company=”” link=”” target=””]… indeed it is a great work.[/fusion_testimonial][fusion_testimonial name=”Rachana Mukherjee” avatar=”” image=”” image_border_radius=”” company=”” link=”” target=””]I accidentally discovered your site and I am super impressed. I am a data analyst at e-commerce company and am looking to streamline automate reports for executives. I am trying to expand my understanding of excel and building up my repertoire so to speak and I realize that pivot tables and VBA are key. The demographic dashboard is an excellent learning tool for people like me who are looking to learn the “integration” bit by example. And, your example is extremely clean and non-convoluted. So thank you, I am looking forward to learning a lot from your site and tutorials.[/fusion_testimonial][fusion_testimonial name=”Chris Capel” avatar=”” image=”” image_border_radius=”” company=”” link=”” target=””]The challenge is not so much in the Excel techniques (well, only a little 😉 ), but it is more in the creativity and empathy of the dashboard designer. Thanks Jorge, for your brilliant solutions![/fusion_testimonial][fusion_testimonial name=”” avatar=”” image=”” image_border_radius=”” company=” The Washington Post” link=”” target=””]If you’d like more tips on creating better and more understandable charts, Jorge Camoes’ Charts blog offers his insights on data visualization.[/fusion_testimonial][/fusion_testimonials][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container hundred_percent=”yes” overflow=”visible” padding_right=”20px” padding_left=”20px”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none” last=”no” hover_type=”none” link=”” border_position=”all”][fusion_text] [/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]