Featured Formulas

Text

Validate strong password

In this example, the goal is to check for "strong" passwords. What makes a password strong depends on the rules it must follow. In this case, a strong password must meet the following six conditions:

  1. At least 8 and not more than 15 characters long
  2. Contains at least one
    3. ...Read more
More Formulas

Featured Videos

More Videos

Featured Functions

Math

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied. When you first encounter...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I struggled for days with a Excel formula problem. I have several books on Excel including the Dummies series. Nothing helped. One hour on your website, and everything fell in place for me. Clear and concise instructions along with many excellent examples did the trick.
Grampi
I just stumbled upon your website and have to say that it is the best resource I have stumbled upon in many years. I'm definitely going to add it to my bookmarks.
Ricardo
I also wanted to let you know that I learn a ton a get a lot of value from your tutorials. Very much appreciated.
Patrick
More Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages