Learn an Easy and FAST way to Find and Replace from a List versus the slow way of one at a time and without VBA. Find/Replace email addresses, names, products, codes and any other changes ne
Use a great new feature of Excel 2013 and Excel 2016 - Flash Fill - to save time getting your data from text strings. Read the article now and save a ton of time!
Stacked area charts connect points of data over several data points, however if you have blank data or zeros, you need to know how you can add clean breaks or cliff edges to an Excel Area Ch
Learn how you can add resource names, percent complete or any other task details in ALL TYPES of Excel Gantt Charts.
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 can quickly select and align charts for your f
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
Learn several techniquest to Copy a Chart and modify the copy of the chart to change the data series range references to a new area in your worksheet.
This quick tutorial will show you how-to copy an Excel Chart on Same Worksheet such that it uses a new data reference instead of the original reference.