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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919