Tag: Tips and Tricks

Check out this simple technique if you have pressed the wrong keys on your keyboard and can't stop Excel from scrolling instead of moving...

Excel Flash Fill Every time a new version of Excel is released there are always new features that are hard to find and learn for those...

Select and Align Charts for an Excel Dashboard Creating dashboards can take a lot of time.  With this simple technique that I just learned, you...

Chart Conditional Labels and Callouts Learn how to make the simple and easy these Excel Chart Label Callouts: In my most recent article, I described how...

Selecting Ranges in Excel Have you ever had an issue using your mouse to select a large set of data in your Excel spreadsheet?  Have...

Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...

Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...

We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I...

When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you...

In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that...