www.specialskills.in
Home
About
MICROSOFT
MS Training attended
Microsoft excel training
MICROSOFT Events and Training
Caution
Services
Caution
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
Contact
More
Grapho Therapy
Articles
Forum
www.specialskills.in
Home
About
MICROSOFT
MS Training attended
Microsoft excel training
MICROSOFT Events and Training
Caution
Services
Caution
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
Contact
More
Grapho Therapy
Articles
Forum
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"}
9818052581
-
Specialskills.in
+91-9971911018
-
Whats App
contact@specialskills.in