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.
Welcome to the Vertex42 Blog
Our most recent articles are listed below. To jump to a specific category of posts, see the category list to the right. The links at the top of this page will take you to some of our most popular collections of Excel and Word templates.
Over the years we've created many different types of calendar templates. Choosing the right calendar for the situation is a big part of keeping your daily life in order. Below we talk about 10 ways to use calendar templates effectively to help at home, work and school. Quick Links: 1: Easy reference for your wall [...]
Microsoft Excel 2016 has brought us six new built-in chart types. The addition of these new charts is largely due to user feedback and requests. Here is the list of the new charts: 1. Waterfall2. Histogram3. Pareto4. Box & Whisker5. Treemap6. Sunburst Each of these has its own special scenario-based application, but they all take [...]
We've just released a new (beta) version of Gantt Chart Template Pro that is designed to be a lot easier to use. It is available to both new and current customers. Existing customers can return to the download page to get the new version (no new purchase necessary). When I first created the Gantt chart [...]
Use conditional formatting in Excel to display your data as a calendar chart to visualize data over days, weeks, and months. This post explains how to use the template and answers some questions about how it was created.
Try the new version of Gantt Chart Template Pro, designed for Excel Online (Office 365), Excel 2010+, and Excel for iPad/iPhone.
Looking for PowerPoint templates? Here are a few great resources to help you create a great presentation without having to design your own theme.
Use Vertex42 spreadsheet templates and documents on your iPhone and iPad with the new Office Mobile app for iPhone and Excel/Word for iPad.
Microsoft launches a new Templates site for Word, PowerPoint, and Excel. Is it going to be a store with some stuff free and some not?
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.
The authors at Vertex42.com have created a workbook that demonstrates over 140 essential Excel tips and tricks.
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.
Learn how to create a drop-down list to select the next date or next check number when updating lists of transactions or adding log entries.
This page is for answering questions about Gantt Chart Template Pro that might not already be answered via the Help worksheet inside the spreadsheet.
Did you know that you can use the Excel Web App to edit spreadsheets on your iPad? Here are my observations after testing many of my Excel templates.