Featured Formulas

Capitalize first letter in a text string

One of the most important skills to learn with Excel formulas is the concept of nesting. Put simply, nesting just means putting one function inside another. Nesting is super useful, but it does take some practice. You have to learn to read a formula from the inside out. The formulas below...Read more

Featured Functions

WORKDAY Function

The WORKDAY function calculates a date that is a given number of working days from a specified start date, automatically excluding weekends and, optionally, holidays. You can use the WORKDAY function to calculate project start dates, delivery dates, due dates, and other dates that must...Read more

Recent Articles

Your website is the best. I really appreciate all of the concise descriptions, it has helped me in countless ways over the last few years as an analyst. Invaluable information.
John
Today I could not resolve a problem she was having. Went to Google to access the world of opinion and I got a hit on your website. Yes. You guessed it - you solved my problem for me in really quick time - an exact match. I am hugely impressed.
Garth
First and only stop for Excel formula help. You have made the world a better place.
Darin

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