Featured Formulas

List upcoming birthdays

In this example, the goal is to list the next n upcoming birthdays from a larger set of 25 birthdays based on the current date. The set of birthdays are in an Excel Table named data in the range B5:C29. In the example shown, we are using 7 for...Read more

Featured Functions

STOCKHISTORY Function

The STOCKHISTORY function retrieves historical stock price information based on a given symbol and date range. The main purpose of STOCKHISTORY is to get the history of a financial instrument over time. Although the name suggests that STOCKHISTORY is meant to work only with stocks,...Read more

Recent Articles

Your site is the best Excel resource, period. I first discovered you when I googled pivot tables and read "Can Pivot Tables Save Your Job". That article is so true! I've since developed expertise in regular Tables and made a workflow management tool for my job, which in turn has made me the only person in a collaborative of hospitals to be complete and on-time with data delivery. Because of this, I have proven value and credibility, and owe it all to developing my skills with your site.
Fred
Just wanted to thank you for the amazing content. I've been using Excel for quite some time now, and I've scoured dozens of sources that gave useless advice you'd have to squint to properly see and understand. I've hit two of your pages in two google searches in the past five minutes and am kinda cross with myself for not finding it sooner. I'm here to stay, guys. Thank you from the bottom of my heart.
Said
Just wanted to send a quick thank you for this website and all of the work you've put into it. Over the past year, I've been on a mission to improve my Excel game and your website has been my primary resource. It's super friendly and breaks things down in a way that's quick to put to use. We use Excel to manage large amounts of data at work and I've been able to implement some changes to our processes that are saving loads of time. In large part because of that, I was recently promoted to #2 in my department.
Mike

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