Excel - Graphics Prototyping with SmartArt - Episode 1891
2,454 views · Published 20 June 2014 · 5:12 · Indexed 10 November 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: If you are great at Excel and lousy at Photoshop, why not use the Excel SmartArt tools to rapidly create prototype graphics for your web designer? All you have to worry about is the message and Excel will make the graphics look good. Welcome back to the MrExcel podcast. In this episode, we will be discussing the use of Excel SmartArt for rapid graphic prototyping. As I was reading the book "Dave's Way" by Dave Thomas, I was reminded of the importance of simplifying things in order to be successful. This concept can also be applied to our homepages, which often have too many confusing options for visitors. In this video, we will explore how to use SmartArt to create prototypes for a more streamlined and effective homepage. SmartArt is a powerful tool that has been available in Excel since 2007. It can be found on the INSERT tab and offers a variety of options for creating graphics. With SmartArt, you can easily craft your message and choose from a range of formats and colors to find the best way to present your information. This is especially useful for those who are not proficient in programs like Photoshop, as SmartArt allows for quick and easy changes without sacrificing quality. In this video, we will walk through the process of creating a prototype using SmartArt. We will start with a blank sheet and choose a category, such as list or process. From there, we can add our text and even demote or promote levels to create a more dynamic graphic. With the ability to change colors and formats, SmartArt offers endless possibilities for creating professional-looking graphics. I have been a big fan of SmartArt since its release and even wrote a book on the topic, "Leveraging SmartArt Graphics". This book is available as an e-book on Amazon and InformIT, and is a great resource for those looking to further explore the capabilities of SmartArt. As an Excel expert, I believe that using Excel for rapid prototyping is a logical choice, and I am excited to share this technique with you in this video. So join me as we dive into the world of Excel SmartArt and learn how to create effective prototypes for your website or project. With its user-friendly interface and endless customization options, SmartArt is a valuable tool for any Excel user. Thank you for watching and be sure to check out our other netcasts for more Excel tips and tricks. See you next time on the MrExcel podcast! 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/ Table of Contents: (00:00) Using Excel SmartArt for Rapid Graphic Prototyping (00:25) Simplifying Choices on a Website Homepage (00:41) Creating Prototypes with SmartArt (01:01) SmartArt Tools and Design Options (01:14) Changing Colors and Themes (01:52) Different Layout Options for Presenting Message (02:40) Rapid Prototyping with SmartArt (03:17) Book Recommendation: "Leveraging SmartArt Graphics" (03:50) Using Excel for Rapid Prototyping (04:05) Creating a New SmartArt from Scratch (04:50) Adding and Demoting Shapes (05:02) 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: Columbus Ohio Dave Thomas Excel SmartArt Leveraging SmartArt Graphics Menu choices Photoshop alternative Prototype creation Rapid graphic prototyping Simplifying options Wendy's restaurants Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153715/ The SmartArt book is on sale at http://www.tinyurl.com/smartart14
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:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920