Beyond Bullet Points

If you prepare presentations and use slides, there are interesting ideas in Cliff Atkinson’s book, Beyond Bullet Points.

As the title suggests, he warns against using slides with bullet points. Instead, he uses slides to tell a story, planning them with a storyboard technique.

Atkinson starts by describing a presentation that used the BBP technique to win a major legal case. The rest of the book takes you through the steps of planning, creating and delivering the presentation.

He even suggests handouts with financial data in an Excel spreadsheet, to supplement the presentation, and “quickly establish credibility.”

Incorporating Excel is obviously a smart move in almost any presentation!

I found the book easy to read, with detailed instructions, checklists, tips and examples.

The book comes with a CD which contains templates and checklists to help you get started.

There are also templates and other free resources on the BBP web site, where you can download a couple of chapters from the book, to see if you like it enough to buy it.

Shift Key Tricks in Excel

You probably know a few ways to use the Shift key in Excel, to extend the cells that you have selected.

For example:

  • Click on a cell, then hold the Shift key, and click on another cell. All the cells in between are selected.
  • Hold the Shift key while you use the arrow keys, and cells will be selected as you move.

Select Range of Cells

Here’s a Shift key trick with the Name Box

  • First, select a cell, to use as the starting cell for the range selection
  • Next, click in the Name box, at the left side of the Formula Bar.
  • Then, type the address of another cell, to use as the ending cell for the range selection
  • Finally, on your keyboard, press the Shift key, and tap the Enter key.
    • Shift + Enter

The entire range will be selected.

End Selection at Named Range

Here’s another Shift trick that uses the Name box, if your worksheet has at least one named range listed in the Name box:

  • First, select a starting cell,anywhere on the worksheet
  • Next, press and hold the Shift key
  • While holding the Shift key, click the drop-down arrow at the right end of the Name box
  • Click on a named range in the Name box drop down list.

On the worksheet, the selected range will include your starting cell, and the entire named range.

Does Music Help You Focus?

I’ve read articles that claim listening to Baroque music will help productivity, and some research concludes that music can make you more productive in repetitive tasks.

When I wrote my books, I usually had flamenco nuevo or contemporary music in my headset, and sometimes listened to the same album several times in a row. (I’m sure that’s not a symptom of anything!) When programming, I like it quiet.

What do you listen to, or do you prefer silence?

If you find that classical music helps you focus, you might enjoy the free concert downloads available at Isabella Stewart Gardner Museum Music:
https://www.gardnermuseum.org/music/listen/music_library

Share Excel Data With Swivel

NOTE: The Swivel site shut down in 2010. You can read an interview with the two founders on the Eager Eyes blog.

The Swivel web site lets users upload Excel data, create charts, and share the results. They’ve recently opened up their Business Swivel, where you can upload data and keep it private, for a monthly subscription fee.

It’s interesting to see what people are charting, such as the occurrences of gunshots, firecrackers and other noises in York, PA.

Stick Things Together in Word

This is a feature that I wish Excel had too. If you want to keep two or more paragraphs together on the same page, you can change the formatting options in Word.

To keep two paragraphs together:

  1. Select any paragraph that you want to keep with the paragraph that follows it. For example, click in a heading paragraph, to keep it with the descriptive paragraph below it.
  2. On the Format menu, click on Paragraph
  3. Go to the Line and Page Breaks tab
  4. Add a check mark to Keep With Next
  5. Click OK

To keep a paragraph from splitting over two pages:

  1. Click in the paragraph, or select several paragraphs
  2. On the Format menu, click on Paragraph
  3. Go to the Line and Page Breaks tab
  4. Add a check mark to Keep Lines Together
  5. Click OK

Keep a Quick Log File

As I work at my computer, there are lots of things that I want to jot down, to act on later. Most of these are brilliant thoughts, or million dollar ideas, so I don’t want to lose them!

The quickest way that I’ve found to collect these notes is in a log file in Notepad. When I open it, the file adds the current time and date, and the cursor automatically goes to the end of the file.

To create a log file:

  1. Open Notepad, and at the top of the new blank file, type: .LOG
    This MUST be in upper case letters.
  2. Save the file as a Text file, e.g. MyNotes.txt
    Note: I save my file to the Desktop, so it’s easy to find and open.
  3. Close the file.

To use the log file:

  1. Open the log file, and the date and time are automatically added.
  2. Enter your notes, then save and close the file.

Take Measurements With Pixel Ruler

To accurately measure items on your screen you can use the free utility, Pixel Ruler. I’ve found this helpful when I have to upload a picture that’s a specific measurement, such as a blog banner, or profile photo.

You can drag the ruler to any position on the screen, to line up the zero mark with the left edge of the object that you want to measure.

Then, point to the ruler where it lines up with the right edge of the object, to see the width in pixels. In the screen shot above, the rectangle is 223 pixels wide.

The ruler has three control buttons at its top left — an arrow, a triangle and a line:

  • To measure the height, rotate the ruler to vertical, by clicking the arrow button.
  • Click the triangle button to change the ruler colour, or to access the Pixel Ruler web site
  • To close the ruler, click the line button.

Block the Distractions with White Noise

If you’re trying to work in a noisy environment, some white noise might help block out the distracting sounds. I work from home, with an office that faces the street. It’s usually quiet, but when the kids are out of school for the summer, things get a bit noisy sometimes.

If I’m trying to concentrate, I put on my headset and go to https://www.simplynoise.com/ for some white noise. There’s a slider that let’s me adjust the volume, and that’s it. Nothing to fiddle with, no choice of sounds, just simple noise, as promised.

After a couple of minutes I forget that I have the headset on, the outside sounds fade away, and I can focus on my work again.

Customize Your Excel Toolbar

In Excel 2003 and earlier versions, you can customize your toolbar. Add buttons for commands that you use frequently, to reduce the amount of time you spend digging through the menus and sub-menus.

To make room, you can remove buttons that you never, or very rarely use.

Add a Macro Button to Toolbar

In this example, you’ll customize the toolbar to add the Toggle Grid button:

    • On the Excel menu, click Tools, then click Customize.
    • Click the Commnds tab, then click on the Forms category.
    • Scroll to the end of the list of Commands, and find the Toggle Grid command.
Add a Macro Button to Toolbar
Add a Macro Button to Toolbar

Drag the Button

    • Drag the command to one of your existing toolbars. You’ll see an I-beam that indicates where the button will be placed.

  • Close the Customize dialog box.

Use Toolbar Button

Then, to show or hide the worksheet gridlines, just click the Toggle Grid button.

This is much quicker than going to Tools â–º Options, and changing the Gridlines setting on the View tab.

On my toolbar I’ve added buttons for:

  • Paste Values (Edit Category)
  • Record New Macro (Tools Category)
  • Toggle Grid (Forms Category)
  • Set Print Area (File Category)
  • Lock Cell (Format Category)

and a few others.

The Lock Cell button is really useful when I’m setting up data entry forms, and want to lock and unlock parts of the worksheet.

Create a New Message

To create a new message in Outlook, you probably click the New button in the Outlook toolbar.


If you’d like to save a few inches of mouse travelling, double-click on the empty space under the list of messages, as shown in the screen shot below. That will open a new message window for you.


If there’s no empty space at the bottom of the list, or if your hands are on the keyboard, press Ctrl + N to create a new message.

These shortcuts also work in the other areas of Outlook, such as Contacts, Tasks and Calendar.