Loading...

Follow Vertex42 Blog on Feedspot

Continue with Google
Continue with Facebook
Or

Valid



Vertex42 has developed a new Savings Snowball Calculator to help you plan how to reach your savings and debt payoff goals. This article provides some background on the savings snowball concept and explains some of the features of the calculator. Questions and comments are welcome.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In Excel, an array formula allows you to do some powerful calculations that you might not be able to do any other way. Learn how to use both simple and advanced array formulas, including nested IF formulas, sequential number arrays, and matrices.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This is the ultimate guide to using Text Formulas in Excel such as SUBSTITUTE, LEN, CHAR, CONCAT, TRIM, LEFT, RIGHT, MID, FIND, SEARCH and others. The examples start simple and then build up to more advanced formulas including cleaning up data, splitting text into columns, and converting strings to arrays.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Vertex42 Blog by Jon Wittwer - 3M ago

SUMIF, SUMIFS, COUNTIF and COUNTIFS are very powerful functions for data analysis. The hardest part is learning how to define the criteria for different types of comparisons. This article shows examples of all the different criteria types, including matching blank and non-blank values.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Taking a break from Excel tutorials, this article compares paying off credit card debt to investing. Take an in-depth look at interest rates, liquidity risk, limited return, risk of principal loss, and tax efficiency. Perhaps debt payoff is really my best investment.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Learn how to use both VLOOKUP and INDEX-MATCH in Excel, from simple to advanced formulas, including multiple criteria and case-sensitive lookups and to get the last value in a range.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
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.
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free year
Free Preview