Featured Formulas

Simple investing worksheet

A while back, I got from a reader about investing for his grandkids. The email asks the following question:

I hope you can assist me with an Excel calculation. I am keen to show my grandchildren the power of compound interest and the value of investing (patiently) for the...Read more

Featured Functions

SEARCH Function

The SEARCH function returns the position (as a number) of one text string inside another. In the most basic case, you can use SEARCH to locate the position of a substring in a text string. You can also use SEARCH to check if a cell contains specific text....Read more

Recent Articles

I was searching around for about 45 minutes, trying to find a simple way to count the number of cells in a range which had any number in them. I saw MANY attemps: VisualBasic, Regular expressions which required a huge overhead of code to load, dizzyingly complicated MOD and STR and LENGTH functions strung together in mind-bending combinations, and then... I found yours. Simple, elegant, and ultimately malleable to other purposes. I copied, pasted, modified, and BAM! I was done and it worked *perfectly*!
Dana
This is a great web site. Have been using it for a while and getting your Friday email. I learn something new every time I get the email or visit your site.
George
What a nice job. Your web site is my "go-to" place for any help with Excel!
Vimal

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