It is almost weekend. Today we (Jo and I) are going to watch a cricket match being played in Vizag. We are pretty excited as this is the first time we are watching a match in stadium.
So, let keep this light and fun. I want to know What is one area of Excel you want to learn more?
I will go first. I want to learn more about Data Tables & Simulation.
What about you? Go ahead and tell us using comments.
Note: Here are a few choices if do not know what else is out there.
- Formulas
- Array Formulas
- Formatting
- Conditional Formatting
- Charting
- Advanced Charting
- Pivot Tables & Charts
- Tables
- Data Tables
- Validation
- Filters & Sorting
- VBA (Macros)
- Linking to Databases etc.
- Solver
- Statistical Analysis (regression, time series etc.)
- Scenarios, What if analysis
- Dashboards
So go ahead and tell us.
7 Responses to “CP014: How to create awesome dashboards – 10 step process for you”
Very interested in topic unfortunately I get no sound when I play it.
Where can I get add ins for excel 2007
#Budala
Try using Google to search for Excel Addin
I would like to join your email newsletter.
@Andy
Goto: http://chandoo.org/wp/
The newletter registration is top Right corner
Hello Chandoo,
i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.
regards,
Shashak verma
Hi,
I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..
I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like