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

Watch on YouTube

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