If you are still using Windows XP, here are some important tips for use after the end of life on April 8, 2014. You may need to upgrade or replace the computer if you need to continue it’s use. If you do not need the computer, it should be turned off, disconnected and retired. Antivirus […]
Today I have been given the task of sorting a spreadsheet with about 20,000 rows by birthdate or anniversary. The sort needs to be by month and day, ignoring the year for CRM. The simple formula I used was TEXT(CELL,”mm/dd”). The problem was that many (thousands) of the dates were in unrecognizable formats such as […]
I have a need to look for duplicate entries in an Excel worksheet and delete the ones with outdated or incomplete data. This has proven to be a bit more difficult than I thought it would be. I will be working on a better solution for this based on demand. The AbleBits add on did […]
This is a formula for use by users that are familiar with using formulas in Excel. If you are not such a user, be careful and backup before you start. We need to convert a column of variously formatted phone numbers to a common format. This can be difficult if the source has several formats […]
To determine what email service you need, we have to ask a few questions. After thinking about and answering the following questions, we can discuss the options more easily. Do you want a permanent email address? The only way to guarantee a permanent email address is to own an internet domain and pay the annual […]
Some of you hate the loss of features and configuration of the Skype replacement for Hotmail Instant Messenger. Here is how to set up our suggested replacement. Download and install Trillian. You will need to set up an account with Trillian but the free one will work just fine. You can get it here: https://www.trillian.im/ […]
Some of you are using or would like to use Outlook.com due to it’s enhanced feature set and access anywhere and sync to phone including contacts. The following is an abbreviated list of steps for setting it up. Microsoft has a verification procedure that may need to be completed before you can make your email the […]
Cable One has a spam filter that will by default block most invoices from TranSoft Labs. I have spoken with CableOne tech support and they cannot tell me why this is happening. The only solution is for you to add to your Approved Senders list in thier spam patrol application. This setting is not available or […]
The screen was blank because the sheet had been saved in a position off the screen. To see the sheet, go to Veiw, Arrange All, or Window Arrange. Press OK and you should see it.
Here’s how you do it Needed information You will need your domain name. This almost always the part after www. in your web address. i.e. www.transoftlabs.com is “transoftlabs.com”. Use that for any place you see “DOMAIN.NAME” below. Your user name. This will be provided to you on request or during site setup if you publish […]