Need to create a project schedule? Try our Gantt Chart Template!

Excel Help

We mainly create templates, but we also write about general Excel topics to help you get more out of Excel and more out of our templates. Learn how to create drop-down lists, sparklines, and new charts in Excel 2016.

In addition to the blog posts below, check out our list of Excel Articles, especially our article about Theme-Enabled Templates which allow you to customize the colors and fonts in our templates with just a couple clicks of the mouse.

Create a Drop Down List in Excel

Create a Drop Down List in Excel

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.

Using Unicode Character Symbols in Excel

Unicode Character Symbols

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.

Add Cool Features to Your To Do Lists in Excel

Special Features in Excel Task Lists

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.

6 New Awesome Chart Types in Excel 2016

6 New Awesome Chart Types in Excel 2016 thumbnail

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

Creating Business Forms with Customizable Lists

If you use an invoice or order form in Excel routinely, you may come across times when it would be handy to select items from a drop-down list and have other information update automatically. Here is an example.

Make Sharing Easy – Create a PDF

PDF files have been around for a long while now and there is a reason they only increase in popularity – they make sharing documents with others a breeze. Created exactly for this purpose in 1993 by Adobe Systems, the [...]