Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Inserting SmartArt

From: Excel 2010 Essential Training

Video: Inserting SmartArt

I want to show you a great feature in Excel called SmartArt and SmartArt will let you insert professionally made diagrams to enhance the quality of your spreadsheets, and you can customize them any which way you like. I think they are really cool. Let's take a look. Let's go up here to the Insert tab, because SmartArt is something that you insert and here in the Illustrations section is SmartArt. Click that and you get this dialog box coming up, and another look just shows you all these different categories and look what you have over here. I will just maybe start off with the List category and click any of these and you can see on the right it gives you a thumbnail of how it looks.

Inserting SmartArt

I want to show you a great feature in Excel called SmartArt and SmartArt will let you insert professionally made diagrams to enhance the quality of your spreadsheets, and you can customize them any which way you like. I think they are really cool. Let's take a look. Let's go up here to the Insert tab, because SmartArt is something that you insert and here in the Illustrations section is SmartArt. Click that and you get this dialog box coming up, and another look just shows you all these different categories and look what you have over here. I will just maybe start off with the List category and click any of these and you can see on the right it gives you a thumbnail of how it looks.

So we have Lists, we have Process Charts of how one thing goes to another, Cycle Charts, hierarchies of how one item relates to another item, and these are great. Don't worry if the colors aren't to your liking because I am going to show you how you can customize all of these and you might want to look through these on your own. I am going to go here to List. Now, I am going to choose this one here, Vertical Box List. Let's just double-click that and it puts it onto the page out. It's a little bigger than we want. So put your mouse-pointer on any of the four corners and when your mouse pointer turns to this two-headed arrow, just shrink it here a little bit.

I am just going to drag this over here to the right, and before we format it, let's put in some information and you notice over here we have these sales people who have sold products. What I want to do is I want to take maybe the first three or four. That is the top three or four sales reps and put their names over here, and specify where they sold their products. So click over here in the first text box and it blanks out, and let's type the name of the first person. Now, instead of clicking and typing, clicking and typing, there is a nice little text box where we can enter this information.

Over here on the left you see we have this two-headed arrow. Click that and that brings up the text box and click on this third bullet here and just press the Backspace key. When you do that, you remove the bullet and you see this is dynamic and removes up the other text box. So let's type in the name of the second person, and press Enter, and we will do the fourth person as well. When you do that, it puts up the information. Well, what we want to do is we want to say where did each of these people go to make their sales? How do they get to be such good sales rep? So click after the name of the first person, press Enter and Excel thinks, oh! We just want to put in another box, but we don't.

So press the Tab key on the keyboard, when you do that, it indents and will put a sub-bullet under there. If you're familiar with PowerPoint, it's the same idea. So let's say this sales rep went to San Francisco. Click after the second person and maybe that guy went to Los Angeles and this person here went to New York, and this person here maybe went to Atlanta, and that's great! Now, you can close the text box by just clicking that X.

If you want to open it up again, in addition to this two-headed arrow over here, and as we're in the SmartArt tools category in the Design tab, we have this Text Pane box, and that will also let you open it and close it. That's great but we need to format it to make it look more like our olive oil company. Let's just drag this in position here. Make sure that the whole box is selected and again in the SmartArt Tools category in the Design tab, we have this Change Color button. Click the down arrow and mouse over some of these and notice the diagram underneath is changing dynamically. I am not clicking anything.

I am just rolling the mouse over. So this is really great way of getting a preview. I am going to go here in the second one under Accent3 and click that. So we have nice green color. But we can format this a little further. Still on the same Design tab to the right of Change Color we have the Styles. Click this little down-arrow right over here and you can mouse over any of these to get a preview of how it's going to look, and let's choose this one. I think it has a nice three-dimensional look to it. Let's deselect that. I want to show you a SmartArt that will let us put in some graphics.

So go back to the Insert tab and again click SmartArt. I am going to stay with List, but if you scroll down here a little bit, this one over here is Horizontal Picture List. I think it kind of looks like little gas pumps, and double-click that and it puts it on your page again. Much too big for us. So put your mouse pointer on any of the four corners, shrink it a little bit more, and I will drag this over here to the right. What we want to say is these people who went on these trips and who sold all of these products, what were they selling? And we want to tell what are the three best products.

First let's fill in the text. So rather than clicking on these boxes, click this two-headed arrow and let's say the first thing they sold was a Gift Pack. Let's go down over here. Now if you want to, you can stretch this box out. Let's click on that third bullet and just press the Backspace key to delete it, and you notice just like the other piece of SmartArt, it adjusts automatically. They also sold the Garlic Product, press Enter, so we get the third box back again, and they also sold the Herbs product.

Let's just close this text box. Let's do some formatting here and go ahead and make sure that the SmartArt itself is selected in the SmartArt Tools category. In the Design tab, let's go back to Change Colors and just like before you could mouse over, not clicking anything, just rolling the mouse over, looking at the colors and again I am going to choose the second one here in the Accent3 category. Again, go back to SmartArt Styles, click this down-arrow, and by the way any of these drop-downs, you can also stretch them, make them taller or shorter, and roll over some of these, and just to be consistent I am going to use this style here.

You might be wondering all this time, okay that's great but what are those three little boxes on top? That's what allows us to put in pictures. Click the first one here and this allows you to insert the picture in the Chapter 5 folder of the Exercise Files. Double-click the gift pack and it just pops right in. Click the second box above Garlic and we have the Garlic product, double-click that, and click the third box on top of Herbs and here we have our Herbs product and it pops right in, and you notice it sizes these appropriately, and click some here to deselect, so you can take a look. Now, there is couple of other things we can do with this.

Click back on the SmartArt border and in the SmartArt Tools category, go to the Format tab, and you see we have these WordArt Styles. Click this down-arrow and again I am just going to shrink this here to get a better look. As you roll your mouse over these, notice that the text is changing and we didn't have to change any of the text at all. Scroll down. Now, some of these are not appropriate, they might be not even very legible, but this one here or this one here, I kind of like this one, just click it, and then we have again more of a three-dimensional maybe an embossed look and I will just deselect to get a better look.

So this is not so much a spreadsheet anymore of just boring dry numbers. This is a presentation. So if you need to present this to maybe a vice-president of sales saying hey, here's our sales reps and here's the products that they sold, I think this will make a very nice impression.

Show transcript

This video is part of

Image for Excel 2010 Essential Training
Excel 2010 Essential Training

80 video lessons · 127292 viewers

Bob Flisser
Author

 
Expand all | Collapse all
  1. 1m 35s
    1. Welcome
      57s
    2. Using the exercise files
      38s
  2. 19m 31s
    1. Exploring three common uses for Excel
      3m 17s
    2. Touring the interface
      3m 38s
    3. Finding the commands you need
      3m 51s
    4. Using Backstage view or the File tab
      3m 25s
    5. Maintaining file compatibility
      5m 20s
  3. 21m 23s
    1. Creating a worksheet
      5m 23s
    2. Techniques for copying and pasting
      3m 57s
    3. Entering data automatically with Auto Fill
      4m 37s
    4. Targeting large data groups
      4m 26s
    5. Changing a worksheet's structure
      3m 0s
  4. 47m 50s
    1. Understanding formulas and functions
      4m 41s
    2. Entering data in a worksheet
      3m 22s
    3. Adding numbers manually
      5m 1s
    4. Adding numbers using Sum and AutoSum
      6m 11s
    5. Adding a whole worksheet
      1m 48s
    6. Working with numbers in columns
      4m 53s
    7. Preventing errors using absolute references
      5m 57s
    8. Working with times and dates
      3m 8s
    9. Using IF
      4m 49s
    10. Using SUMIF and AVERAGEIF
      4m 15s
    11. Naming and using cell ranges
      3m 45s
  5. 33m 57s
    1. Formatting numbers and dates
      7m 6s
    2. Applying fonts, background colors, and borders
      4m 35s
    3. Adjusting columns, rows, and text
      5m 2s
    4. Using conditional formatting
      4m 6s
    5. Using custom conditional formatting
      5m 49s
    6. Adding pictures and shapes
      7m 19s
  6. 25m 27s
    1. Inserting SmartArt
      6m 54s
    2. Coordinating a look using themes
      3m 22s
    3. Applying built-in styles
      3m 16s
    4. Creating and sharing styles
      5m 33s
    5. Using templates
      4m 9s
    6. Creating and using original templates
      2m 13s
  7. 13m 23s
    1. Making the pieces fit
      4m 57s
    2. Inserting headers and footers
      3m 51s
    3. Printing and PDFs
      4m 35s
  8. 34m 3s
    1. Finding and replacing data
      3m 12s
    2. Freezing panes
      3m 0s
    3. Repeating row and column titles
      3m 34s
    4. Creating multiple custom worksheet views
      5m 18s
    5. Hiding or grouping rows and columns
      5m 31s
    6. Managing worksheets
      7m 23s
    7. Calculating formulas across worksheets
      6m 5s
  9. 36m 34s
    1. Importing and exporting data in Excel
      8m 2s
    2. Setting workbook permissions
      6m 44s
    3. Inserting and editing comments
      6m 49s
    4. Sharing a workbook
      1m 25s
    5. Tracking changes
      3m 5s
    6. Saving files in shared locations
      10m 29s
  10. 27m 30s
    1. Splitting cell data into multiple cells
      2m 22s
    2. Joining data from multiple cells
      4m 18s
    3. Basic and multi-field sorting
      6m 30s
    4. Using tables to sort and filter data
      4m 31s
    5. Inserting automatic subtotals
      3m 46s
    6. Creating lookup tables
      6m 3s
  11. 32m 56s
    1. Using auditing to diagram
      6m 3s
    2. Using evaluation in Excel
      2m 2s
    3. Working with Goal Seek
      5m 29s
    4. Using data tables in formulas
      6m 2s
    5. Using scenarios in formulas
      5m 28s
    6. Exploring the Analysis Toolpak
      7m 52s
  12. 18m 1s
    1. Discovering PivotTables
      2m 22s
    2. Creating a basic PivotTable
      2m 46s
    3. Modifying a PivotTable
      6m 57s
    4. Creating and modifying a PivotChart
      5m 56s
  13. 26m 58s
    1. Choosing chart types
      1m 55s
    2. Inserting Sparklines
      3m 54s
    3. Creating a column chart
      3m 23s
    4. Modifying a column chart
      5m 47s
    5. Creating and modifying a pie chart
      6m 45s
    6. Placing Excel charts into other Office applications
      5m 14s
  14. 21m 53s
    1. Understanding macros
      3m 5s
    2. Recording and using a simple macro
      11m 58s
    3. Editing a macro
      6m 50s
  15. 20m 33s
    1. Customizing the Quick Access toolbar
      3m 30s
    2. Customizing the Ribbon bar
      8m 44s
    3. Setting Excel options
      8m 19s
  16. 16s
    1. Goodbye
      16s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.