Category Archives for "Top Tips"

14 Top Tips for a SWOT Analysis that Works

Career , Strategy , SWOT Analysis and Action Plan , SWOT Analysis and Action Plan , Top Tips

A good SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats/Trends) identifies factors that impact your Strategic Business Objective, tactic, project, or product. Use these tips to make sure your SWOT is BETTER THAN GOOD! If you already consider yourself experienced with conducting SWOT Analysis, check tips 8, 10, 11, 12, and 13 for tips that may be […]

Continue reading

19 Top Tips on Excel’s IF Functions and Formulas

Excel , Functions , Top Tips

Excel’s IF function makes If…Then… decisions in your workbook formulas. The IF function and its variations are a must if you want to build powerful worksheets that go beyond simple math or financial calculations. If you already consider yourself an IF function expert, you might want to check Tips 7, 9, 13, 14, and 19 […]

Continue reading

Top 12 Tips for Success with Your SMART Goals

SMART Goals , Time Management and Personal Productivity , Top Tips

SMART goals are well-defined goals that can be personal or business focused. These tips will help you create, write, and achieve your SMART goals. 1. SMART Stand for… Specific Specify the goal in concise and precise terms Make it short and memorable so it is clear Measurable Success must be clearly measurable Set measurable mid-stage […]

Continue reading

Top 26 Best Excel Conditional Formatting Tips and Tutorial

Excel , Formatting , Top Tips

Conditional formatting in Excel applies formatting to cells when the cell’s content meets specific conditions, such as the content being greater than a number you specify. These top 26 best tips on Excel conditional formatting begin with the basics tips and progress to advanced tips, like using conditional formatting to find errors, using wildcard matches […]

Continue reading

Top 16 Best Excel Function and Formula Tips Every Excel User Should Know

Excel , Formulas , Functions , Top Tips

These are the top 16 Excel function and formula tips every Excel user at any level of experience should know. Even “experts” can learn new tricks or combine old tricks to work faster and more efficiently. As you scan these tips keep a “beginner’s mind.” A beginner’s mind helps you see new opportunities and insights. […]

Continue reading

Top 23 Excel Formatting Tips

Excel , Formatting , Top 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 VLOOKUP Tips and Tricks

Excel , Formulas , Functions , Top 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

Top 29 Pivot Table Tips

Excel , Pivot Table and PowerPivot , Top Tips

It is easy to say that Pivot Tables and Power Pivot are the two most powerful features in Excel. I don’t mean time saving as with Excel VBA macros, but rather they are powerful because the decisions made from Pivot Table (and Power Pivot) results drive key business decisions. I’ve built tons of Pivot Tables […]

Continue reading

Download the Top 25 Dashboard Design Tips Sheet PDF

Dashboards , Excel , Top 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 Tips on Excel Dashboards

Dashboards , Excel , Top 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