Sunday, September 30, 2012

Big Calculator for Windows

If you're anything like me, you may have trouble seeing the numbers in the Calculator provided by Windows.  I love this calculator and use it daily - but with each passing year, it's getting harder and harder for me to read the results of the calculations I perform.

After searching the internet and trying out different calculators, I've found one I like.  It's called the, "Big Calculator" and you can download it for free by clicking here.

Once you get to the download web page, click the "DOWNLOAD" button (which will take you to another page).   Next, click the link that reads, "External Mirro 1" in order to start the actual download. 

If you're running Windows Vista or Windows 7, the downloaded program should be in your Download folder.  

Once the file is downloaded, just double-left click the icon to install the new calculator.  Once it's installed, you'll find it under ALL PROGRAMS in the SENSORY SOFTWARE folder.  You may also find a shortcut on your desktop (that looks like a green plus sign). 

The Big Calculator is a LOT easier for me to read and hopefully you'll find it easier too!

Friday, September 21, 2012

Beware of fake computer tech calls!

Tonight my cousin got a call from somebody claiming to be a computer tech who said there was a problem with their computer and he needed to fix it for them ... the guy had a heavy accent was barely understandable .. luckily my cousin had enough smarts to tell the guy no.

Another friend of mine who lives in the D.C. area said he also had been getting similar calls for 6 months.  His "tech" guy claimed to be from "the Windows Services Department".  My friend has a a lot of technical knowledge and so had some fun with his calls.  When told he had a problem with his computer, my friend asked the tech which one, and told him he had 6 computers.  The tech told my friend he'd have to connect to tell him which one was the problem.  Of course, my friend replied if you can tell me I have a problem now, why is it you can't tell me which one of the six computers is the problem. The tech hung up.  They had many more conversations like this over the course of the 6 months, each time with the sound of "click" as the tech hung up in frustration.  

This was obviously a scam and the guy was trying to gain remote access to the computer in order to steal important identity information or install viruses, etc.

Don't be fooled by this scam!  If anybody calls you out of the blue and tries to convince you have a computer problem, tell them this call is being monitored and that you're notifying the FBI and then goodbye!

Be sure to spread the word too so that others won't fall victim to this scam!

Saturday, August 25, 2012

Learning to Use Excel 2007

Excel 2007 is very similar to Excel 2010.  Both use the "ribbon" which was a major change to Excel from earlier versions.  Below are some videos to help you learn Excel 2007 quickly!  Click on the links to watch videos on YouTube.

Excel 2007 - Get up to Speed Fast

Excel 2007 - Overview 

Excel 2007 - The Ribbon

Excel 2007 - Setup

Excel 2007 - Cells

Excel 2007 - Insert & Delete Rows and Columns

Excel 2007 - Creating Your First Spreadsheet

Excel 2007 - Use Simple Formulas to Do Math

Excel 2007 - Formulas

Excel 2007 - Create Charts

Excel 2007 - Create Gant Chart

Excel 2007 - Creating a Pivot Table 

Excel 2007 - VLookup  (Perfects for Teacheres)

Excel 2007 - Left, Mid and Find Function

Excel 2007 - Highlight Active Row

Exce; 2007 - Find and Replace Data

Excel 2007 - How to Sort Data

Excel 2007 - Filtering Data


There are hundreds of more video tutorials on YouTube teaching you how to do various things in Excel 2007.  The links above are designed to help you learn the basics of Excel 2007 quickly!

Friday, August 3, 2012

Upgrading to Windows 8

A lot of my clients have been anxious to buy a new computer but have been concerned about the upcoming release of Windows 8.  Why buy a computer with Windows 7, only to have Windows 8 come out shortly afterwards?  Good question!  Here's some information to help put your mind at ease!

First, if you've been wondering what's new about Windows 8, you can watch a preview video, by clicking here.   Watching the video preview, it appears that Windows 8 is geared more towards social networking (i.e., communicating with others through Instant Messaging, Facebook, etc.).   So if you're really into all the social networking, you'll love Windows 8!  For those who aren't - no doubt Windows 8 will be an interesting experience. 

The good thing is that Microsoft has FINALLY made it easier to upgrade your operating system if you're buying (or already own) a computer running Windows 7.  Here's the deal ....

If you buy a new computer with Windows 7 per-installed between June 2, 2012 and January 31, 2013, you can get Windows 8 Pro for about $14.99!  Of course, you still have to register before February 2013 and follow the instructions in order to take advantage of this offer ... but it really is a GOOD deal .... and you don't have to worry about buying a new computer with Windows 7 installed.

Microsoft is also offering Windows 8 to folks who have recently bought a new computer with Windows 7 installed.   And by recently, I mean you have to have bought your new computer on or after June 2, 2012. If you bought your computer prior to June 2, 2012, you're out of luck!  You'll have to go out and buy a retail copy of Windows 8 upgrade software if you want to upgrade. 

Saturday, July 21, 2012

Tips for Labeling Photos

One of the questions I get asked a lot has to do with photos ... more specifically, "how do I keep in them in the order I want?"

The problem is that after scanning them into the computer, and arranging them in the order we want, the computer rearranges them in a different order.  The problem is the same for folders and actual images.   Many of my clients want to know how to fix this problem.

The first step in fixing the problem is understanding what causes it.  And the problem is caused by the name (or label) attached the photo.  For example, look at the image on the right.

It shows for folders (each containing photos).  If you look closely, you'll notice that all but the first folder are in alphabetical order.  The computer typically does this for me, but I can also arrange folders (and photos) alphabetically if I wish.

What this means, is that when you label a photo or scanned image, it doesn't matter how you arrange it in your computer, it will typically get rearranged alphabetically automatically.   So the first thing you can do to help combat the problem is to use care when naming your scanned images.  When you scan a group of images that are related to one another, make sure the name of the scanned image starts the same (e.g., family1, family2, family3, etc.).

But this only solves part of the problem.  It will keep all the "family" photos together, photos can still get out of order chronologically.   So for example, the photo named "family1" might have been taken in 1932, while the photo named "family2" might have been taken in 1925.  Yet, because of the name convention, the photo named "family1" will get placed before the photo named "family2".

So the next step in combating the rearrangement of photos problem, is to assign a number prefix to the folder or photo.  If you look at the image above again, you'll noticed that the first folder is named (or labeled), "1_Lehmans" .... and that even though "L" comes before "B", the "1_Lehmans" folder appears BEFORE the "Byers" folder.  Why?

The answer is in the "1_" prefix. By placing a number followed by an underscore before the actual filename, I force that folder into a specific position on my computer.  So in general, you rename your folders or photos using this naming convention to help force (and keep) them organized in a certain way on your computer.

However, while these two methods of naming files will help a lot in keeping photos organized a certain way, they're not full-proof.  Another thing you can do to help organize photos, is to keep them separated in folders.  For example, put each group of related photos into it's own folder.  This helps to keep them separated and easier to sort through.  You could even create a document to share more detailed information about the group of photos (such as when and where they were taken as well as who's in them).

Following the suggestions above for labeling your photos should help you keep them better organized.

Tuesday, July 3, 2012

5 Ways to Reset Your Computer Password

Have a password set up to log into Windows and can't remember it?  Perhaps you inherited a computer with a password already set up and have no idea what it is.  These are common problems and can usually be solved pretty easily.

There are generally 5 ways to reset a password on computers running Windows:
  1. Remove the CMOS battery on the Motherboard for a few seconds and replace it
  2. Use a jumper to clear the CMOS settings
  3. Log into the Admin account (if there is one) and rest the password
  4. Restore the computer back to Factory Settings.  
  5. Use a 3rd party software program (which typically costs money)
The first four methods listed above are free.  The last method is generally a software program you have to buy.  So I would recommend using one of the first four methods if you have to rest a computer password.

If you're comfortable working inside a computer case, then options 1 and 2 are usually pretty easy and quick (though you may need to refer to a manual to use option #2).  Working inside a computer case can be hazardous to the computer  though, so if you've never done it, or aren't comfortable, I would recommend not doing it yourself.   The biggest danger when working inside a computer case is discharging static to critical parts which can render the computer inoperable. 

Option #3 is a safer method of resetting the computer password.  Most computers today create a Admin account and hide it - this way it's there if needed later but doesn't interfere with the normal day to day operation of the computer for the user.  The best way to get into the Admin account is to boot the computer to SAFEMODE.  And the to do this, you need to restart the computer.  Follow the instructions below to boot the computer to Safemode:
  1. Make sure the computer is powered down (hold the power button in until it shuts off it's running)
  2. Turn the computer on, than hit the F8 key on the keyboard repeatedly until you get to a menu
  3. Chose the SAFEMODE option using the arrows on the keyboard and hit ENTER
If there is a hidden admin account, you should see it when Windows boot.  If there is one, click it to log in. If you don't see an Admin account, then you will have to use options 1, 2 or 4 to reset the computer password.

Assuming you can log into the Admin account (option #3), then resetting the computer password is easy.  Just open the CONTROL PANEL and then USER ACCOUNTS.   Then select the account name you want to reset the password for.  Once on that account, click CHANGE  PASSWORD.

The 4th option listed above, is generally a last resort option for resetting your computer password.   This is because Option #4 will erase your hard drive (and any data you had stored on it).

Most computers sold in the last 5 years have a copy of the operating system hidden on a partition of the hard drive.  Getting to can be easy or tricky depending on who made your computer.   If you have the user guide that came with your computer, it should tell you how to restore the computer back to factory settings.  If you don't have the user guide (or can't find it), you may be able to find it online at your manufacturer's web site. 

Be sure to watch the screen too when you first turn your computer on.  You may see a note about hitting certain keys (like F10, F11 or F12) to restore the computer settings.   On some computers, you have to hit the CTRL key in addition to one of the F-keys previously mentioned.  When in doubt, try all of the F-keys listed (with and without the CTRL key.

Hopefully one of the methods listed above will help your reset your computer password.

Monday, June 4, 2012

Recycling Old Computers & Electronics

Looking to recycle old computers, TV's and other electronic equipment?  Give TFS Networks a call.  If you live in any of the Quad-city areas (Prescott, Prescott Valley, Dewey, and Chino Valley), they'll even come to your house to pick the stuff up.

I was pleasantly surprised by their quick response and willingness to come to my house so I didn't have to load my car up and take the equipment to them.

Their phone number is 928-925-0776.    You can even schedule a pickup on line.  If you're interested in recycling any old computer equipment or electronics, click here for more information and a list of acceptable items.