How To Create Ultimate Excel Dashboard for BEGINNERS

Efficient Excel tips, with downloadable exemple, You can use it immediately for your own creating work

Create your own, interactive Microsoft Excel Dashboard from zero is not easy! so let me help you.

What you’ll learn

  • Learn how to create a professional KPI dashboard from scratch.
  • How to approach an Excel dashboard project from idea to delivery.
  • Build Interactive Dashboard Reports with Buttons and Drop Down Menus.
  • Data cleaning.
  • Analyze Excel data using Excels based Functions.
  • Use powerful visual techniques so your content has more effect.
  • Be a master in analyzing data with an interactive dashboard.
  • In this Excel Tutorial you will learn how to create custom collapsable and interactive settings menu.
  • In Excel that can be perfectly used to control the visual appearance and behaviour of a dashboard..
  • The settings menu includes fully functional and custom radio buttons to control the theme color of the dashboard with only one click.

Course Content

  • Introduction –> 3 lectures • 21min.
  • How to composite the Dashboard –> 5 lectures • 54min.
  • automate the dashboard –> 6 lectures • 43min.
  • Creation of an interactive Dashboard –> 5 lectures • 39min.

How To Create Ultimate Excel Dashboard for BEGINNERS

Requirements

  • A computer or laptop with microsift office 2016/2013/365.
  • The writing of basic formulas and are familiar with the Excel spreadsheet environment.

Create your own, interactive Microsoft Excel Dashboard from zero is not easy! so let me help you.

We all have the fear of starting from an empty sheet, and that’s fair but, with some quality tricks, you can do it. You just need a montor to guide throughout the process : that’s my job.

In this Excel Tutorial you will learn :

  • How to create an impressive and interactive Excel Dashboard from scratch by combining Pivot Tables, Pivot Charts, Slicers, and a beautiful design concept.
  • How to create a beautiful background and gradient tile design for an Excel Dashboard from scratch.
  • How to create a modern and minimalistic Pivot Slicer Design for your Dashboard.
  • How to make the Pivot Tables and Pivot Charts in Excel automatically refresh when the source data changes.
  • How to create a custom interactive Info Button for our interactive Excel dashboard that allows us to display additional information without requiring any additional space in the dashboard.
  • How to create custom interactive dashboard tabs that allow us to display additional content (e.g. charts) without requiring any additional space in the dashboard.
  • How to create custom collapsable and interactive settings menu in Excel that can be perfectly used to control the visual appearance and behaviour of a dashboard.

 

 

Get Tutorial