Top Tips

Top Tips Blogs

Top Tips blogs include collections of the top techniques and shortcuts for optimizing your career, workflow, and business.

Lists of tips include blogs covering topics like,​

  • Strategy and execution
  • Work flow improvements
  • Personal and professional productivity
  • Microsoft Excel shortcuts
Top Tips Icon
19 Top Tips on Excel Advanced Filter and Excel AutoFilter
Excel AutoFilter is a simple Excel feature for filtering lists. But, the Excel advanced filter has far more powerful filtering[...]
18 Top Tips for Creating Excel Lists or Excel Tables
People love putting their To Do List, Contact List, and Project Task List in Excel. These tips will show you[...]
10 Top Tips for Creating an Excel Budget or Excel Budget Template
Excel is the world’s most used tool for creating, aggregating, and analyzing budgets. Distributing an Excel budget template will reduce[...]
14 Top Tips for a SWOT Analysis that Works
A good SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats/Trends) identifies factors that impact your Strategic Business Objective, tactic, project, or product.[...]
19 Top Tips on Excel’s IF Functions and Formulas
Excel’s IF function makes If…Then… decisions in your workbook formulas. The IF function and its variations are a must if[...]
Get Max Productivity from these Windows 10 Tricks
My son goes to a technology high school where they build robots, do experiments with DNA, and play with stuff[...]
Top 26 Best Excel Conditional Formatting Tips and Tutorial
Conditional formatting in Excel applies formatting to cells when the cell’s content meets specific conditions, such as the content being[...]
Top 16 Best Excel Function and Formula Tips Every Excel User Should Know
These are the top 16 Excel function and formula tips every Excel user at any level of experience should know.[...]
Top 23 Excel Formatting Tips
These are the top 23 best tips on Excel formatting taken from research on top-ranked Excel websites and judged by[...]
Top 21 VLOOKUP Tips and Tricks
Use VLOOKUP to find and retrieve data from an Excel list. This list of the top 21 best VLOOKUP tips[...]
Top 29 Pivot Table Tips
It is easy to say that Pivot Tables and Power Pivot are the two most powerful features in Excel. I[...]
Download the Top 25 Dashboard Design Tips Sheet
A lot of readers were interested in the Top 25 Best Dashboard Design Tips article. It had the second highest[...]
Top 25 Tips on Excel Dashboards
This is a collection of tips that will help you create powerful Excel dashboards. This ranked list started by collecting[...]
Top 5 Excel Funnel Charts Sales and Marketing Love — One Funnel Chart You Should Never Use — And Two Dynamic Funnel Charts in PowerPoint!
This blog will show you five different ways to make funnel charts in Excel and two ways to link Excel funnel[...]
Top 17 Business and Personal Productivity Tips
Last week’s newsletter contained the Top 25 Excel Dashboard Tips by page views from 2015 articles in Critical to Success. This[...]
Top 25 Best Excel Dashboard and Chart Tips for 2015
Tony Robbins and other performance gurus who strive to improve personal performance teach that one of the most powerful ways[...]
Top 30 Best Excel Chart and Dashboard Tips in the “Excel Chart and Dashboard Quick Reference Guide”
Get your free copy now of the Excel Chart and Dashboard Quick Reference Guide. Quick Reference Excel Charts and Dashboards - US[...]
Top 7 Sparkline Tips
Here are some tips on working with Excel Sparklines. If you want to... then do this…    Change the size[...]
Top 11 Best Dynamic Excel Chart Tips
Dynamic Excel charts automatically customize and update charts, allow users to scroll through time and select data, and give greater[...]
5 Top Budget vs Actual Excel Charts You Need
Here are five of the easiest to create and cleanest budget vs. actual (target) Excel charts. I spent three hours[...]
Share the power...