Look Who it Was Random video

Excel - Excel Data Visualization: Upgrade and Revolutionize Your Data Analysis! - Episode 653

774 views · Published 19 March 2009 · 3:18 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Data Visualization: Upgrade and Revolutionize Your Data Analysis!

Welcome back to the MrExcel netcast where we explore all things Excel. I'm Bill Jelen and this week, we're diving into the world of Excel 2007. This version of Excel introduced some amazing new features, including data visualization tools that are perfect for those non-numeric managers who struggle to make sense of columns of numbers.

Have you ever had a manager whose eyes just glaze over when you show them a report filled with numbers? Well, Excel 2007 has the solution for you. With the new data bars feature, you can easily create a visual representation of your data that will instantly draw your manager's attention to the most important numbers. Simply choose a color and Excel will automatically assign the largest numbers the largest swath of that color, making it easy for anyone to understand the data at a glance.

But that's not all, Excel 2007 also introduced color scales and icon sets for data visualization. With color scales, you can set up a three-color scale from green to red, with the largest numbers in green and the smallest in red. And with icon sets, you can use familiar symbols like traffic lights or cell phone power bars to represent your data. These tools are perfect for highlighting key performance indicators and making it easy for non-numeric managers to understand the data.

One of the best features of Excel 2007 is the live preview option. This allows you to hover over different data visualization options and see a live preview of how they will look on your data. No more trial and error, just hover and choose the one that looks best. And even if your company hasn't upgraded to Excel 2007 yet, it's important to be aware that many vendors and customers may start sending files in this format. But don't worry, there is a free converter available for older versions of Excel.

So, whether you're a seasoned Excel pro or just starting to explore the world of spreadsheets, Excel 2007 has something for everyone. With its user-friendly data visualization tools, even non-numeric managers can easily understand and analyze data. So, don't wait any longer, start exploring Excel 2007 today and see how it can revolutionize the way you work with data. Thanks for watching and be sure to tune in next time for more Excel tips and tricks from MrExcel.

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/


Do you have a manager whos eyes glaze over when presented with a column of numbers? Excel 2007 offers some new amazing data visualizations. Episode 653 shows you how.

Table of Contents:
(00:00) Introduction to Excel 2007
(00:23) New data visualization features
(00:33) Using data bars and color scales
(01:10) Icon sets for visualizing data
(01:45) Live preview feature
(02:22) Importance of upgrading to Excel 2007
(02:58) 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 #tutorials 

This video answers these common search terms:
Benefits of upgrading to Excel 2007
Color scale in Excel 2007
Conditional formatting in Excel 2007
Data visualization in Excel 2007
Excel 2002 and 2003 compatibility with Excel 2007 files
Excel 2007 features
Free converter for Excel 2007 files
Icon set in Excel 2007
Live preview in Excel 2007
Opening Excel 2007 files in older versions of Excel
Upgrading to Excel 2007
Using data bars in Excel 2007

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

More from this channel