Welcome Your Subscribers

If you use Feedburner to manage your blog’s email subscriptions, you can customize the activation letter that goes out to new subscribers. Instead of using the default address, subject line and email body, you can use your own greeting. I just discovered this feature, so if you got a boring, generic greeting from me, I apologize!

How To Customize the Email

Log in to Feedburn and click the Publicize tab
In the list of Services, click on Email Subscriptions

FeedburnPub
In the list that appears below Email Subscriptions, click on Communication Preferences

FeedburnComm
In the Communication Preferences page you can modify your From address, the Subject line, and the Body text. There are instructions below each box to help you.

FeedburnEdit
Even if you just add a few words of your own, like “please” and “thanks”, it will improve the default message.

You could also add the URL of your main site (it won’t be clickable), in case the subscriber hasn’t found that yet.

When you’re done, click the Save button, and log out of Feedburner.

Procrastination Revisited

A couple of weeks ago I started reading Never Procrastinate Again, and promised to report on what I thought of the material, and how well it worked for me.

Reasons For Procrastination

This is an audio course with written transcript and worksheets, by Dave Navarro from the Rock Your Day blog. I listened to a few minutes of the audio files, but those just don’t suit my learning style, so I used the written transcript instead. There are also video files (about 100 MB) that you can download separately, but I didn’t bother with those.

The key to this course is identifying why you’re procrastinating, by reviewing ten possible reasons in a worksheet. The ten procrastination causes fall into three basic categories:

  1. I don’t like to do it.
  2. I don’t know how to do it.
  3. I’m afraid to do it.

Beside each of the ten reasons there’s a suggested method for overcoming your resistance, and there’s space to write little pep talks to yourself. On another worksheet you can schedule time to practice these pep talks.

My Checklist

I haven’t bought into the self pep talk approach, but the list of procrastination reasons was thought provoking. So, I wrote a list of work-related things I have to do, and things I want to do, both long and short term. A few of those things made my stomach knot when I thought about them, so I ran a couple of those through the reasons checklist.

The first example was invoicing. Why do I avoid that task, even though I like getting paid for the work that I do? The reason seemed to be a mixture of dislike and fear. It’s a bit tedious, even though I have a database with all the information, and the reports and queries help make it easier. The fear is that I’ll make an error in an invoice or that someone will question an item or two.

My Solution

I decided to work on the October invoices and create a set of instructions as I worked. Next month I won’t have to remember all the details, I’ll just follow the written steps. I’ll also look for ways to make things easier for myself.

I built a few error checking steps into the instructions, so that alleviates some of my fear. I also realized that my time sheet data entry needs a bit of improvement, so I can clearly describe the work that’s being invoiced for on-going projects. That should reduce any questions about the invoices.

Break Down the List

The other thing I realized is that several of the things on my to do list need to be broken into smaller pieces. That will make those items less scary, and make it easier to know how to do them.

I keep my list visible on the computer desktop all the time, so that helps me stay focused. Instead of wandering off to explore something new, the minute I think of it, I add it to the list to work on later. When I’m between billable work sessions, I can pick something non-billable from the list to work on. So far, it’s going pretty well.

The Verdict

The Never Procrastinate Again course helped me get started on a few things, even though I didn’t follow all of the author’s suggestions. Maybe the self talk and role playing works for some people, but I’ll pass on those. However, the checklist is great for identifying problems, and for realizing that some tasks are too big to tackle in one piece. Next time a task makes my stomach knot, I’ll run it through the checklist.

Send Excel Data to Access

While working on client projects, I enter all my timesheet data in Excel. Why do I use Excel? Here are my top reasons (excuses):

  1. Excel is usually open on my computer, so it’s the easiest program for me to use
  2. That’s the way I’ve always done it
  3. Other important, and perfect valid, reasons that are long forgotten.

Continue reading “Send Excel Data to Access”

Are You a Star Maker?

When I open Google Reader first thing in the morning, there are a few blogs that I always read, if they’ve posted any new articles. Most of those I read within Google Reader, and occasionally click the link to go to the blog, to read the comments or find the end of a partial feed’s article.

Mark Them

Then I click the All Items link, skim through the articles in List view, and add a star to any items that look interesting. This keeps me from spending a couple of hours reading blogs, when I should be getting down to work.

GoogleReadStarAdd

Read Them

Later in the day I view the list of Starred items, and click on an item to skim through it.

GoogleReadStarList
After reading an article (or the first couple of sentences), I usually remove the star, but leave a few marked so I can go back to them.

This helps me when I don’t have enough time to read a really long or complex article, or return to articles where I’ve left a comment.

Review Them

If you’re really obsessive compulsive, you can use the Trends feature to analyze the stars you’ve added. To me, it’s slightly interesting, but not too useful.

I use the Read page when trimming my feed list, since it gives me a good idea of what I’ve found useful over the past few months, and what’s been clogging up the feed list.

GoogleReadStarTrend

How Do You Use Google Reader?

  • Do you use Starred items in Google Reader?
  • Trends?
  • Any of the other features?

Stay On Track With NextAction

I keep track of my tasks in an Excel file, where I have macros that export the completed data to Access for invoicing.

I check the list every morning, and at the end of the day, but not very often throughout the day. So, while I might have an excellent plan for the day, it can go off the rails if I get distracted.

NextAction is a little program in which you can list your activities, then mark them as done throughout the day. It’s a free download available on the TimeSnapper website. I’m testing it to see if it will help me keep on track.

NextActionDone

When it’s not active, it’s still visible on my desktop, in the bottom corner of the second monitor.

NextActionFade
So far, the benefits seem to outweigh the negatives.

Benefits

  • I can copy and paste the current day’s task list from Excel, so there’s no time wasted in retyping anything.
  • The window stays on top of other programs (optional setting) with adjustable transparency. This keeps my task list visible, no matter what else I’m doing, and reminds me of the day’s list.
  • To keep track of start and end times, I can mark the task as Done when I start it, to create a time stamp. When I’m finished, I mark it Done again, to get another time stamp.

Negatives

  • There’s no way to export the data, so I have to copy and paste the completed tasks back to Excel. If I decide to keep using NextAction, I’ll write an Excel macro to clean up the pasted data and calculated the time spent on each task.
  • No drag and drop in the text editing, so I had to cut and paste to move things around.
  • After changing a couple of the settings, it lost its Stay On Top capability, even though that setting was still turned on. Exiting and reopening seemed to fix it.

Excel Most Recently Used Files Add-In

As you work in Excel, the files that you’ve used most recently appear at the bottom of the File menu — Mort Recently Used Files (MRU).

  • The default number of files that appear in the MRU list is 4
  • You can increase the MRU number to 9, if you follow the steps below.

If you’d like to see even more recently used Excel files, take a look at the free Excel add-in, described below
Continue reading “Excel Most Recently Used Files Add-In”

Which Way Does Your Paper Curl?

Do you know that just like us, paper has a good side, and a not-so-good side? And the good side is better for printing. Paper grain affects printing too, but we’ll save that excitement for another day. (Yes, I grew up in a paper mill town, thanks for asking.)

How do you figure out which is the good side?

If your paper is still in its package, look at the label on the end. There should be a small arrow that points to the good side. There might even be a label near the arrow that says, “Print this side” or something similar.

If there’s no label left on the package, or no arrow, you can check the curl of the paper. Hold a small stack of paper by the narrow edge, and either the sides or bottom edge should curl in a bit. That’s the curl side, and you should print on the other side.


In your printer, look for the symbols that show which side the paper will be printed on.

  • Load the paper so it prints on the good side.
  • If you’re printing on both sides, print on the good side first.

For even more fascinating paper facts you can read this Xerox publication (pdf), Helpful Facts About Paper.
___________________________________

Your Customized Excel Toolbars

Yesterday I posted a tip for adding the Refresh All button to the PivotTable toolbar, so you can quickly update all the pivot tables and queries in a workbook.

Move Toolbar Buttons

In the comments, Jan Karel Pieterse mentioned that he can press Ctrl+Shift, or hold the Alt key, then drag toolbar buttons to a different toolbar. I can’t get that Ctrl+Shift shortcut to work, but often use the Alt key to adjust toolbars on the fly.

In another comment, AlexJ described how he moves well-hidden menu commands, such as Show Formula Auditing Toolbar, to a toolbar, so they’re easier to use. Great idea!

See What Is Locked

Besides the Refresh All button, there are a few others that I add to my Excel toolbars.

For instance, when I’m creating data entry forms it helps to know if a cell is locked or unlocked.

I copy the Lock Cell button from the Protection toolbar to my Standard toolbar (Ctrl+Alt, then drag the button).

When I click on a cell, the Lock Cell button shows the cell’s current setting, and I can click that button to lock or unlock the cell. Very handy!

Move Lock Cell button to Different Toolbar
Move Lock Cell button to Different Toolbar

More Buttons for Toolbars

I also add the Record Macro and Visual Basic Editor buttons.

Those are copied from the Visual Basic toolbar, and Toggle Grid from the Forms toolbar.

Record Macro and Visual Basic Editor buttons
Record Macro and Visual Basic Editor buttons

What Buttons Do You Add or Remove?

  • Are there any standard command buttons that you always add to your toolbars when you install Excel?
  • Any standard command buttons that you always remove, because you never use them?

If you’d like to share a screen shot of your toolbars, upload it somewhere like TinyPic.com, and paste a link in your comment.

Or, if you’re feeling adventurous, you can open this Google Spreadsheet, choose Insert>Picture, and paste the picture link in there. I have no idea how well this will work, but it might be an interesting experiment!

[Update] Bryony’s Excel Toolbars

Thanks to Bryony who uploaded a screen shot of her Excel toolbars. Here’s how she described them:

  • The colourful ones at the bottom in the middle are a few little macros, the toolbar to the left is my custom one. I have taken a load off the standard bars as I absolutely never use so many of those features. I have my screen resolution set quite high, so I have quite a bit of space left!

Wow, Bryony, that is amazing — the sign of a dedicated Excel expert!

Bryony's customized Excel toolbars
Bryony’s customized Excel toolbars

Quickly Customize an Excel Toolbar

In one of the Excel newsgroups last week, someone asked how they could update several pivot tables at the same time. They were tired of selecting each pivot table separately, and clicking the Refresh button.

Refresh All Button for Pivot Tables

In an Excel workbook you can refresh all the pivot tables and queries if you click the Refresh All button.

That button is on the External Data button, which appears automatically if you click in a cell that’s part of an external data range.

Refresh All Button External Data Toolbar
Refresh All Button External Data Toolbar

Add to PivotTable Toolbar

However, if you don’t have any external ranges in your workbook, you can add the Refresh All button to the PivotTable toolbar, so it’s easy to find and click.

The quickest way to add this button is to click the Toolbar Options button at the end of the PivotTable toolbar.

Floating Toolbar

If the toolbar is floating, you’ll see a large triangle to the left of the Close button.

  • Click that triangle, then click the Add or Remove Buttons command
  • In the pop-up menu, click on PivotTable
ToolbarAddButtonsDocked Toolbar

If the toolbar is docked, there’s a small triangle in the bar at the end of the toolbar.

  • Click that triangle, then click the Add or Remove Buttons command
  • In the pop-up menu, click on PivotTable

ToolbarOptionsAdd the Button

After you click the PivotTable command, you’ll see a list of all the standard commands that can be added to the PivotTable toolbar.

  • Click on Refresh All, to add it to the toolbar.

ToolbarRefAll
Now, when you want to update all the pivot tables, just click the Refresh All button.

More Google In One Fell Swoop

When you’re searching in Google, by default it shows you 10 results per page. Sometimes you’re lucky and the item you’re looking for is right there on the first page. Other times you’re not so lucky, and have to look through a few pages before you find your answer.

To cut down on the page views, you can change your Google preferences and increase the number of results per page. I find that 20-30 per page works well for me. Then, use the space bar on the keyboard to quickly scan down the page.

Change the Number of Results

1. On the Google search page, click the Preferences link.

2. On the Preferences page, scroll down to the Number of Results section

3. Select a higher number from the drop down list.

4. At the bottom right or top right of the Preferences page, click Save Preferences. That will automatically return you to the previous Google Search page.