www.specialskills.in
Home
ABOUT
Hall of fame
data management
Why Learn data management in MS Excel?
data management programs
VBA Solutions
data Management Refund Policy
Disclaimer
Caution
Contact
More
Grapho Therapy
Forum
Articles
Lyrics
www.specialskills.in
Home
ABOUT
Hall of fame
data management
Why Learn data management in MS Excel?
data management programs
VBA Solutions
data Management Refund Policy
Disclaimer
Caution
Contact
More
Grapho Therapy
Forum
Articles
Lyrics
Home
Forum
What tools can we use to create Excel dashboards?
What tools can we use to create Excel dashboards?
Rajesh Pathak
To create effective dashboards, one needs to have excellent knowledge of excel. One needs to know many things including below:
Excel keyboard shortcuts.
Preparing accurate worksheet workflow.
Great colour combination sense.
Well versed with the source data from which dashboard will be prepared.
Knowledge of many useful excel functions like Vlookup, Index & Match, Text functions, IFs functions, etc.
Knowledge of form control.
Knowledge of advanced chart techniques.
Knowledge of conditional formatting and data validation.
Knowledge of pivot table and advanced pivot table techniques.
Knowledge of shapes and objects.
Availability of a project based on which dashboard can be prepared by using above tools.
Homepage
MS EXCEL TRAINING
{"follow":"Follow","edit":"Edit","reply":"Comments","suggestedTopics":"Suggested Topics"}
+91-9971911018
-
Whats App
contact@specialskills.in
Dwarka, New Delhi, Delhi, India
(110075)