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.
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.
Use DATEDIF to Calculate Age in Excel
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.
How to Create Custom User Defined Functions in Excel
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.
How to Make a Dynamic Geographic Heat Map in Excel
As an alternative to Power Map or 3D Maps, learn how to create a geometric heat map in Excel using shapes and a simple VBA macro.
Experts Share Their 10 Favorite Excel Functions
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.
Using Unicode Character Symbols in Excel
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.
Case Study – Using Simple Tools for Project Management
What’s Your Project Management Style Do you have a proven process for project management and business success? Think about the tools you have in place to drive and track your business activities, projects and staff toward the common goal. Are you maximizing your time and capitalizing on activities that make sense? Hoping for the best [...]
Add Cool Features to Your To Do Lists in Excel
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.
10 Ways to Use Calendar 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 [...]
6 New Awesome Chart Types in Excel 2016
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 The Histogram Chart The Pareto Chart The Box and Whisker Chart The Treemap The Sunburst [...]
Analyze Data with a Calendar Chart in Excel
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.
How to Access Templates for Google Sheets and Docs
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.
New Gantt Chart for Excel Online
Try the new version of Gantt Chart Template Pro, designed for Excel Online (Office 365), Excel 2010+, and Excel for iPad/iPhone.
Presentation Templates for PowerPoint
Looking for PowerPoint templates? Here are a few great resources to help you create a great presentation without having to design your own theme.
Vertex42 Templates Going “iOS friendly”
Use Vertex42 spreadsheet templates and documents on your iPhone and iPad with the new Office Mobile app for iPhone and Excel/Word for iPad.