Do Not Disturb

After my Outlook article on Tuesday, Ken Puls sent me a link to the Microsoft Office Labs site, where you can download the Email Prioritizer add-in for Outlook 2007.

It has a Do Not Disturb setting that you can use to temporarily stop email from arriving. Good for those times when you need to focus for a while, but don’t want to lose touch with the world for the long term.


My mail runs through MailWasher, which flashes in the system tray when a message arrives on the mail server. Sometimes I turn it off accidentally, and don’t notice until a couple of quiet hours have passed.

No alerts, so I get lots of work done, but it might be better to have it off for a shorter, and predetermined, amount of time.

You can also prioritize your email with the Email Prioritizer’s 3-star rating system. I don’t have Exchange Server, so can’t test it, and will have to stick with my coloured flags system in Outlook. (I only use the red flags, since I can’t remember what the other colours mean if I use them.)

Finally, if you’d like to read about a few Outlook (and other) catastrophes at Microsoft, see Brick ONeil’s Microsoft Office Blog article from yesterday, Top 7 Employee Bungles Using Office.

Make Your Vote Count With Doodle

No, this blog hasn’t gone political. I’m talking about polling co-workers, friends or family, to make a decision, or pick a date for an event. That might be easy to do if you’re in a big office, and share an online calendar.

But, if you’re running a small business and trying to get a consensus on a decision among clients or associates, it’s not so easy.

Instead of spending hours on the phone, or sending emails round in circles, you could use the online polling tool, Doodle. Create a poll, then send everyone a web page link where they can vote. No one has to register or log in — they just follow your link, type a name and cast a vote.

To start, you set up a poll with a choice of dates, or other options. You can opt for email notices, or go to the page and see how the voting is going.

When participants follow your link to the page, they type their name and select one or more of the options.

In this poll, participants would add a check mark for any time they’d be available to attend the workshop. They can see the names and selections of previous voters.

While setting up the poll, if you click the PowerDoodle button, you can make the poll a bit more sophisticated.

You can hide the voter names and selections, as shown below, or limit participants to one selection from the options, or only allow one participant to select each option — useful if you’re allocating tasks.

The Doodle tool seems very easy to use, with no inconvenience to participants. You can see the test poll that I set up, and cast your vote if you’d like.

POLL IS NO LONGER AVAILABLE

Delay Sending Outlook Messages

You hit Send, then realize you forgot the attachment. Or you misspelled the recipient’s name. Or you used Reply All, when you only wanted the message to go to one person. None of these things have ever happened to me (well hardly ever), but you might have been less fortunate.

All kinds of tragedies can strike in that ohnosecond, just after you fire off an email. As a bit of insurance, you can change a setting in Outlook, so messages are delayed a set number of minutes.

Then, if you realize you didn’t want to include everyone in the lottery ticket email, you’ll have time to delete a name or two from the Send To list.

There are instructions for changing this setting on the Microsoft website. It will only take you a couple of minutes to make the change, and that investment will pay for itself the first time you can correct an error before an email is sent.

Update (2008-Sep-19): JP has written an article describing how to delay Outlook messages with programming.

Excel Keyboard Shortcuts

Someone on Twitter said this recently:

  • “Microsoft Excel has no keyboard shortcut for “save as”. Probably because they are *only* on version 11.”

That was one of the Excel tweets that I posted on Saturday. However, as Jason Morin pointed out in the comments, you can use the F12 key to open the Save As dialog box.

Excel Help

Why didn’t the tweeter know about the F12 shortcut for Save As?

Well, when you go to the Keyboard Shortcuts topic in Excel’s Help, there’s an incomplete list. It doesn’t even show Ctl + S as a shortcut to Save, let alone tell us how to do a Save As.

To find a full list of Excel Keyboard shortcuts, you can download one of the following files or view the list on the web page.

Contextures site

View: Excel Keyboard Shortcuts list

Download: Excel Keyboard Shortcuts Excel file

Chip Pearson’s site

View: Excel Keyboard Shortcuts list

Download: Excel Keyboard Shortcuts Excel file

Microsoft Website

Web: Keyboard Shortcuts in Excel

Download: Excel Keyboard Shortcuts (in a Word document)

__________________

Excel Hey Charts and 3D Pie Chart

Children around the world can learn how to make shiny 3D pie charts, thanks to the Create a Graph page on the National Center for Education Statistics (NCES) web site.

See more about those charts below, and we’ll take a look at a Hey Scale chart too!

Continue reading “Excel Hey Charts and 3D Pie Chart”

Blog Stats Dashboard Template

One of the things that I do while drinking my morning coffee is to check the statistics for my website and blog. It’s interesting to see the fluctuations in traffic, and discover where’s it coming from.

I use Google Analytics and my web host also has a daily statistics file that shows me the hits and downloads.

Not that I’m obsessed or anything, but I track the statistics in a couple of Excel files, and even have a line chart for the monthly totals.

Blog Statistics Dashboard

Today I saw a blog statistics dashboard that a Canadian PR firm uses for its clients, and it puts my little system to shame.

Apparently the reports are created monthly, with lots of cutting and pasting, but you could probably automate something similar in Excel.

It has a nice clean look, and you customize it to show the statistics of interest to you or your clients.

You can download the dashboard template in pdf format, and make changes to it, if you have Adobe Acrobat.

I had to change the font before I could edit the text, but maybe that’s because I’m still using Acrobat 5.0.

Off the Cuff Measurements

These items are definitely productivity related, because you can’t manage what you don’t measure.

At the Shana Logic site they’re selling some interesting accessories, and I like this stainless steel bracelet with rulers in metric and inches.

They also make compass earrings, a level necklace and a thermometer necklace, so you’ll be able to stay on course and get things done.

I’d make a pun for each item, but will leave that for you to enjoy on your own.

Free Upgrades For Life

Have you ever bought software that came with free upgrades for life?

In the Successful Software blog, Andy Brice asks if you should give customers free software upgrades for life.

He created an income model in Excel 2007 that you can download, to test different scenarios.


I can’t imagine why anyone would offer free software upgrades for life. Certainly, if there are minor upgrades or patches to the current version, or a major upgrade is released shortly after a purchase, then I would expect to get those at no charge. Otherwise, if I want to enjoy the new features that a developer has worked hard to create, I’d pay for the upgrade.

The article has an excellent list of things customers should expect in major upgrades, including two points that are key:

  • Any major bugs in version n should be fixed before releasing version n+1.
  • A major upgrade should have significant new features.

But don’t worry, upgrades to this blog will continue to be free, as long as I can afford it!

Find New Sites With All My Faves

I use Google to do web searches, and am pretty efficient at finding things, in my humble opinion. Last week my son sent me a link to All My Faves, which lets you find things, but in a completely different way than Google.

The Home page has rows of web site logos, grouped in categories such as Travel, Sports, Finance and Tech. The top row has weekly favourites.

There’s a Weekly Faves tab, that has archived links from earlier weeks, and there’s a best of 2007 row at the bottom of that page. Also, there are specialized tabs for Travel, Entertainment, Kids and Shopping.

This could be a great starting point if you’re trying to generate ideas, or find new sources of information (or entertainment!)

Instead of starting from a narrow search term, and digging in to different sites, All My Faves lets you start from the forest, and pick a few trees to examine.

Rearrange Your Taskbar Icons (Part 2)

A while ago (in May!), I posted about using Taskbar Shuffle to rearrange the icons in your Windows taskbar. This is handy when I have lots of windows open, and I want a couple of them to be readily available.

If I drag their icons to the far left of the Windows Taskbar, they’re easier for me to find when I need to access those windows.

Yesterday, Lifehacker posted an article about Taskix, which is another tool for rearranging taskbar icons. Apparently it’s much smaller than Taskbar Shuffle, and very similar in functionality.

I’ve installed it, and it’s working very smoothly, with no noticeable difference from Taskbar Shuffle.

You can download Taskix for 32-bit or 64-bit systems, then use it to rearrange or close the windows icons on your taskbar.

Simply drag a Window icon to a different position on the toolbar, and release it to place it in the new spot. Or, point to an icon and click the mouse wheel to close that window.