Updating Contact Information in The Raiser’s Edge®

The ‘HowTo’ Video below demonstrates how to update contact information (address, phone, email) in Blackbaud, Inc.’s The Raiser’s Edge® database.

Enjoy! ….

How To Sort by an Embedded Last Name in Excel

Clients often ask us how to alphabetically sort data in Microsoft Excel by someone’s Last Name even if the name field is formatted as “Mr. John M. Doe.”

Basically, all you need to do is make a copy of the column containing the name data and use Excel’s REPLACE function in tandem with some wildcards.

The wildcards used in the How To Video below are:

? = Find any type of character
* = Find everything (used in tandem with ‘find everything leading up to a particular value’)

Please watch the video for a quick step-by-step ‘how to’.

Thanks. Hope you find the video helpful…

Who reads instruction manuals anyway?

As an added service we have begun posting online HowTo videos for our clients and friends. These screencasts show exactly how specific tasks should be performed at each client’s particular organization — right down to the mouse click.

Check out our first post on Viddler.com about how to insert tomorrow’s date into MS Word merge documents when generating receipts or acknowledgment letters right here.

Or watch the embedded video below: