Featured Formulas

Featured Functions

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array. The result from VSTACK is a single array that spills onto the worksheet into multiple cells.

...Read more

Recent Articles

I am a software engineer with 10+ years of programming experience, but I had to learn advanced Excel material for a new job that used it primarily and I found the official Microsoft documentation a bit vague and uninstructive until I found your website, which helped me implicitly understand a lot about the internal workings of Excel's formulas and matrix treatments through your explanations and examples.
Jay
Just needed to get the syntax right for advancing a DATE cell by one and while only using Monday through Friday. With the help of your site, I cobbled it together. Thanks a bunch!
He
I find your site a fantastic resource. I have dramatically improved my Excel skills simply by looking at your emails and videos!
Stuart

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