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 EASILY Add Task Information to Excel 2016 Gantt Charts or ANY task information you desire like resource names or percent complete or other project task notes. Click now to
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
Check out How I Used Different Graphing Techniquest to Chart This Data in Excel, including Pivot Tables, Slicers and Multi-Level Labels.
See if you can Find Unique Values from CSV List in Excel. This is a tough challenge, but will show you how you to work with CSV files and Pivot Tables.