Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Improvements to Excel 2010's SmartArt functionality. In Episode 1068, I show how to make your SmartArt text dynamically generate from cells in the worksheet.
posted by Bill at 9:00 AM
If you use the shapes on the drawing toolbar such as the rectangle, oval, and arrow, you will discover that the shapes do not stay connected when you move them. Rather than using the arrow, Episode 504 shows you how to connect the shapes using a connector that will always stay attached to the shapes.
Labels: drawing toolbar, Shapes
posted by Bill at 9:00 AM
Use the freeform tool to make a 3-D version of your company logo. Episode 407 shows you how.
Labels: Shapes
posted by Bill at 9:00 AM
Although Excel offers 100+ built-in AutoShapes, you can use the various handles on the shape itself, or the tools on the drawing toolbar to morph those shapes into thousands of different shapes. Episode 405 shows you how.
Labels: autoshapes, drawing toolbar, Shapes
posted by Bill at 9:00 AM
Have you ever needed to create many similar autoshapes? You can set the default color, line style, etc and then use an autoshape mode to crank out numerous autoshapes. Episode 404 shows you how.
Labels: autoshapes, color, Shapes
posted by Bill at 9:00 AM
Use the AutoShapes to draw any of 70+ different shapes to your workbook. Episode 368 shows you how.
Labels: autoshapes, Shapes
posted by Bill at 9:00 AM
