Category Archives for "Tips"

Top 23 Best Excel Formatting Tips

Excel , Formatting , Tips , Top Best Tips

These are the top 23 best tips on Excel formatting taken from research on top-ranked Excel websites and judged by 30 years of using Excel (back when it came on about 14 diskettes). Even if you consider yourself an Excel expert, you should keep a “beginner’s mind” as you scan this list of 23 Excel […]

Continue reading

Top 21 Best VLOOKUP Tips and Tricks

Excel , Formulas , Functions , Tips , Top Best Tips

Use VLOOKUP to find and retrieve data from an Excel list. This list of the top 21 best VLOOKUP tips will take you from novice to master in retrieving data from Excel lists. You can use VLOOKUP to, Look up prices, names, or regions from a list Use one item to find related items in […]

Continue reading

Speedup Excel VBA Macros with Protect UserInterFaceOnly

Excel , Tips

Many Excel macros run on protected worksheets. If you use the little piece of VBA code in this article they will run a lot faster. Let me give you an example. I just finished a very robust Return on Investment calculator that has seven sheets of data entry, revenue forecasts, and output reports. It uses […]

Continue reading

Speedup Excel Performance

Excel , Tips

Regain faster performance with Excel 2013 (or newer versions) by turning off spreadsheet animation. Excel 2013 and newer versions use animation to make cell movements, filling cells, and even recalculation look smooth and fluid. For example, with animation filling a column with numbers makes the numbers appear to flow down the column. With animation on […]

Continue reading

Download the Top 25 Best Dashboard Design Tips Sheet PDF

Dashboards , Excel , Tips , Top Best Tips

A lot of readers were interested in the Top 25 Best Dashboard Design Tips article. It had the second highest newsletter readership. To make it easier to access these tips when you design dashboards, just click here to download a PDF with links, Top 25 Best Dashboard Design tip sheet. Keep it in your “Best Practices” […]

Continue reading

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

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

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
1 2 3 4