Creating Dashboard in Excel

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Thanks for taking interest in learning the Excel Dynamic Dashboard.

I will teach you step by step how to create Dashboard from Huge database.

All this you will learn with Advanced Formulas techniques. No third party software required, no add ins required.

You will learn how to create

1) Drop down

2) Checkbox

3) Radio button

4) Scroll bar with practical projects.

5) Combination Chart

6) Dynamic HR Dashboard

7) Interactive Sales Dashboard

In this course i have not spent much time on Formatting, so only Core aspect of Dashboard construction which you need i have explained.

(Practice files available for all the topics)

Expected Outcomes

  1. You will be learning techniques of creating Dashboard with Formulas
  2. Creating Dropdown List
  3. Creating Combo Button
  4. Creating List Box
  5. Creating Scroll bar and Linking it to Cell
  6. Creating HR Dashboard
  7. An Interesting Fully Dynamic Sales Dashboard