TJ's Blog

Posted by TJ on Thursday May 26, 2011 @ 01:45 AM
[Tags: shopping, tips, business]

1) You can avoid getting short changed ... Avoid the chance of the cashier giving you back the wrong change
2) Easier Expense Tracking - Most credit cards have great tracking online, so say, you want to know how much you spent at Starbucks in the last year that will be a lot easier to figure out if you used your credit every time.
3) Avoid going to the ATM --- I know ATM's are everywhere but why waste your time or risk having to pay an ATM fee when you run out of cash?
4) Rewards - most credit cards offer rewards -- which might not be much but its still free money or travel miles.
5) Protection - If you buy something with cash and it is a lemon you won't get your money back unless the seller agrees but if you use a credit card you may be able to issue a charge back claim and have the charge reversed by the bank.
6) Better credit rating - Charging your purchases and paying off the balance each month with build good credit history. The longer you keep a credit card the better your score will be. It will be harder and more expensive to purchase a house or car if you do not have a good credit history.
7) Change is nuisance -- Avoid change jars where the money will just sit in your house for years not accruing any interest.

Posted by TJ on Friday March 25, 2011 @ 06:44 PM
[Tags: guide, excel, accounting]

One my excel nuisances is spreadsheets that link to other external documents. If you plan on sending a file out, I feel that external links, should be avoided at all costs in the professional environment. External links may seem to work fine when the files are all your computer but once you give that file to another party it creates issues because excel can no longer find the file. Also changing the source document after you link to it also can create more issues.

So having said that, here are useful tips for finding and removing external links.
1) The easiest way to remove links in excel is using the "Edit Link" option on the Data ribbon. Here excel will list all the external documents that a spreadsheet is linking to. You can select each file listed then click "break links" and excel will replace the formulas that contain external links with values. The problem with this feature is you will not always know which formulas you are editing and the feature does not work on some links.

2) If you want to view each external link before editing it another option is to search for all external links. This can be achieved by using the "Find and Select" option on the Home ribbon. If you click the "option" button you can select to search the worksheet or the whole workbook. Now in the "find what" box type "[" or ".xls" without quotes.

3) Now if you tried the above and you still have external links this may be due to defined names that exist in workbook. You can see if you have defined names by clicking the "Name Manager" on the Formulas ribbon. Delete any names here that have errors or that are linking to external sources (make sure you correct any of the formulas using these names first, of course).

4) If you still can't find a link there is a handy tool created by Bill Manville that will find all hidden links and give you the option to delete each. You can download the file here:

Posted by TJ on Monday November 29, 2010 @ 10:12 PM
[Tags: shopping, internet, business]

I wanted to give props to for my recent online purchase. I was a little hesitant at first since I have never heard of this online retailer. The item I originally ordered was the QNAP TS-439 II selling for $700. However, it apparently went out of stock before they could ship so they called me to let me know they will instead ship me a free upgrade to the QNAP TS-439 II+ (selling for $760) since they do not have the model I ordered in stock. I agreed and they shipped that day and it arrived in excellent condition.

I do appreciate when retailers go out of their way to keep the customer happy, and I would definitely recommend them if you're looking for great prices.

Posted by TJ on Saturday November 20, 2010 @ 04:24 PM
[Tags: scam, internet, guide]

There has been recent influx in cell phone text scams. These scams are an attempt to steal personal banking information or credit card information. The text message I received was from 917-822-2827 with text text "J P Morgan THPV alert". Please call 817685077".

Why is this a scam?
  • I don't do banking with JP Morgan
  • Banks don't normally text you when there is an issue with your bank
  • The text is from an unverified number
  • The text is vague and does not provide identifying information.
  • An internet lookup/google search for the telephone number terms up no link to JP Morgan

Posted by TJ on Monday October 4, 2010 @ 03:37 PM
[Tags: internet, tips, business]

The number of mailing list (or RSS feeds) I am subscribed keeps dwindling and here are some of the reasons why:

1) You are off topic - Your newsletter is suppose to be about monkeys in Africa but you keep sending emails about the contest on your website .

2) You are trying to sell me stuff that is not related to your newsletter. This kind of relates to the first one, but if you continue to send me newsletters with lousy sponsored sales pitches for products I do not need I am more than likely to unsubscribe than buy anything.

3) You send too many emails - You send too many low content emails instead of good-content less frequent emails.

4) Your emails are too pretty - I prefer text emails that get right to the point over image heavy emails so if you are going to use a bunch of images and html formatting I might just unsubscribe. And no I didn't have time or don't remember to check my preferences (text vs html emails) when signing up for your email so that won't work either.

5) You screwed up - I canceled a couple of newsletter in the past because it seemed like every time the newsletter came in two messages once was the original email and the next email was a "Sorry disregard the last email", etc. Make sure you read and reread your stuff before you send it to thousands of readers.

Posted by TJ on Monday October 4, 2010 @ 01:44 PM
[Tags: internet, guide, email]

As widely discussed Google's Gmail platform has a neat little feature to undo a sent email if you want to recall within 30 seconds. The workings behind this feature is pretty simple. Google's server waits 30 seconds and only if the user doesn't click "undo" will it then send the email. No other platform that I am aware has this ability to do this. However, in most email software (including outlook) you can enable "automatic spell checking for every email" which adds an extra step to the sending process and gives you an extra time to ensure that each sent email is really what you want to send.

To enable auto spell check in outlook:
1) From the menu select Tools->Options
2) Select the spelling tab
3) Make sure "always check spelling before sending" is checked

Now this will only stop an email from being sent if any word is spelt wrong. To make sure every message requires an extra review add/modify a signature to your account under "Mail Format" and add an abbreviation (or your last name may work) that is not in the default dictionary such a Tel., thnx, etc.

Posted by TJ on Thursday September 23, 2010 @ 11:13 AM
[Tags: personal, bored, internet]

So that is what the other TJ Miller looks like...

User submitted image

Saw this when reading an article on

Posted by TJ on Sunday June 27, 2010 @ 03:45 PM
[Tags: guide, business, internet]

1) Google Maps - Add your shop to Google Maps. This is free and it will help users find your store when they are looking for store's near them. This is completely free service and should be a no-brainer for any store owner. link:

2)Facebook fan page - This enables customers to "like" your store which adds a link to your store in your customers profile. This is great way to get referrals from you happiest customers. It also gives you an easy way to post news and updates on your store. This is completely free and easy to setup. All you need is a facebook account to link your page to.

3) Domain name and email address: Don't use free email address providers or your ISP provided email address for your business (IE:, or For $10/year you can register your own .com domain and get a personalized domain for your business and have a more professional and more trusted address (ie: Once you registered a domain you can get free email forwarding from This will forward emails sent to your domain to your existing personal email account.

4) Simple Webpage - You should have at least a simple web listing. At the very least your webpage should include your address, brief description of products or services, hours, and phone number.

5) Yellow Page Listings - Add a free business listing to and These are the two most popular online yellow page directories. You can add a free listings to both of these: and

Posted by TJ on Friday June 11, 2010 @ 04:46 PM
[Tags: google, blog, internet]

Actually I don't know anything about HTML 7. In fact I haven't even fully grasped the changes in HTML 5 yet. I was just wondering... how successful would a blog be if you wrote only about the future?

The problem with blogs currently is too much competition. For every blog topic you think of one million bloggers already wrote about, leaving your blog in the last pages of search results. In fact, I would have used "HTML 6" as this article title but there are already 1.6 million results in Google for html6, even though html 5 is the current release version.

So writing about the future there is less competition and more likely to get good search visitors. I commonly write about topics that I found have little search results but let's see how writing about the future fares. Thanks for reading and being a part of this experiment.

Posted by TJ on Monday June 7, 2010 @ 04:36 PM
[Tags: internet, gmail, google]

Apparently I have a very easy to mistype/misspeak email address and am constantly receiving misguided emails. I even wrote about this issue in the past (by the way my echild now has 10 absense and 1 tardy... tisk tisk tisk)

I was just wondering what other people do when they receive emails that weren't intended for you. Do you reply and let the person know? In the past month I received a funeral notice, a resume (to pass along), a picasa album invitiation, Budget rental confirmation, dog photos all intended for some one who has the same first initial and last name as me but different email. It's not always to the same person... sometimes it is to Todd, Terry, Teresia, or Thomas so it not only one person giving out an incorrect email address. So is it my obligation to reply to all the emails and tell the sender they have the wrong email address? Or do I let them figure out the mistake themselves? I mean I do feel a little bad that someone could miss a funeral or job offer because they got the wrong email address but can't everyone be a little more careful with who their sending this stuff too?

What are your thoughts?

< Previous Page | Next Page >