Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.

Have you ever found yourself buried under a mountain of Excel spreadsheets, painstakingly updating formulas every time new data comes in? It’s a common struggle, one that can turn even the most ...

Save time on status decks with a reusable Excel timeline chart. Data lives in a table, so new milestones update the timeline ...

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps. Follow ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...

An curved arrow pointing right. Here's a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.