Excel Dashboard Templates

Hack Excel Protect WorkbookSo you forgot / lost your password and need to update your workbook tabs or structure? Well don't cry, don't complain, we can Hack...

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. Steve=True

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...

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 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 I had a recent request from a friend who needed to Find and Repace from a list of old emails with new...

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 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...

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 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...