We try to create templates for Excel that don\’t require much experience. However, knowing more about Excel can help you get more out of the templates. In addition to the blog posts below, see our Excel Tips and Excel Articles pages to learn about Excel.
In December, 2020 we released a new version of Gantt Chart Template Pro that is designed to consolidate multiple versions and features into a single template. It is available to both new and current customers. Existing customers can return to [...]
I love using drop down lists in Excel. In this article, I’ve tried to explain all of the techniques that I use for making drop-down lists, including simple yes/no options, checkbox substitutes, dependent lists for sub-categories, and using dynamic named ranges.
A one-stop reference for using Unicode character symbols in Excel, including ways to insert symbols and how to use them in drop-down lists, number formats, etc. Also includes tables of newer Unicode symbols.
One of the best ways to learn new techniques in Excel is to see them in action. This post demonstrates how to add some fun and useful features to simple to do lists, including drop-down lists, check boxes, and progress bars.
Microsoft Excel 2016 has brought us six new built-in chart types: Waterfall, Histogram, Pareto, Box & Whisker, Treemap, and Sunburst. The addition of these new charts is largely due to user feedback and requests. This Page (contents): The Waterfall Chart [...]
Check out a proposed new feature for Gantt Chart Template Pro that will let you show both the original task dates and the current dates in the same chart.
Sparklines are little in-cell charts that can help you analyze your data. This article shows examples of the three types of sparklines available in Excel 2010 and 2013.