Monday, 7 April 2014

How to fix a crashed computer?

Are you experiencing an unexpected computer crash? Is it a headache for you to fix the computer crash? Read on this post to check the reason of the computer crash and learn more on how to fix a computer crash.


The signs of computer crashes include the terrible Blue Screen of Death, automatic restarting of the computer, or computer freezing up with no response. A computer crash can be caused by complexity reasons: new software or file installation, failure in hardware, registry error, and poor maintenance of the PC. Figuring out what may cause your computer crash is the first step to deal with the problem.


New software installation

If you are experiencing the unexpected computer crash with the installation of a new program, it is possible that the new installed program conflict with other program settled on the operating system. Under such circumstance, it's easy to fix the crashed computer by uninstalling the newly downloaded program. Restart your computer into safe mode and then go to "Control Panel", open "Add or Remove Hardware" and select the program that you suspect is causing problems. Select "Uninstall" and follow the prompts to remove the program. You may fail to boot into normal mode, so please just boot into safe mode to uninstall the program.


Hardware failure

Under the condition that it is the hardware failure that causes the computer crash problem, you need to check for updates of the drivers of any hardware connected to your PC. I highly recommend you keep updated with the latest patches of drivers and windows to avoid the problem of computer crashes. If you do not want to check periodically for the updates, you can takeWindows Update Downloader to quickly download and install updates.


Registry error or corrupted registry

Registry error or corrupted registry is also the most common reason for a crash computer. Registry files, also called “windows registry” is the files that give your computer instructions for what to do next. Any corruption or misplacement will lead to failure of a computer to get orders as what to do next. When you install a program, the key registry item was modified to allow the program run, but when you choose to uninstall a program, the registry remains in the registry entry. With time goes on, the registry goes into a mess. To fix computer crash caused by corrupted registry, you should clean the invalid and corrupted registry to maintain the computer performance. Regular registry clean should be performed to avoid the computer crash.

It is highly recommend taking Cloud System Booster to clean the registry and repair registry errors for better computer performance.


Virus or malware issue

You should never overlook virus infections. They are a potential cause of computer crashes because some virus or Trojan code can delete or corrupt your system files once they settled on your computer which may lead to fatal system errors, and finally cause computer crashes. Under this circumstance, prevention virus infection is more important than fixing the computer crash. If the computer crash is caused by virus or malware, it's very difficult to fix the problem due to the corrupted system file. You may have to reinstall your operating system to recover your computer.


It is recommended to use firewall protection, anti-virus software as well as anti-malware software to protect your PC against virus infection. Scan before downloading and installing a file or program. Never follow links contained within a suspicious email. Use common sense when you go to internet.

Internet Explorer Repair--Tips and Tricks

With the rise of third party browsers such as Google Chrome, Mozilla Firefox, Internet Explorer is still one of the most widely used web browsers. You may come with the situation that you need to repair Internet Explorer because the browser may produce problems such as it acts sluggish, displays error messages, crashes unexpectedly, or any other problems. This post describes how to repair Windows Internet Explorer in Windows operating system.


If you are experiencing Internet Explorer browser problem, please read on the following tips which can help you to repair you Internet Explorer problem. If you are using Internet Explorer 9, Internet Explorer 8, or Internet Explorer 7, any of the following methods may resolve your problem. Try the methods that best apply to your situation.


Internet Explorer gets hijacked


It happens that your Internet Explorer get hijacked when your computer get infected with virus, spyware, adware or any other malicious program unexpectedly. In such case, you are highly encouraged to start the repair your Internet Explorer with a thorough scan of the computer for virus infestations. Your installed anti-virus program may unable to detect anything since it did not block it before the malicious code sneak on your operating system. Good anti-malware program is more suitable to remove the virus.


Recommended Anti-malware program: Anvi Smart Defender Image


After you install the recommended anti-malware program, please make sure you perform a full system scan and clean any viruses, Trojans and other malicious software from the system. Please be patient as full scan is time-consuming. You may still have problem in your Internet Explorer after the virus cleaning such as unwanted homepage, unexpected pop-ups and more. You may need to read and perform more steps to repair your Internet Explorer.


Internet Explorer malicious search providers and toolbars/add-ons


If you have malicious toolbar installed on your Internet Explorer, you may unable to change your homepage. When you search with
Internet Explorer, you are always redirected to unwanted website or URL. You should check the installed add-ons and toolbars or the search providers.

To do this, please open your Internet Explorer, and then go to Tools and then Manage Add-ons. You will be prompted to windows as shown in screenshot below:


Image


Check carefully the add-ons in the list, for the malicious add-ons, please do not hesitate to disable it by right-clicking on them and selecting disable from the context menu or selecting them and clicking on the Disable button in the low right corner of the window.
For some uncertain add-ons, please search online for detail information before you disable them.

Image


Next, please switch to Search Providers module. In this panel, you can check the search engines you currently use. For unwanted search engines, you can remove or disable it easily. Remember that you have leave one search engine and make it as default engine.


Reset Internet Explorer settings

In those versions of Internet Explorer, you can repair damaged files, error message, missing registration information or malicious browser modification by resetting the Internet Explorer settings.


To do this, please start your Internet Explorer, click on the Tools menu and select Internet Option and continue. You will be prompted to Internet Option Windows as shown below:

Image


Switch to Advanced tab; click Reset under Reset Internet Explorer settings. In the Reset Internet Explorer Settings dialog box, click
Reset to confirm.

Image


Repair Internet Explorer with Tool--Anvi Browser Repair

Above tips can help you to fix your Internet Explorer problem, but you may ask if there any tool which can repair browser problem easily. Absolutely yes, Anvisoft devoted and developed a free tool to help you conveniently repair browser settings and networking settings such as homepage, safe startup items, DNS settings, Title Bar, BHO plug-in, etc, changed by malware to return smooth browser use.

Because antivirus, antimalware tool can only helps detect and remove malware infections from computer, but can't do the duty to repair the damage caused by the virus. This free tool will practically assist normalizing safe browser searching. Anvi Browser Repair
Tool is designed to help fix browser, network settings altered due to rogueware/malware infections and even facilitate malware removal with one-click solution.

How to Recover Lost Files from Mac

Apple devices is becoming more and more popular in today’s society. Almost everyone wants an apple device whoever he is because of its fast operating speed and beautiful outlook. But nothing is perfect, there are upset things happening, such as losing data. Are you still anxious about recovering lost files from a crushed Mac Pro?

[Also read: Backup your Mac]

Data recovery
Data loss happens due to a lot of reasons, such as, unexpected power-off, system crush, virus attack and hard disk corruption.

Accidentally formatting is the most common cause of losing data. If you are an attentive PC user, you may do some safeguard procedures to protect the data when you encounter such problems which may relive the embarrassed situation. But in order to get back the complete data from a crushed Mac Pro, researchers has developed a data recovery software for Mac which can help common PC users to recover lost files such as pictures, music, videos easily within a few minutes.

10 Cool Tricks & Hacks That You Can Learn From Computer Geeks

computer geeks

Have you ever wondered why so many people out there can do wonders with their computers? Not because they are nerds. They have learned several computer hacks, tricks and shortcuts to impress their friends, and guess what? They have managed not only to impress their friends, but also to find a good job or earn money online by showcasing their skills. By reading this article you won’t necessarily become an expert in using a computer, but you will certainly become much better at using your computer.
Whether you are just a basic user or you have plenty of experience in using computers, you will find the following 10 computer hacks and tricks extremely useful. After reading this article, you will be able to impress your friends with your newly acquired computer skills.


10 Computer Hacks & Tricks


1. Learn How to Use the Command Line

The truth is that using the command line is not as exciting or easy as it seems like in Hollywood movies. However, learning how to use the command line might prove to be extremely helpful. Power users adore using the command line, because they can perform complicated tasks by simply pressing a few keystrokes.
There are a wide variety of shortcuts, but it takes too much time to present them all here. However, if you want to learn more about using the command line like a pro, check the following link: Become a Command Line Ninja With These Time Saving Shortcuts

2. Find Additional Uses for Programs you Already Have

Computer nerds will always think out of the box, especially when it comes to finding new uses for the tools and programs they already use. Most programs can be used for more purposes, in addition to their original one. For instance, the file-syncing program, Dropbox, can be used to monitor your home computer, download torrents or even print files from afar. You can also use Gmail to find out if someone has stolen your phone.

3. Understand When Too Much is Too Much

When your computer starts to work a little too slow, you need to find out the real cause behind this problem. Usually, one app will slow your system down, so you need to find it and close it as fast as possible.
The following tools should help you find the real cause and terminate it: Rainmeter (for Windows) and MenuMeter (for Mac).

4. Know the OS’s Hidden Features

Every operating system (OS) has its own tricks and features hidden under the hood. System tweakers such as OnyX for Mac and Ultimate Windown Tweaker are simply great for finding secret features. If you are a Windows user, you can learn how to hide secret data inside a file, cascade specific windows or undo an accidental file move.
As a Mac user, discover how to create search tokens when searching for specific files, manage the privacy settings of an app or automatically restart your computer when it freezes.

5. Learn How to Crack Passwords

By learning how to break into a computer you will certainly increase your self-esteem. Everyone knows how to create secure passwords, but only a legit computer hacker knows to get the data they want. This is also a good exercise, because you will learn how to protect from cyber criminals in the future.
Some of the worlds most famous hackers have been hired for government operations and international projects to defend against other cyber attackers. We don’t condone hacking, it does help though to be one step ahead of a cyber bully heading your way though.
computer nerd

6. Use the Scheduling Tasks

Sometimes it is better to stop performing all that system maintenance all by yourself. The built in task scheduler allows you to run any task you need, whether it is defragmentation, picture upload, reminders or even alarms.

7. Use the Keyboard More

A true computer geek knows all the basic keyboard shortcuts, such as “ctrl-C or ctrl-V”. Learn the most common shortcuts for Word, Gmail, Photoshop and other programs you use on a regular basis. After only a few months, you will be able to blow through text boxes and menus at unbelievable speeds with precision.

8. Discover New Operating Systems

If you really want to impress your friends, you should try to learn more about Windows, Mac and Linux.
Each OS has its own pros and cons that can be noticed with ease, so learning more about each system should not be such a daunting task. The cool thing is that there is a lot of software out there nowadays where it allows you to install another operating system on your computer so you can switch between each Operating System when you please.

9. Protect Your Data

Hide your precious info into a text file and hide it in a secret location on your computer.
Don’t forget to “Empty” your Recycle Bin or Trash on your computer once you have sent unwanted files or data there, that way it makes sure that nothing can be retrieved by any surprise guests you may have access your computer.

10. Tweak Your Hardware

With a bit of professional tweaking, you can now push your computer past its original limits. Installing Mac on non-Macs and over clocking your processors are not so hard to accomplish.
There are instructions out there to find out the details of your computers hardware, google search how to find your computer models information, note down the RAM and go down the road to your local computer hard ware store and buy bigger RAM sticks eg… 8GB, 16GB, 32GB etc… (Just make sure that each stick is the same make and model if you can for the best performance.
Jump on YouTube and learn how to Install RAM in your particular type of computer, this will increase your computers memory allowing your computer to run more efficiently.


All these cool simple tricks and hacks that can be learned from computer nerds are extremely useful, but require a little time and patience in the beginning.

Enjoy them and become a true computer geek.


If you have come across any cool hacks or tricks on your computer that have turned out to be pretty useful please share them with us in the comment section below.

Publisher to PDF Free Online

Publisher-To-PDF-Screenshot
Are you looking for a quick and easy solution on how to convert Microsoft Publisher to a .PDF Document?

Look no further as Publisher to PDF Free Online is a free online publishing tool that will do the the job for you.
Use publishertopdf.com to convert Publisher into PDF so you can share your work with anyone. It is 100% free! and simple to use. All you need do is upload your publisher document, fill in your e-mail address and click the send button and your pdf file will be created and delivered right to your email address.
“With Publisher to PDF  you can Convert Publisher(.pub) tot PDF instantly for FREE!”
Features:
  • Share with Anyone:
    Microsoft Publisher is a powerful desktop publishing tool. However, many computer owners do not have publisher. Use publishertopdf.com to convert publisher into PDF so you can share your work with anyone.
  • Easy PDF Creation:
    www.publishertopdf.com is 100% free and simple to use. All you do is upload your publisher document, click a button and then get your pdf file delivered right to your email address. Use us to convert publisher (.pub) to PDF instantly!
  • Retain Look and Feel:
    Microsoft Publisher is used by many to create professional looking documents, complete with formatted text and images. For users wanting to share their publisher documents exactly as they created them, PDF is the perfect format.
Note:
They give their guarantee: that your Email Address will NEVER be sold, rented or provided to any third party. Period.


Requirements:
Publisher Document  (.pub file) 
Rating: 4.0/5 (1 vote cast)

How To Install Whatsapp on Your PC or Laptop

Whatsapp is a free cross-mobile messaging platform which is well known to most of us. Whatsapp cuts down our SMS bills as well as provides a lot of other features like group chat, lets you send photos and videos. You can even share your current geographic location with your friends.

undefined

As mentioned above, Whatsapp is a messaging platform for mobiles. Currently, Whatsapp is available for iPhone, Blackberry, Nokia S40, Symbian and Windows Phone.

But there are a lot of users with some other mobile phones who don't want to miss out from the world of Whatsapp either. Are you one such mobile user?

Then there is a solution for you that will let you use Whatsapp with your laptop or even your PC!



How To Install Whatsapp on Your PC or Laptop


To run Whatsapp on a computer, we are going to use a tool named "Bluestacks".

Bluestacks is actually a tool that lets you emulate android applications on Windows OS like Windows XP SP3 and higher. Just like any other android application, Whatsapp can be run using bluestacks easily. Download bluestacks from here: bluestacks.com

After downloading and installing bluestacks, run and search Whatsapp from the search bar provided in bluestacks or alternatively you can download Whatsapp from its official site here: www.whatsapp.com

Now follow the steps shown on screen to install Whatsapp on your computer. You may need to confirm your mobile number during the installation. For this, you will be sent a special code to your mobile number which you need to re-enter when asked by Whatsapp during installation.

Thats it!

Now you are done with installing Whatsapp on your Laptop or PC and you can use it without any kind of limitations as perfectly as you could with a smartphone.

Common Issues Faced

  • Unable to download Whatsapp directly from Bluestacks - Try downloading Whatsapp using your computer's browser from the official whatsapp site or from some other website providing android application (apk) files.
  • How to add contacts to Bluestacks - Go to settings, manage contacts, then click on the menu button provided on the lower left side of Bluestacks and select "New Contact".
Any more issues?

How many of you are going to use Bluestacks now? I hope you don't come across any issues but even if you do face any problems installing Whatsapp on your PC or laptop, do comment and let me know.

How To Install More Than 1 OS On A Single Partition Using VirtualBox

How To Install More Than 1 OS On A Single Partition Using VirtualBox

 

You may be a Windows user, a Linux user or you may be using some other operating system. It may happen that you want to try out any other OS or you may be a developer using some other OS.

In this case you have 2 primary options to install the second OS on your computer:
1. To install the second OS on a different partition and use a multi-partition system.
2. To install the second OS on the same partition.

The first option of creating a separate partition may create some issues in the long run. Either that the two OS may not be a well compatible one or  your hard drive may get corrupted more easily due to viruses or other vulnerabilities.

And that is why you might be interested to know more about the second alternative i.e. to install the another OS on the same partition and more specifically - on the same OS.

This is possible with - VirtualBox.

VirtualBox

VirtualBox is a freeware software that can emulate a virtual hard drive using some space on your real hard drive on some OS. The virtual hard drive on the VirtualBox system can then be used as a new computer itself and can be used to install and use any other OS that you can install on any normal hard drive.


To know more about VirtualBox and to download VirtualBox visit here: Virtualbox.org

For an example on how to use VirtualBox, we will have a look at creating a virtual hard drive and installing Windows XP on it.

How To Install Windows XP In VirtualBox


I chose Windows XP for this tutorial because there are a lot of Linux users and developers who use this OS for testing and other purposes. And Windows XP is still the most preferred OS in the world.

So let us start with the steps:

1. Download and install VirtualBox


2. Run VirtualBox And Create New Virtual Machine

Using VirtualBox To Install an OS

  •  Start VirtualBox and select on the 'New' button to start the "Create New Virtual Machine" Wizard.

Using VirtualBox To Install an OS

  •  Choose a name for your Virtual Machine (VM), select an OS and its version from the list.

Using VirtualBox To Install an OS

  • At this stage, you have to select the amount of RAM you would like to dedicate to your virtual machine.

Using VirtualBox To Install an OS

  • If you have never created a virtual hard disk with VitualBox before (which I suppose here), then you would have only 1 option and that is to create a new one now.

Using VirtualBox To Install an OS
  • Now there are 2 types of hard drives that you can create using VirtualBox. First is the dynamically expanding one which uses less space in the beginning and expands as needed. This one is ideal for those with smaller hard drive. The second one is of fixed-size which is better in case you have a larger hard drive and can wait a few extra minutes while the virtual drive is being created.

Using VirtualBox To Install an OS
  • After that, choose a name for your virtual disk and assign a size to it. For OS like Windows or Linux, about 6-10 GB would be sufficient to install and run the OS for minimum usage level. But if you are interested in installing the OS for heavier use and for storing a moderate or large number of files even in that second OS, you should assign at least 50 GB to your virtual hard disk.
Using VirtualBox To Install an OS
  • Check the final summary and click on 'Finish' to complete the process of creating the virtual machine.

3. Attaching The Required Removable Media To Install The OS


After having created the virtual machine along with the virtual hard disk, the next task is to attach the removable media which contains your OS installation files like a DVD or CD.

Select the newly created VM and click on "Settings" icon. Then go to storage settings.

Using VirtualBox To Install an OS

As shown in the figure, select the empty storage below the newly created virtual drive and then assign the removable media you want to use with it. You can select a CD/DVD or even a pendrive.

Now you are almost done with your VM.

4. Run The VM And Install Your OS


The last step is to run your virtual machine and install the OS from the removable storage you selected just a few while ago.

Select the VM from the main screen and click on the "Start" icon.

That's it!

Your virtual machine will now start just like a brand new unused computer. Follow the installation steps you perform with any normal hard drive and install the OS on your virtual hard drive.

[Note: If you want to install Mac OS X on VirtualBox, refer this tutorial.]

After the installation is over, you can start using the virtual OS as you would use if you installed it on a separate partition! And that too without any risks, vulnerabilities or any kind of issues that you would face if you preferred a multi-partition system.

Tips And Summary On Using VirtualBox


  • VirtualBox is a simple and free solution to install more than one OS on your computer. There are a lot of issues with multi-partition systems that you can easily avoid with the help of VirtualBox.
  • To use more than 1 OS on your system, you need to install VirtualBox and create a virtual machine for your OS.
  • Assign enough RAM and hard drive space to your virtual machine so that it runs smoothly but doesn't trouble the main system at the same time.
  • Install your OS from the CD/DVD drive that you normally use and start using your 2nd OS! That too - within the same OS!
Facing any problems? Or any kind of errors? Be sure to drop a comment and let me help you!

  

How To Install More Than 1 OS On A Single Partition Using VirtualBox

How To Install More Than 1 OS On A Single Partition Using VirtualBox

 

You may be a Windows user, a Linux user or you may be using some other operating system. It may happen that you want to try out any other OS or you may be a developer using some other OS.

In this case you have 2 primary options to install the second OS on your computer:
1. To install the second OS on a different partition and use a multi-partition system.
2. To install the second OS on the same partition.

The first option of creating a separate partition may create some issues in the long run. Either that the two OS may not be a well compatible one or  your hard drive may get corrupted more easily due to viruses or other vulnerabilities.

And that is why you might be interested to know more about the second alternative i.e. to install the another OS on the same partition and more specifically - on the same OS.

This is possible with - VirtualBox.

VirtualBox

VirtualBox is a freeware software that can emulate a virtual hard drive using some space on your real hard drive on some OS. The virtual hard drive on the VirtualBox system can then be used as a new computer itself and can be used to install and use any other OS that you can install on any normal hard drive.


To know more about VirtualBox and to download VirtualBox visit here: Virtualbox.org

For an example on how to use VirtualBox, we will have a look at creating a virtual hard drive and installing Windows XP on it.

How To Install Windows XP In VirtualBox


I chose Windows XP for this tutorial because there are a lot of Linux users and developers who use this OS for testing and other purposes. And Windows XP is still the most preferred OS in the world.

So let us start with the steps:

1. Download and install VirtualBox


2. Run VirtualBox And Create New Virtual Machine

Using VirtualBox To Install an OS

  •  Start VirtualBox and select on the 'New' button to start the "Create New Virtual Machine" Wizard.

Using VirtualBox To Install an OS

  •  Choose a name for your Virtual Machine (VM), select an OS and its version from the list.

Using VirtualBox To Install an OS

  • At this stage, you have to select the amount of RAM you would like to dedicate to your virtual machine.

Using VirtualBox To Install an OS

  • If you have never created a virtual hard disk with VitualBox before (which I suppose here), then you would have only 1 option and that is to create a new one now.

Using VirtualBox To Install an OS
  • Now there are 2 types of hard drives that you can create using VirtualBox. First is the dynamically expanding one which uses less space in the beginning and expands as needed. This one is ideal for those with smaller hard drive. The second one is of fixed-size which is better in case you have a larger hard drive and can wait a few extra minutes while the virtual drive is being created.

Using VirtualBox To Install an OS
  • After that, choose a name for your virtual disk and assign a size to it. For OS like Windows or Linux, about 6-10 GB would be sufficient to install and run the OS for minimum usage level. But if you are interested in installing the OS for heavier use and for storing a moderate or large number of files even in that second OS, you should assign at least 50 GB to your virtual hard disk.
Using VirtualBox To Install an OS
  • Check the final summary and click on 'Finish' to complete the process of creating the virtual machine.

3. Attaching The Required Removable Media To Install The OS


After having created the virtual machine along with the virtual hard disk, the next task is to attach the removable media which contains your OS installation files like a DVD or CD.

Select the newly created VM and click on "Settings" icon. Then go to storage settings.

Using VirtualBox To Install an OS

As shown in the figure, select the empty storage below the newly created virtual drive and then assign the removable media you want to use with it. You can select a CD/DVD or even a pendrive.

Now you are almost done with your VM.

4. Run The VM And Install Your OS


The last step is to run your virtual machine and install the OS from the removable storage you selected just a few while ago.

Select the VM from the main screen and click on the "Start" icon.

That's it!

Your virtual machine will now start just like a brand new unused computer. Follow the installation steps you perform with any normal hard drive and install the OS on your virtual hard drive.

[Note: If you want to install Mac OS X on VirtualBox, refer this tutorial.]

After the installation is over, you can start using the virtual OS as you would use if you installed it on a separate partition! And that too without any risks, vulnerabilities or any kind of issues that you would face if you preferred a multi-partition system.

Tips And Summary On Using VirtualBox


  • VirtualBox is a simple and free solution to install more than one OS on your computer. There are a lot of issues with multi-partition systems that you can easily avoid with the help of VirtualBox.
  • To use more than 1 OS on your system, you need to install VirtualBox and create a virtual machine for your OS.
  • Assign enough RAM and hard drive space to your virtual machine so that it runs smoothly but doesn't trouble the main system at the same time.
  • Install your OS from the CD/DVD drive that you normally use and start using your 2nd OS! That too - within the same OS!
Facing any problems? Or any kind of errors? Be sure to drop a comment and let me help you!

  

31 shortcut keys for Microsoft Excel

31-shortcut-keys-for-Microsoft-Excel
Here are 31 handy keyboard Shortcuts that you can use on Microsoft Excel.
 
  1. F1: Opens a help task pane.
  2. F1 + Ctrl: Opens or closes the help window.
  3. F2: To edit the text in the active cell.
  4. F2 + Shift: To write a comment in the active cell.
  5. F2 + Alt: Opens the save as dialog box.
  6. F3 + Shift: opens the insert dialog box.
  7. F3 + Ctrl: Opens the define name dialog box.
  8. F3 + Shift + Ctrl:  Opens the create name dialog box.
  9. F4:  To redo the last command.
  10. F4 + Ctrl: To close the workbook window.
  11. F4 + Alt: To close the excel program.
  12. F5: Opens the Go to dialog box.
  13. F5 + Ctrl: brings back to the first level of workbook.
  14. F6: To shift between help taskbar and the excel window.
  15. F6 + Shift: To goto the previous square in the open worksheet.
  16. F6 + Ctrl: If more than one workbook is open to switch between them.
  17. F7: To open spelling correction window.
  18. F7 + Ctrl: When workbook window is not maximised it will move the window.
  19. F8: To activate / deactivate extended mode.
  20. F9: Will calculate all the worksheets in all open workbooks.
  21. F9 + Shift: Will calculate the active worksheet.
  22. F9 + Ctrl: To Minimise the workbook window.
  23. F10: Will select the menu bar.
  24. F10 + Ctrl: To open minimised window.
  25. F11: Will create a chart using the current range.
  26. F11 + Shift: To select a new worksheet.
  27. F11 + Alt: To switch between visual basic editor and the worksheet.
  28. F11 + Alt + Shift: Opens Microsoft script editor.
  29. F12: Opens save as dialog box.
  30. F12 + Shift: Saves the active workbook.
  31. F12 + Ctrl: To open the Open dialog box.
If you know more shortcut keys in Microsoft Excel then please feel free to have your say Smile

How To Check Your Windows OS For Errors

How To Check Your Windows OS For Errors  - Chkdsk - Screenshot
Chkdsk is a shorthand code for Checkdisk, and is a problem solving tool in your computer.
Chkdsk runs on your system checking specified disks for error, problems, and when prompted will help fix them. Unlike some system tools, this is not accessible from the menus and must be run through the command prompt.
The Commands:
To use Chkdsk, you are going to need to know and understand a few simple commands. If you are familiar with programming languages or MS DOS, this process will feel fairly comfortable.
Volume: (colon part of command) tells chkdsk which file(s) to run. Wildcard (* and ?) characters are accepted.
/f: command to fix error on files. If files cannot be fixed while running, chkdsk will ask if files should be checked during start up.
/v: lists the files on a disk as they are checked.
/r: locates bad sections and restores readable information
/x: Makes the volume dismount first, and includes the /f command. **
/i: command to run a more general chkdsk, takes less time.**
/c: does not check the cycles in the folders, reduces time to run chkdsk. **
/l[:size:]: reduced log size to specifications, if left blank will show current log size. **
/?: opens help and support from the command prompt panel.
** These commands can only be used with NTFS (New Technology File System), and is available on Windows operating systems Windows NT and newer, including Windows XP,Windows Vista, and Windows 7.
The Syntax:
Whenever you are working in command prompt, how you input commands will matter. They must be in the correct order and in the correct format, or you will get a syntax error back, which basically means that your computer can not understand you.
Follow the  5 steps below to input the desired command(s):
Step (1) Open main menu and click RUN. In the box, type “cmd”
Step (2) In the box, type “cmd”
Step (3) This Should open window with black background, white characters, and the last line should show: C:\Users\computername>
Step (4) Type in your desired command in this format: chkdsk[volume:][[path]filename] [/f] [/v] [/r] [/x] [/i][/c] [/l[size:]]
Step (5)
Not all commands will be used at the same time. Commands will vary depending on desired results.
Examples
If you want to run chkdsk on the D drive you may want to use: chkdsk d: /f
If you are looking to run a general check, type chkdsk *.* This will display a report of the current disk.
Reporting
Chkdsk will give you a detailed report of what it has done, which also includes various exit codes. The report will tell you if things have been fixed, how large the files are, and other pertinent information.
The exit codes are as follows:
  • No errors found.
  • All found errors were fixed.
  • Either clean up was performed or not performed because the /f command was not used.
  • Disk could not be repaired or checked; /f command was not used.
Note:
And remember, chkdsk is not a fast running process, depending on the size of the drive being checked, chkdsk can take hours or days to complete. Once started the chkdsk process cannot be stopped.

How To Make a Windows 7 Repair Disc

How To Make a Windows 7 Repair Disc - CD - Screenshot 001
When a serious error occurs on your system, there are several recovery options available to you,
Though as anyone who has Windows 7 knows, the options in Microsoft's new operating system are different from those that have come in previous versions.
  • What to do when you need to repair Windows 7:
    Use this article as a way to navigate the repair process in Windows 7.  Specifically, we'll talk about making a System Repair DVD, a feature that is unique to Windows 7 and constitutes the best way to restore a damaged system after a major crash or a malicious attack.  Below are the three repair strategies available.
  • Using a OEM Recovery Partition:
    Many manufacturers will provide a recovery partition for use by the end user. To recover your system this way the user must boot into the advanced options screen.
  • Using a Windows 7 Installation Disc:
    To recover your system using the installation disc, insert the disc and restart your computer. You can also use your Windows 7 Installation disc to manually make a recovery disc. Make sure the BIOS is set to boot from CD or DVD or press F8 during boot process. But many people don't have an installation disk, receiving their copy of Windows 7 pre-installed on a computer.
  • Using a System Repair DVD:
    For those who did not receive an installation disc with their purchase can use a system repair DVD.  This is a feature whereby you insert a blank DVD+R and Windows will make a special repair disk that can be used whenever an emergency arises.
The majority of users today have purchased their PC’s with Windows 7 already loaded by the manufacturer. In these cases the user does not have a Windows Installation disc. The problem here is that the Windows Installation disc is not only used to install software but includes the full version Recovery Center provided by Microsoft.
  • The Recovery Disc:
Microsoft has helped the user overcome this issue by creating a recovery disc that can be created by the user to repair Windows 7 files. The Windows 7 Recovery Disc allows the user to access a system recovery menu after a system crash. This menu has options for using System Restore, Complete PC Backup, automated system repair, and a command-line prompt for manual advanced recovery. Note: Windows 7 can be repaired but not re-installed.
 
How to make to make a repair disc;
Follow the 5 steps below to continue:
Step (1) Insert a blank DVD+R (the R is for "Recordable") into your computer's DVD or CD-ROM.
Step (2) Open the Start Menu
Step (3) In the Search Field, type "Create a System Repair Disk"
Step (4) When you see it, select it.  This will open the automatic disk creator.
How To Make a Windows 7 Repair Disc - Create A System Repair Disc - Screenshot 002
Step (5) Click "Create Disk" and Windows will begin burning the repair image into the disk.
Once the process is finished, you'll have a disk that you can automatically boot from.  It will include, among other things, a template for how Windows 7 should look without any problems, viruses, or damaged internal structures.  It also includes a set of repair tools, specially designed to seek out other problems and eliminate them. If you are among the many users who spent the money for a system featuring Windows 7 and you do not have a System Repair DVD, now is the time to make one. Waiting until your system has crashed will cause you significantly more time and frustration.

Tips On How To Safeguard Your PC

Tips On How To Safeguard Your PC- Screenshot 001
There are times that an anti-virus is simply not enough to protect your  PC from external threats.
Nowadays, the moment you log on into the Internet or the moment you let an external device access your machine, you are risking the sanity and integrity of your system. Aside from making sure you have an updated antivirus, there are several things you also need to take note of to prevent invasion from Internet intruders whenever you use your laptop or desktop. Having an antivirus installed. You must first make sure you have a reputable antivirus security suite installed such as ESET Smart Security, Avast Internet Security or AVG Internet Security. If you work in a group setting then getting a group license might be the way to go. Properly install these antivirus programs straight from their cd’s or download it from the internet and select the regular scanning option so that your laptop or desktop is regularly scanned for threats. Get yourself familiar with the settings of the program such as what type of threats are identified and how they are dealt with. Check also the frequency of the scan and if it can be adjusted to a more frequent setting. Be sure that you are installing a legitimate copy of the program since illegal copies may be the source of malicious spyware.
 
  • Configuring parental control:
    One other way to make sure that you are guarded against Internet intruders is by checking the parental control section of the program. Most often you can blacklist specific URL’s so that any browser cannot access them. This can be done on a per machine basis. You can also restrict what type of website ratings can only be accessed. Most often,  malicious spyware is found in adult sites so not only are you protecting your kids from such content, you are also protecting your machine from a surprise attack.
  • Other precautions listed:
    There are also other ways for you to be extra careful such as disconnecting from the Internet when you are not using your laptop or desktop. This goes for those who are fond of downloading items and leaving their machines running on idle. It is during this time that your machine is susceptible to attacks. Make sure that you only connect to the Internet when you need to. Go offline once you are done.
  • Checking for updates:
    While having programs that block threats is great, it can get better by making sure you get the updates of the program. This way, you inherit bug fixes and new features that enhance the protection going around your machine. Updates are usually available every time a scan is run. Most often updates are done at least once a month since the programmers normally release a well tested version of the program in that amount of time.
  • Things to keep in mind:
    Keep in mind that nothing beats responsible usage of the Internet and responsible attaching of files to protect yourself from threats. Make sure that all attachments are scanned before download and that all instant messaging attachments are not dubious upon receipt. Just continue helping yourself and your antivirus spy ware will help you, too.  

How To Fix Windows Update Error 800b0100

How To Fix Windows Update Error - Error  800b0100 - Screenshot 001
If your computer is trying to update and instead of an improved machine you get the cryptic Windows Update Error 800b0100,
don’t panic – this particular error is pretty simple. When you get the update error 800b0100, it means your system couldn’t connect with the Microsoft Servers to complete an update. To resolve the issue, you’ll need to allow your computer to “talk” to Microsoft by disabling your firewall.
This tutorial is suitable for Windows Vista and Windows 7 only!:
  • Disable Your Firewall:
    If you’ve installed any sort of firewall on your machine, your first step will be to disable it temporarily. You do this by going to the firewall program (Start/All Programs/Firewall Program Name) and opening up the management window for the firewall. There will likely be an on/off toggle or a button to disable the firewall there.
  • Once the firewall is down, try the failed update again. If it goes through, you’ll likely be required to restart your computer. When you do, your firewall will likely reengage automatically or you can go back into the management program to start it again.
  • Disable Windows Firewall:
    If you find that your firewall isn’t the problem and the update isn’t going through even with your firewall disabled, you’ll want to check and see if the Windows firewall is causing the problem.
(Step 1) Go to Start and open your Control Panel.
How To Fix Windows Update Error - Click Control Panel - Screenshot 002
(Step 2) Once Control Panel is open, select Windows Firewall.
How To Fix Windows Update Error - Select Windows Firewall- Screenshot 003
(Step 3) Once you’re in the Windows Firewall, you’ll see an option to Turn Windows Firewall on or off.
How To Fix Windows Update Error - Turn Windows Firewall on or off - Screenshot 004
(Step 4) Click on this selection on the left menu bar. In the settings window that opens, change the settings to Off.
How To Fix Windows Update Error - Turn Windows Firewall off - Screenshot 005
(Step 1) Save your settings:
Try downloading the update again now that your firewall is disabled. Once the update is finished and you’ve finished that process, repeat these instructions to turn your firewall back on again as quickly as possible.

Prevent Automatically Restart After Failure In Win 7

How To Prevent Automatically Restart After A Failure  Win 7 - Failure Screenshot 001
If Windows 7 fails and displays a Blue Screen (possibly due to a driver error), this includes some debug information.
More detail in a kernel memory dump is written to the system hard drive, and then the machine reboots. While servers for the most part need to automatically reboot upon system failure so they can more quickly restart and handle requests, desktop computer users may not need this functionality. By reading the on-screen debug data and using search engines or posting it to forums, the cause of the critical restart may be found and in some cases fixed.

Please follow the steps below to proceed:
(1) Click the “Start” button, selecting “Control Panel”.
(2) If you are using an expanded Control Panel, select “System”.
Otherwise click “System and Security”, then “System”.
Advanced system settings - Screenshot 002
(3) In the left pane, select “Advanced system settings“.
(4) If the User Account Control dialog box appears, click “Yes“.
(5) The “System Properties” multi-tabbed dialog box appears. Click the “Advanced” tab.
(6) Underneath “Start-up and Recovery”, click the “Settings” button.
Start-up and Recovery Settings - Screenshot 003 Accessing Windows 7′s Startup and Recovery settings`
(7) The “Startup and Recovery” dialog box appears. Underneath “System failure”, uncheck “Automatically restart”.
Startup and Recovery - Dialog Box - Screenshot 004
Configuring Windows 7 to not automatically restart when it detects a system failure
(8) Click “OK” on the dialog boxes to close them.

How To Disable AutoPlay of Audio CDs and USB Drives

How To Disable AutoPlay Of Audio CDs and USB Drives - AutoPlay Window - Screenshot 001
AutoPlay Window
You ever got annoyed when you insert an CD or plug-in USB Drive and  a window pops-up. Well Today its your lucky day and I  liken to show you how easy it is to disable the AutoPlay  Feature of Audio CD’s and USB drives.

Please  follow the 3 steps below to disable the AutoPlay Feature In  Windows XP.

(1) To get to the configuration screen for this setting, go to Start Menu Run and type in:
gpedit.msc
You will see the Group Policy window. You should select Administrative Templates System in the tree view:
How To Disable AutoPlay Of Audio CDs and USB Drives - Group Policy - Screenshot 002
Group Policy
(2) You will see an item in the right side pane called “Turn off AutoPlay
How To Disable AutoPlay Of Audio CDs and USB Drives - Turn off AutoPlay - Screenshot 003 Turn off AutoPlay
(3) Double click the item, and set the radio button to Enabled, and change the “Turn off AutoPlay on” to All Drives.
How To Disable AutoPlay Of Audio CDs and USB Drives - Turn Off AutoPlay Properties  - Screenshot 004
Turn off AutoPlay Properties
that’s It! now you should be safe from the AutoPlay Feature in Windows XP.

Please feel free to submit your comment”

Obit Toolbox

IObit Toolbox - Screenshot
Obit Toolbox is a free portable software that system administrators and computer geeks will take along to solve PC problems anytime and anywhere.
With more than 20 dedicated tools, IObit Toolbox allows you to display/diagnose PC information, enhance PC security, optimize PC performance and repair PC problems. IObit Toolbox is like a Swiss army knife, with more than 20 computer tools in one place, you have more than 20 powers to diagnose and fix PC problems, including cleaning, optimizing, repairing, and security. IObit toolbox requires no installation. You can take it along with you in any portable devices, like flash disk, to solve PC problems anytime and anywhere. It eats little room on your disk. Each admin tool in IObit Toolbox is stand-alone and powerful. You can make yourself an own toolbox with your company brand, all we require is to leave the "powered by IObit" part.
“IObit Toolbox offers an easy way for PC admin to monitor and manage computers. It can be used for both commercial and non-commercial purposes.”
Features:
  • More than 20 dedicated tools in one place:
    IObit Toolbox is like a Swiss army knife, with more than 20 computer tools in one place, you have more than 20 powers to diagnose and fix PC problems, including cleaning, optimizing, repairing, security and fully control.
  • Completely portable, no installation required:
    IObit toolbox requires 0 installation. You can take it along with you in any portable devices, like flash disk, to solve PC problems anytime and anywhere. Also it eats little room in your disk.
  • Powerful and easy-to-use:
    Each admin tool in IObit Toolbox is stand-alone and powerful. They are capable of handling different tasks perfectly. Of course, they are organized professionally and very easy-to-use.
  • Totally Free:
    Tools like IObit Toolbox can cost you $200 or more! You no longer need to search on the internet and do the collection yourself, you don't need to pay! In IObit Toolbox you will find computer tools you want for free.
  • Easy Customization:
    Make yourself an own toolbox with your company brand, all we require is to leave the "powered by IObit" part.’
 
“Please feel free to submit your comment”
 
OS Requirements:
Win 2000/Win XP/
Vista/Win 7
(32-Bit or 64-Bit)Download - Obit Toolbox

How To Show Text And Images Instead of Icons Only

How To Show Text And Images Instead Of Icons Only - Screenshot 001
Unlike the previous Windows Operating Systems, Windows 7 uses an icon only in the Taskbar.
If you find this difficult to use, you can return the buttons back to the way they used to be so that the button displays a label for the open file or application.
 
Follow the steps below to proceed:
(1) Right-click on an empty portion of the Taskbar and select Properties.
(2) Go to the Taskbar buttons section and use the dropdown to change it from Always combine, hide labels to Never combine.
 How To Show Text And Images Instead Of Icons Only - Screenshot 002 (3) Click the OK button.
 
Your Taskbar will go from Icons:
Icons Only - Screenshot 003
 
To Icons and text in theTaskbar:
Icons and Text - Screenshot 004
 
 
“Please feel free to submit your comment”


Tips Tricks And Tutorials

You can also receive Free Email Updates:

Widget by NBT

Tips Tricks And Tutorials

You can also receive Free Email Updates:

Widget by NBT

Tips Tricks And Tutorials

You can also receive Free Email Updates:

Widget by NBT