Excel Interactive Dashboard with Formulas
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Interactive Dashboard with Formulas to your Wishlist.

Add to Wishlist

Excel Interactive Dashboard with Formulas

Create fully dynamic interactive Excel Dashboards and take your career to the next level.
New
5.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Created by Ramzan Rajani
Last updated 8/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You will be learning techniques of creating Dashboard with Formulas
  • Creating Dropdown List
  • Creating Combo Button
  • Creating LIst Box
  • Creating Scroll bar and Linking it to Cell
  • Creating HR Dashboard
  • An Interesting Fully Dynamic Sales Dashboard
View Curriculum
Requirements
  • Participant should know basic Excel Formulas
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)

Who is the target audience?
  • Analyst, Finance, HR, Sales & Marketing
Compare to Other Excel Dashboard Courses
Curriculum For This Course
15 Lectures
02:54:22
+
Introduction
15 Lectures 02:54:22


Please download the attached Practice file, which we will be using during entire training.

Practice Dashboard Creation Technique 1 Step by Step
09:56

Query Solved on Tutorial 1 asked by Participant
11:41

Creating Radio Button
17:38

Query Solved on Radio Button asked by Participant
03:56

Combo box & List Box
11:17

Creating Scroll Bar
12:13

Tutorial on Grouping Scroll bar & chart for Moving one place to another
00:58

HR Dashboard Creation
37:18

Project --> Sales Report Dynamic Dashboard Step by Step
08:40

Part 1 Solution --> Sales Report Project
12:29

Part 2 Solution --> Sales Report Project
13:52

Part 3 Solution --> Sales Report Project
09:59

Creating Combination Chart (Sales vs Target)
02:36
About the Instructor
Ramzan Rajani
4.6 Average rating
320 Reviews
5,721 Students
3 Courses
Microsoft Certified Trainer & Microsoft office Specialist

Ramzan carries more than 15+ years of experience in the field of IT Training & Project Management. After getting his Diploma in Information Technology he did his MBA with Dual Specialization in IT Project Management.

He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA - Macros programming, advance Powerpoint, Excel Dashboard, MS Access & MSP (Microsoft Project).

Along with other companies around the world he has done trainings for the following companies in UAE - Dubai : Manipal University, Etisalat, World Bank Group, Sharjah Islamic Bank, Emirates NBD, Redbull, Carestream health, Rotana, Funcity, Johnson & Johnson, Mastercard, Dulsco, AstraZeneca & MAF (Majid al Futtaim Properties).

Ramzan is based in Dubai.