www.specialskills.in
Home
About
MICROSOFT
Recognitions AND CERTIFICATES
Microsoft excel training
MS Excel Refund Policy
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Caution
Contact
More
Grapho Therapy
Forum
Articles
www.specialskills.in
Home
About
MICROSOFT
Recognitions AND CERTIFICATES
Microsoft excel training
MS Excel Refund Policy
Caution
Contact
Services
Tech solutions
Business solutions
Music/Hobby Solutions
Online Trainings
Video Marketing
Social Media Marketing
Fashion/Graphic Solutions
Services Content Pages
Purchase flow and Refund Policy
Disclaimer
Caution
Contact
More
Grapho Therapy
Forum
Articles
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