Learn Excel from Bill Jelen with this daily 2 minute video podcast.
The drawing toolbar offers a circle, but no semi-circle. Or does it? Learn how to use the yellow inflection handles to make other shapes in Episode 963.
Labels: drawing toolbar
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
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
Create an Org Chart in Excel. The org chart tool is hidden behind an obscure icon on the drawing toolbar. The details of using the tool are a bit complicated. Episode 388 shows you how to create an org chart.
Labels: charts, drawing toolbar, Icons
posted by Bill at 9:00 AM
Create a target diagram in Excel, using the business diagramming tools on the Drawing Toolbar. Episode 385 shows you how.
Labels: charts, drawing toolbar
posted by Bill at 9:00 AM
Using the circle tools on the Drawing toolbar to call attention to a cell. Episode 367 shows you how.
Labels: drawing toolbar
posted by Bill at 9:00 AM
Use the drawing tools to highlight data on your worksheet. Episode 366 shows you how.
Labels: drawing toolbar
posted by Bill at 9:00 AM
There is a secret icon that will let you select all of the items on the drawing toolbar. Episode 363 shows you how.
Labels: drawing toolbar, shortcuts
posted by Bill at 9:00 AM
