Top 25 Best Tips on Excel Dashboards

Charts , Dashboards , Excel , Metrics and Measures , Tips , Top Best Tips

This is a collection of tips that will help you create powerful Excel dashboards. This ranked list started by collecting the top Excel dashboard tips from multiple search engine pages. After aggregated the tips I ranked them for usefulness based on 30 years of experience developing Excel dashboards and strategic performance projects. 1. Talk to Users. Build […]

Continue reading

Would You Like to Spy on Your Neighbor’s Dashboards? Here’s How.

Charts , Dashboards , Excel

Have you ever wanted to see how others have designed a dashboard? Or what another organization’s Balanced Scorecard looks like? Come on. I know you have. Why learn things from scratch when you can stand on the shoulders of other good ideas. Seeing how others approach a problem can show you where you forgot something […]

Continue reading

Do You Set Up Your Teams for Checklist Failure? 6 Steps to Checklist Success

Checklist , Communication Skills , Personal Performance , Team Performance

Checklists reduce death rates in hospitals by almost half, yet most hospitals fail when trying to use them. You might not be working in a hospital, but what they leaned will improve your teams… In any given surgical procedure, the number of steps and procedures that must be followed exactly can be huge. The chances […]

Continue reading

I didn’t get killed or crash the jet, but blindly following the checklist…

Checklist , Communication Skills , Work-Life

I didn’t get killed or crash the jet, but blindly following the checklist without considering the context created my most embarrassing moment. It was a typical summer afternoon at the US Air Force base in Arizona where as a lieutenant I was learning to fly a twin-engine jet. A “typical summer day” for Arizona means […]

Continue reading

The Best Excel Checklist

Checklist , Excel , Formatting , Personal Performance , Productivity Improvement

This Excel checklist template has a lot of features. It’s easy to create and modify and it could save you from serious mistakes. If you or your co-workers do important, repetitive tasks where a missed step could cause injury, failure, or serious problems, then you need to use a checklist. Download the Best Excel Checklist […]

Continue reading

Top 5 Best Excel Funnel Charts Sales and Marketing Love — One Funnel Chart You Should Never Use — And Two Dynamic Funnel Charts in PowerPoint!

Charts , Excel , Functions , Reporting , Tips , Top Best Tips

This blog will show you five different ways to make funnel charts in Excel and two ways to link Excel funnel chart data into PowerPoint slides. Funnel charts are a favorite of marketing and sales for showing the volume and progress through different stages of the customer journey, from initial contacts, to qualified leads, to prospects […]

Continue reading

This Pareto Chart in Excel Could Get You Promoted

Career , Charts , Dashboards , Excel , Pivot Table and PowerPivot , Productivity Improvement

There are two or three charts that every business person must know. Arguably two of the top ones are the break-even chart and the burn down chart. My vote for the third chart is Pareto’s Rule, the 80/20 Rule. This chart is the god of productivity improvement. Pareto’s Rule, and its chart, shows you where […]

Continue reading

Top 17 Best Business and Personal Productivity Tips

Charts , Creativity , Dashboards , Decision Making , Excel , Four Quadrant Model , Goals and Objectives , Strategy , Strategy Map , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan , Time Management , Tips , Top Best Tips

Last week’s newsletter contained the Top 25 Excel Dashboard Tips by page views from 2015 articles in Critical to Success. This week’s list has the 17 Most Popular Personal Productivity and Business Performance Tips from 2015. A few of these productivity and performance tips are in both lists, because they use Excel charting, like the Steven Covey […]

Continue reading

Top 25 Best Excel Dashboard and Chart Tips for 2015

Charts , Dashboards , Excel , Tips , Top Best Tips

Tony Robbins and other performance gurus who strive to improve personal performance teach that one of the most powerful ways to improve ourselves is by modeling. Modeling is watching others so you can learn how they perform a task better, then modeling our behavior after theirs. These are the top 25 best Excel dashboard tips […]

Continue reading

Top 30 Best Excel Chart and Dashboard Tips in the “Excel Chart and Dashboard Quick Reference Guide”

Charts , Dashboards , Excel , Tips , Top Best Tips

Get your free copy now of the Excel Chart and Dashboard Quick Reference Guide. Quick Reference Excel Charts and Dashboards – US Letter Quick Reference Excel Charts and Dashboards – A4 Critical to Success now has over 4,000 subscribers with 72% of you consistently opening and using its tips and tools. That is so Awesome! It makes me […]

Continue reading