Jon Wittwer
About the author:
Jon Wittwer is the founder, president, and editor of Vertex42.com. In 2003, Jon combined his interest in web development with his love of Excel to create what would become the Vertex42 you see today. Jon has a Ph.D. in mechanical engineering, but now spends the majority of his time creating, improving, and writing about the spreadsheet templates that are being used by millions of people and businesses all over the world. View Jon’s Vertex42.com Profile.
A Volatile Function such as RAND, TODAY, OFFSET, or INDIRECT is recalculated every time Excel recalculates. That may be a problem, or it might not be. This article explains why volatile functions may slow performance and also explains why I love them so much.
A Dynamic Named Range is an awesome way to reference customizable lists. This article explains how to use OFFSET, INDEX, INDIRECT, CHOOSE, and IF to create dynamic ranges. It also explains formulas for finding the position of the last value in a range.
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.
Learn how to use both VLOOKUP and INDEX-MATCH and other powerful formulas to do lookups in Excel, from simple to advanced formulas, including multiple criteria and case-sensitive lookups and to get the last value in a range.
Learn how to Calculate Age in Excel using DATEDIF and other Excel formulas. Calculate age in years or a combination of years, months and days. Learn an accurate work-around for the “md” option.
Learn how to create your own custom functions in Excel using VBA. This articles explains the pros and cons of user-defined functions and provides examples.
20 Excel experts share their lists of favorite Excel functions. If you want to get more out of Excel, try using these functions in your work.
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.
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.
To access a template for Google Sheets or Google Docs, either click on USE TEMPLATE, or go to File > Make a Copy. Do not click on Request Edit Access.
Try the new version of Gantt Chart Template Pro, designed for Excel Online (Office 365), Excel 2010+, and Excel for iPad/iPhone.
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.
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.