LATEST ARTICLES

How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue (and 20% off Dashboard Class)

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 cells when you use your arrow keys.Also, don't forget to...
Create Vertical Line Between Columns in Excel with Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars

Create a Vertical Line Between Columns in Excel Using Error Bars Thanks to Leonid (a super fan) for advising me on another and possibly better technique to create a vertical line between columns in your...
Excel Dashboard Course

Add Vertical Line Between Columns in Excel Stacked Column Chart

Add Vertical Line Between Columns in Excel Stacked Column Chart In this tutorial, you will learn how to QUICKLY add a vertical line between columns in a stacked column chart to visually separate your graph...

Replace Numbers with Text for Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values

Replace Numbers with Text in Excel Radar Chart Axis Values This is a cool Excel Trick that I just created based on a user request to change Excel Radar Chart Axis values from numbers to...
Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find and Repace from a list of old emails with new...



New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting

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 that have been using Excel for a long time.  I...
How-to Add Edges to Excel Area Charts

How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart

How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart A stacked area chart displays an area of points above other data points and connects them to the next category.  However, there is...

How-to Easily Add Task Information to Excel 2016 Gantt Charts

Easily Add Task Information to Excel 2016 Gantt Charts Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted a request from a fan that asked how to add...
How-to Add Resource Names to Excel Gantt Chart Tasks

How-to Add Resource Names to Excel Gantt Chart Tasks

How-to Add Resource Names to Excel Gantt Chart Tasks I recently received a request from a fan that asked how he could add resource names to Excel Gantt Chart that he had created.  The technique...



Excel Formula Formatting Quick Tip

Excel Formula Formatting Quick Tip Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use these simple techniques for all of your Excel Formulas going...