Excel - Master Excel 2010's Game-Changing Sparklines Feature for Easy Data Analysis - Episode 1070

1,606 views · Published 31 July 2009 · 4:24 · Indexed 29 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel's Game-Changing Sparklines Feature for Easy Data Analysis.

Welcome to another exciting episode of the Dueling Excel podcast! I'm Bill Jelen from MrExcel, and joining me later is the one and only Mike Girvin from Excel Is Fun. Today, we're not competing against each other, but rather, we're both going to be raving about a new feature in Excel 2010.

We're lucky enough to have access to the technical preview of Excel 2010, but the official version will be released in early 2010, possibly in April. And let me tell you, there's one feature that has us both giddy with excitement - SPARKLINES.

If you've ever looked at a table of data and struggled to see the overall trend, then you'll understand why SPARKLINES are such a game-changer. With just a few clicks on the INSERT tab, you can now add tiny, word-sized charts to each cell in your data. These SPARKLINES are customizable, allowing you to highlight high and low points, as well as change the colors to your liking.

But SPARKLINES aren't just visually appealing, they also serve a practical purpose. For those who may not be as comfortable with numbers, SPARKLINES provide a quick and easy way to see if things are trending up or down. It's like having a mini-chart right in your spreadsheet!

Now, let's hear from Mike about his thoughts on SPARKLINES. As a self-proclaimed Excel statistics guru, Mike is blown away by the new functions in Excel 2010. But what really has him excited is how SPARKLINES have revolutionized the way he creates charts for his data sets.

Gone are the days of using the chart wizard multiple times for each data set. With SPARKLINES, Mike can quickly and accurately create column charts for all his data sets in one go. And the best part? These SPARKLINES are linked to the data, so any changes made to the data will automatically update the charts. It's like magic!

Not only are SPARKLINES faster and more accurate, but they also look better. Mike demonstrates this by comparing a traditional chart to a SPARKLINE chart, and the difference is clear. SPARKLINES truly blow the chart wizard out of the water.

So there you have it, folks - SPARKLINES in Excel 2010 are a game-changer. Whether you're a numbers person or not, these tiny charts will make analyzing data a breeze. Thanks for tuning in to another episode of the Dueling Excel podcast, and be sure to join us next time for more Excel tips and tricks.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Sparklines are tiny, word-sized charts that can appear in a cell. Excel 2010 makes it easy to create sparklines. In Episode 1070, Mike & Bill show you several examples in Excel 2010.

Table of Contents:
(00:00) Introduction to Excel 2010 and new feature SPARKLINES
(01:13) Explanation and demonstration of SPARKLINES feature
(01:50) SPARKLINES as a useful tool for non-numerically oriented individuals
(02:00) Transition to Mike Girvin's thoughts on SPARKLINES
(02:11) Mike Girvin's excitement for Excel 2010 and its new features
(02:21) Comparison of SPARKLINES to traditional charting methods
(03:02) Demonstration of SPARKLINES for statistical analysis
(03:34) Advantages of SPARKLINES in terms of speed and accuracy
(03:51) Conclusion and wrap-up of Excel 2010 features
(04:04) Future plans for exploring more Excel 2010 features
(04:14) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Accuracy and speed
Chart wizard
Edward Tufte
Frequency
Line, column, and win-loss sparklines
New feature
Numerically oriented
Sparklines
Statistics
Tiny word size charts
Trending up or down

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152547/

More from this channel