Wednesday, October 26, 2011

Bullet Points in Excel

Funny how things evolve. I was leading an introductory class in Excel (yes, we still have those) and one participant wanted demoes on how to use Excel to make Standard Work Procedures - yes, no calculations, just using Excel to draw non uniform tables and grids.

One seasoned Word person noted that some of the grids could have been carried out in Word but admitted that as the grids became wider and so forth, that the Word screen would scroll and sway in a wordy kind of way compared to the grid like behaviour of Excel.

The issue with Excel heavily presented textual work is planning ahead on non uniform tables - if the smallest unit of a grid is not catered for, you can't easily split big cells into smaller cells.

Another point was the infamous bullet points in Word and PowerPoint.  Coincidentally, Debra Dalgleish just blogged about this same topic. Here's her video

1 comments:

Brandon said...

PowerPane for Excel also lets you create bullet lists within a single cell. You right-click a cell and choose "Insert Bullet List" and it will bring up a bullet list editor.

http://www.opengatesw.net/products/Microsoft-Excel/PowerPane/index.htm