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

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

Show or Hide Data and Charts with Dynamic Excel Reports

Excel , Reporting , VBA

With a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected sales regions or to expand a table to show […]

Continue reading

Bet You Don’t Know the Difference! Goals or Objectives? Mission Statements or Vision Statements?

Strategy

If your meetings use terms like vision and mission, goals and objectives, and strategy and tactic, then I bet you some people are using these words wrong. That can throw off your meeting and you will end up with mixed messages in your end product. Do You Know the Difference? Goal, Strategy, Objective, Tactic Forbes, […]

Continue reading

SMART Goals (Really SMART Objectives)

Strategy

You hear the term “SMART Goals” as a reminder of how to create clear, well-defined, and easy to communicate. (If you want to read why these are really SMART Objectives, click here.) SMART stands for, Specific Why? (purpose) What? (needs to be done) Who? (is going to do it) Where? (location and resources) Measurable Recordable […]

Continue reading

Top 29 Best Pivot Table Tips

Analysis , Excel , Formatting , Pivot Table and PowerPivot , Top Best 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

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