tag:blogger.com,1999:blog-330014206750250662024-03-05T16:48:17.440-08:00Computer Trickscool computer tricks tips, Hacking,Mobile tricks & TipsPRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.comBlogger66125tag:blogger.com,1999:blog-33001420675025066.post-85227144199730407132010-11-27T10:29:00.000-08:002010-11-27T10:30:42.681-08:00Remote password hacking software - sniperspy<div class="separator" style="clear: both; text-align: center;"><script type="text/javascript">
ch_client = "rafaybaloch";
ch_width = 336;
ch_height = 280;
ch_type = "mpu";
ch_sid = "Chitika Default";
ch_backfill = 1;
ch_color_site_link = "#0000CC";
ch_color_title = "#0000CC";
ch_color_border = "#000000";
ch_color_text = "#000000";
ch_color_bg = "#FFFFFF";
</script> <script src="http://scripts.chitika.net/eminimalls/amm.js" type="text/javascript">
</script><iframe allowtransparency="true" frameborder="0" height="0" hspace="0" id="ch_ad786" marginheight="0" marginwidth="0" name="ch_ad786" scrolling="no" src="about:blank" style="display: none;" vspace="0" width="0"></iframe> </div><span class="post-icons"></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqBlyAKwfXkIMDG1eQxAQ5alu7U52pyfGpzqK6fAOSiOMw4VmDOM9XBDgS_q6FwIpGZclMdVQYDyuo_wHWw__TCcPjZ2xb1NLNgeBJVpAyp_SiInv2SRulpWoBnu1xyiOz7DvLZfyvTA/s1600/images.jpeg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Spy on a pc" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqBlyAKwfXkIMDG1eQxAQ5alu7U52pyfGpzqK6fAOSiOMw4VmDOM9XBDgS_q6FwIpGZclMdVQYDyuo_wHWw__TCcPjZ2xb1NLNgeBJVpAyp_SiInv2SRulpWoBnu1xyiOz7DvLZfyvTA/s320/images.jpeg" /></a><br />
Are you looking for the Best <b>Remote password hacking software</b>? Do you need to spy on your remote computer without the need for physical access? But wait! Before you go for any <b>remote spy software</b> you should read our shocking reviews!<br />
<a href="http://www.blogger.com/post-edit.g?blogID=33001420675025066&postID=8522714419973040713" name="more"></a><span style="font-size: medium;"><b>1. Sniper Spy (Remote Install Supported)</b></span><br />
<br />
<b><i><span style="color: green;">Editors Rating:</span></i> <span style="color: red;">8/10</span></b><br />
<div class="separator" style="clear: both; text-align: center;"><span class="Apple-style-span" style="color: #10121a; font-family: verdana; font-size: 11px; font-weight: normal; margin-left: 1em; margin-right: 1em;"></span></div><br />
<div><b><span class="Apple-style-span" style="color: #10121a; font-family: verdana; font-size: 11px; font-weight: normal;"><br />
</span></b></div><a href="http://www.sniperspy.com/images/box6b.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img align="right" alt="Remote password hacking software" border="0" height="164" src="http://www.sniperspy.com/images/box6b.gif" style="margin-top: 10px;" width="149" /></a><i><span style="color: red;"><b>SniperSpy</b><a href="https://www.plimus.com/jsp/buynow.jsp?contractId=2160696&referrer=rafay112"> </a></span></i>is the industry leading <b>Remote password hacking software</b><a href="https://www.plimus.com/jsp/buynow.jsp?contractId=2160696&referrer=rafay112"> </a>combined with the <b>Remote Install and Remote Viewing feature.</b><br />
Once installed on the remote PC(s) you wish, you only need to login to your own personal SniperSpy account to view activity logs of the remote PC’s! This means that you can view logs of the remote PC’s from anywhere in the world as long as you have internet access!<br />
<b>Do you want to Spy on a Remote PC? Expose the truth behind the lies! Unlike the rest, SniperSpy</b> allows you to remotely spy any PC like a television! Watch what happens on the screen LIVE! <b>The only remote PC spy software with a SECURE control panel!</b><br />
This Remote PC Spy software also saves screenshots along with text logs of chats, websites, keystrokes in any language and more. Remotely view everything your child, employee or anyone does while they use your distant PC. Includes LIVE admin and control commands!<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSMlpL2XRYLOB954UVrezHznRZwCtB41xyCpnHD0jnu9RCw06DvZjcQGEr-8RYMvhsJCrEciJ-O7DmnYxN7727WguGM_pQhjq6tnaIgcj_6AOcNyrzp5SY2BlhF0-1aQy8otRutpJfDQ/s1600-h/sniper-spy.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="remote password hacking software" border="0" height="380" sniperspy="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSMlpL2XRYLOB954UVrezHznRZwCtB41xyCpnHD0jnu9RCw06DvZjcQGEr-8RYMvhsJCrEciJ-O7DmnYxN7727WguGM_pQhjq6tnaIgcj_6AOcNyrzp5SY2BlhF0-1aQy8otRutpJfDQ/s400/sniper-spy.gif" width="400" /></a></div><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidFUPY4D6JYr5-g4hS-4buipP7cUPc106m_TJZf9Z29uTBTcd5tLNSB35O9xR_unu8TeP_j7JkfRm3U7VBE64BQCtWIZcMm6eRxSI5IXeLumynaSNZ9BvHgsCK28pbXHV-IqrnvzvsXg/s1600-h/sniperspy_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="remote password hacking software" border="0" height="377" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidFUPY4D6JYr5-g4hS-4buipP7cUPc106m_TJZf9Z29uTBTcd5tLNSB35O9xR_unu8TeP_j7JkfRm3U7VBE64BQCtWIZcMm6eRxSI5IXeLumynaSNZ9BvHgsCK28pbXHV-IqrnvzvsXg/s400/sniperspy_2.png" width="400" /></a></div><br />
<b>SniperSpy Features:</b><br />
1. SniperSpy is remotely-deployable spy software<br />
2. Invisibility Stealth Mode Option. Works in complete stealth mode. Undetectable!<br />
3. <b>Logs All Keystrokes</b><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKLbyeWeaIehZCJMT09W8fz2iDXOHBE9f8bMhxYIm3Jl_gQxdGYbT0ZJNJ4jnpGtRnisrm5CzetgxiFOz7z63tjBO2E7SGTorR_YpJ4C6Fz2CxsReuMJGT-CrqzZPXwg837_Yc2tcyeg/s1600-h/sniperspy_cheating_spouse_keylogger.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="remote password spying software" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKLbyeWeaIehZCJMT09W8fz2iDXOHBE9f8bMhxYIm3Jl_gQxdGYbT0ZJNJ4jnpGtRnisrm5CzetgxiFOz7z63tjBO2E7SGTorR_YpJ4C6Fz2CxsReuMJGT-CrqzZPXwg837_Yc2tcyeg/s320/sniperspy_cheating_spouse_keylogger.jpg" title="Monitor a PC" /></a></div><br />
4. Records any Password (Email, Login, Instant Messenger etc.)<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYbdALAbxduD2qODdIOnKJeKaRIijA-ktLp_HYAD9IP9cLPJFoAtBihvWmwEiRMJY3vU8XVdD8Zqev7Def-uf6WF0QBVRal-8xvBvGVqu56rrR3kZY2e24uEtWDHYhS5W3DDtQpdBUIA/s1600-h/SniperSpy3+%281%29.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYbdALAbxduD2qODdIOnKJeKaRIijA-ktLp_HYAD9IP9cLPJFoAtBihvWmwEiRMJY3vU8XVdD8Zqev7Def-uf6WF0QBVRal-8xvBvGVqu56rrR3kZY2e24uEtWDHYhS5W3DDtQpdBUIA/s400/SniperSpy3+%281%29.jpg" width="400" /></a></div><br />
5. Remote Monitor Entire IM Conversations so that you can spy on IM activities too<br />
6. Captures a full-size jpg picture of the active window however often you wish<br />
7. Real Time Screen Viewer<br />
8. Remotely reboot or shutdown the PC or choose to logoff the current Windows user<br />
9. Completely Bypasses any Firewall<br />
<br />
<b>What if i dont have physical acess to victims computer?</b><br />
<b><br />
</b><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0f4wFCQAjZoU_FVJkUF-C916IOWR2y4wxotSO6nxFkOPRCp1NPB2J7aLBcZyi-VXj3QYTxf0PvPyN6-UO3o07abF3sQElrCe9_k1APszNTtHv_D1cGlOo2XPAvRBkirFsWB2L214SLg/s1600-h/sniperspy3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="remote password hacking software" border="0" height="230" rafayhackingarticles.blogspot.com="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0f4wFCQAjZoU_FVJkUF-C916IOWR2y4wxotSO6nxFkOPRCp1NPB2J7aLBcZyi-VXj3QYTxf0PvPyN6-UO3o07abF3sQElrCe9_k1APszNTtHv_D1cGlOo2XPAvRBkirFsWB2L214SLg/s400/sniperspy3.jpg" width="400" /></a></div> No physical access to your remote PC is needed to install the <b>spy software. </b>Once installed you can view the screen LIVE and browse the file system from anywhere anytime. You can also view chats, websites, keystrokes in any language and more, with screenshots. <br />
This software remotely installs to your computer through email. Unlike the other remote spy titles on the market, <b style="color: #3d85c6;">S</b><b style="color: #3d85c6;">niperSpy</b> is fully and completely compatible with any firewall including Windows XP, Windows Vista and add-on firewalls.<br />
The program then records user activities and sends the data to your online account. You login to your account SECURELY to view logs using your own password-protected login. You can access the LIVE control panel within your secure online account.<br />
<br />
<b>Why would I need SniperSpy?</b><br />
<b> </b><br />
Do you suspect that your child or employee is inappropriately using your unreachable computer? If yes, then this software is ideal for you. If you can't get to your computer and are worried about the Internet safety or habits of those using it, <b>then you NEED </b><b style="color: #3d85c6;">SniperSpy</b>.<br />
<br />
This high-tech spy software will allow you to see exactly what your teenager is doing in MySpace and elsewhere in real time. It will also allow you to monitor any employee who uses the company computer(s).PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-23120257174828005812010-11-26T12:41:00.000-08:002010-11-26T12:41:59.524-08:00Submit your Site to Top Search Engines<div face="Georgia,""><a href="http://1.bp.blogspot.com/_L3S3cG5x4ys/SRTyJ9n78tI/AAAAAAAAAWY/3BrJTkqYlrg/s1600-h/search-engine-submission-200x200.jpg" imageanchor="1" rel="nofollow" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" src="http://1.bp.blogspot.com/_L3S3cG5x4ys/SRTyJ9n78tI/AAAAAAAAAWY/3BrJTkqYlrg/s320/search-engine-submission-200x200.jpg" /></a>If your site or blog is new then Search Engines will take time to crawl and add your site to their database.</div><div style="font-family: Georgia,"Times New Roman",serif;"> Submitting your blog or site to search engines is THE most important way for visitors to find your site or blog.<br />
</div><div style="font-family: Georgia,"Times New Roman",serif;"> Everyone wants to see their site on top search results of search engines.<br />
</div><div style="font-family: Georgia,"Times New Roman",serif;"> If you also want top the search engine placement for your site then don’t wait for the search engines to automatically find you. <br />
</div><div style="font-family: Georgia,"Times New Roman",serif;"> Just manually submit your site to them.<br />
</div><span class="fullpost"> Submitting your site or blog to search engines should be one of the immediate steps to take just after creating your blog.<br />
Here are some submission links of top search engines from where you can manually submit your site.<br />
1. <a href="http://www.google.com/addurl/" rel="nofollow" style="color: #cc0000;" target="_blank">Google</a><br />
2. <a href="http://siteexplorer.search.yahoo.com/submit" rel="nofollow" target="_blank"><span style="color: #cc0000;"></span></a>Yahoo! Search</span> 3. <a href="http://search.msn.com/docs/submit.aspx" rel="nofollow" style="color: #cc0000;" target="_blank">Windows Live Search</a><br />
4. <a href="http://www.cuil.com/info/contact_us/feedback.php?to=crawl%20me" rel="nofollow" target="_blank"> <span style="color: #cc0000;">Cuil</span></a><br />
<i>(Remember: “Cuil” claims itself as the World’s biggest search engine)</i><br />
You can use also free service of “Submit Express” which submits your site to 20+ top search engines at once.<br />
<a href="http://www.submitexpress.com/submit.html" rel="nofollow" style="color: #cc0000;" target="_blank">Submit Express</a><br />
It should be understood that simply submitting your site to search engines doesn’t mean your site/blog will appear at the top of a search results screen immediately.<br />
It will take some time to Search Engine’s Crawler to pick up all the pages of your site which may depend upon the amount of traffic to your site.<br />
——————————————–<br />
If you have already submitted your site to Google, you can Check your site’s status in <a href="https://www.google.com/webmasters/tools/sitestatus?hl=en" style="color: blue;">Google index</a><span style="color: blue;">.</span>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-61702698133902172482010-11-10T10:28:00.000-08:002010-11-26T11:44:35.956-08:00How to Protect Your Computer from Keyloggers<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHYSWms9fPjzsXCKj8BApTk7yGXD73JrNcGPGVAY9BR84o-8mBR9omuxI0_2bksf0bO8PdUNHLhadle0O3CUTvRU0GIJz6kVeDqkF4JECyb2m8qsyEx7b47ggwB6yHMCo-RS-N8JuZNw/s1600/secure-keyloggers-hijackers-300x198.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHYSWms9fPjzsXCKj8BApTk7yGXD73JrNcGPGVAY9BR84o-8mBR9omuxI0_2bksf0bO8PdUNHLhadle0O3CUTvRU0GIJz6kVeDqkF4JECyb2m8qsyEx7b47ggwB6yHMCo-RS-N8JuZNw/s1600/secure-keyloggers-hijackers-300x198.jpg" /></a></div>Keyloggers have been a major problem today as it does not require any prior knowledge of computers to use it. So hackers mainly use keyloggers to steal your passwords, credit card numbers and other confidential data. Below are some methods through which you can protect your computer from keyloggers: <br />
<div></div><h3>Use a Good Antivirus</h3>This is the first and basic step that you need to take in order to protect your computer from keyloggers. Use a Good antivirus such as Kaspersky, Norton or Mcafee and update it regularly.<br />
<div></div><h3>Use a Good Antispyware</h3>Since keyloggers are basically spywares, if you are a frequent user of Internet then you could be exposed to thousands of keyloggers and spywares. So you should use a good antispyware such as <a href="http://www.gohacking.com/products/anti-spywares">NoAdware</a>.<br />
<div></div><h3>Antilogger can be Handy</h3>Antiloggers are programs that detect the presence of keyloggers on a given computer. Over past few years, I have tested a lot of anti-logging programs and have found <a href="http://www.zemana.com/" rel="nofollow" target="_blank">Zemana Antilogger</a> as the best antilogger.<br />
<b>Zemana </b><br />
Normally a keylogger can be easily detected by a Good Antivirus program, but hackers use some methods such as hexing, binding, crypting and similar techniques to make it harder to be detected by antivirus programs. In this case Zemana Antilogger comes handy as the program is specially developed to protect your system against harmful keyloggers.<br />
<div align="center"><img alt="http://i54.tinypic.com/30hvs0g.jpg" src="http://i54.tinypic.com/30hvs0g.jpg" /></div><div></div><h3>Online Scanning</h3>When ever you receive a suspicious file, you scan it with online scanners such as <b><a href="http://scanner2.novirusthanks.org/" rel="nofollow" target="_blank">Multi engine antivirus scanner</a></b> which scans your file with 24 antivirus engines and reports it back to you if the file is recognized as a virus or spyware. This ensures that none of the malicious programs can escape from being detected as there are 24 different antivirus engines are involved in the scanning process.<br />
<div></div><h3>Sandboxie</h3><a href="http://www.sandboxie.com/" rel="nofollow" target="_blank">Sandboxie</a> is another great program to help you protect your computer against harmful keyloggers and spywares. Sandboxie runs your computer in an isolated space which prevents your program from making permanent changes to other programs in your computer.<br />
When ever you receive a file that looks suspicious, just run the program with Sandboxie so even if it is a keylogger or any other virus it will not make permanent changes to your computer system.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://i56.tinypic.com/qnvjop.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="http://i56.tinypic.com/qnvjop.jpg" border="0" src="http://i56.tinypic.com/qnvjop.jpg" /></a></div>To run a program in Sandboxie follow the steps as mentioned below:<br />
<b>1. </b>Open sandboxie and click on <b>sandbox</b> menu on the top<br />
<b>2. </b>Now goto <b>Default sandbox</b><br />
<b>3.</b> Then click on <b>run any program</b><br />
<b>4. </b>Now select the file you wish to run in sandboxie and click open<br />
<div></div><h3>Keyscrambler</h3><a href="http://www.qfxsoftware.com/" rel="nofollow" target="_blank">Keyscrambler</a> is one of the best protection against keyloggers that you can have, Keyscrambler is a small program which encrypts your typed keystrokes so even if the victim has installed a keylogger on your system, he or she will get encrypted keys. Keyscrambler currently supports Firefox, Internet explorer and other applications, however its premium version supports more than 160 applications.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-71011040971677761212010-11-09T01:50:00.002-08:002010-11-09T01:50:54.093-08:00Add subscribe to updates or email subscription box to your blogger<strong><span style="font-family: Georgia,'Times New Roman',serif;">Email subscription option in your blog provides your blog readers or users regular email updates based on how you update your blog,people subscribed to your blog receives emails or newsletter containing your blog updates or post,best email subscription provider is Google feed burner which is free of cost and is mostly trusted by users,if you haven’t added this feature yet just follow some simple steps to add it:-</span></strong><br />
<a href="" name="more"></a><strong><span> </span></strong><br />
<strong> </strong><span><strong>1.Go to <a href="http://feedburner.google.com/" target="_blank">Google feedburner</a><span> and log in using your Google account and enter your blog url like <a href="http://myblogname.blogspot.com/">http://myblogname.blogspot.com/</a> or <a href="http://myblogname.com/">http://myblogname.com/</a> just below this line “Burn a feed right this instant:” and click on next,</span></strong></span> <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiIYGcSVHgsNrl3qvLX5WnBHKEhkVAZxigpraqOlT54HanNiiOIZ_0WA0be_bM6sL-ypMiA1AHejU4YnOc9FW3M9QU0p5NyU42ExxF4eXmPWyF4zq43z5oHU5Dkyy4cxP04ACBf9fEtw/s1600/8-17-2010+5-03-07+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="156" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiIYGcSVHgsNrl3qvLX5WnBHKEhkVAZxigpraqOlT54HanNiiOIZ_0WA0be_bM6sL-ypMiA1AHejU4YnOc9FW3M9QU0p5NyU42ExxF4eXmPWyF4zq43z5oHU5Dkyy4cxP04ACBf9fEtw/s400/8-17-2010+5-03-07+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong><span>select <a href="http://myblogname.blogspot.com/feeds/posts/default">http://myblogname.blogspot.com/feeds/posts/default</a> and click on next,</span></strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSgKXzmAe5-1g1BOaHX5VQsfT3cLSqd3QzXZO_GnNKlWzXYq6YFw3NccFmEfaAkM3Gxe3u8vomylsbCTBe9pSE5MLu0a4wIpIHFqgvY8RYlAVufkCo6ZwCdrrRx5022HqZVQjZGoxuvQ/s1600/8-17-2010+5-05-42+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="281" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSgKXzmAe5-1g1BOaHX5VQsfT3cLSqd3QzXZO_GnNKlWzXYq6YFw3NccFmEfaAkM3Gxe3u8vomylsbCTBe9pSE5MLu0a4wIpIHFqgvY8RYlAVufkCo6ZwCdrrRx5022HqZVQjZGoxuvQ/s400/8-17-2010+5-05-42+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>after this you will get to edit feed title or feed address,if you like edit it or just click on next,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivw2mwydLvik75UmRkMLgPfiarWS4Qr9vyBo5OX3nyPvMp2zY1vI02Nta3vEnsBKcqLqicncv0m6AfmDPWs7b_T-aFi84WP2Ljed6h0aFsb47JoBoQAnbw-4BCdO7oJQ5MG5lNhaYBlQ/s1600/8-17-2010+5-06-26+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivw2mwydLvik75UmRkMLgPfiarWS4Qr9vyBo5OX3nyPvMp2zY1vI02Nta3vEnsBKcqLqicncv0m6AfmDPWs7b_T-aFi84WP2Ljed6h0aFsb47JoBoQAnbw-4BCdO7oJQ5MG5lNhaYBlQ/s400/8-17-2010+5-06-26+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>after this click on skip directly to feed management,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2PZ9HTvupdaDC_jo_aKcxZHbuYv6-zxJ-F-m4sU3v0PLmAqmd3LxKM_XBFNdasrcSpyEMlByyxZUWI1ixItf54y72XzSB-3F-oT-jt4XxR08A9couIHs5hHbxqOyDn-MxtDYTfVH_Lw/s1600/8-17-2010+5-07-44+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="385" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2PZ9HTvupdaDC_jo_aKcxZHbuYv6-zxJ-F-m4sU3v0PLmAqmd3LxKM_XBFNdasrcSpyEMlByyxZUWI1ixItf54y72XzSB-3F-oT-jt4XxR08A9couIHs5hHbxqOyDn-MxtDYTfVH_Lw/s400/8-17-2010+5-07-44+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>,click on publicize from menu options,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDHCeFvB8R3LR3OyE9GQ9Kb8yLNwePEc9LPAbSzbMg_eBXkiJS8fznX5JjaR1sVpJIZmA5LUDFJ0OcCMc6toAHgl27XLoxJhwVLg1oy68ucwofjVnj51epjegIkPiaaBSNWLEY5RiJ2A/s1600/8-17-2010+5-08-23+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDHCeFvB8R3LR3OyE9GQ9Kb8yLNwePEc9LPAbSzbMg_eBXkiJS8fznX5JjaR1sVpJIZmA5LUDFJ0OcCMc6toAHgl27XLoxJhwVLg1oy68ucwofjVnj51epjegIkPiaaBSNWLEY5RiJ2A/s400/8-17-2010+5-08-23+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>,click on image subscription on the left sidebar,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhF8DmYO9khyphenhyphennwrLjC4w3HKL6ECIew35mkqnrLOXze5tARQeUffLcvyoy4HHLENncYyHaoiT0pMVM8Sr5dVO5W0EDuW6ppNGpFVBpU7VysJodDI00cVGUpPS7vcUiZgiAzlRGAHiQh3XQ/s1600/8-17-2010+5-08-44+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhF8DmYO9khyphenhyphennwrLjC4w3HKL6ECIew35mkqnrLOXze5tARQeUffLcvyoy4HHLENncYyHaoiT0pMVM8Sr5dVO5W0EDuW6ppNGpFVBpU7VysJodDI00cVGUpPS7vcUiZgiAzlRGAHiQh3XQ/s400/8-17-2010+5-08-44+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>,click on activate button to activate your email subscription management,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjfmjRfi5Mue2gLRKUMVTszO-b49JT7N554NA0nG6_8R5RlRwXpKz9teFCS3MMvJ3mc6enRYAZ4aryiPe0-lz3xX1tJ0gTgXYzpLrwTiSmi_i1NOFA6989-ofr3vQn10RYWbVJdGFiow/s1600/8-17-2010+5-09-32+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjfmjRfi5Mue2gLRKUMVTszO-b49JT7N554NA0nG6_8R5RlRwXpKz9teFCS3MMvJ3mc6enRYAZ4aryiPe0-lz3xX1tJ0gTgXYzpLrwTiSmi_i1NOFA6989-ofr3vQn10RYWbVJdGFiow/s400/8-17-2010+5-09-32+AM.png" width="400" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>,copy the code or select blogger and click on go to add widget,or do it manually by pasting code in html/javascript gadget,</strong></span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjne3QshWYPuJJtYubk-Lont_6Ca4FGmOJkanSq7OMMNLvhel8lZ-S-XjWRzcfNcC3DhExX5Qwp368eh9apDxbWH4ou5ESH2f-r59gFW1ULWBcyO1K7OeaTu3DJz_EmGaJCAdc6LIo3Gw/s1600/8-17-2010+5-10-53+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjne3QshWYPuJJtYubk-Lont_6Ca4FGmOJkanSq7OMMNLvhel8lZ-S-XjWRzcfNcC3DhExX5Qwp368eh9apDxbWH4ou5ESH2f-r59gFW1ULWBcyO1K7OeaTu3DJz_EmGaJCAdc6LIo3Gw/s320/8-17-2010+5-10-53+AM.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpSnjiAWZ603_hMoMEJ7OLgFrSVqO5SB6i03vXB1zOjxPMhqlGMtZ2mgpAs6LTV_ZNebXskSih66UrZ_zvlIS5mkwyWCKCYmVMs7YV6WJvqH6GjAEwpwbvLVvvVStb17jPErTs96tW2g/s1600/8-17-2010+5-11-14+AM.png" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpSnjiAWZ603_hMoMEJ7OLgFrSVqO5SB6i03vXB1zOjxPMhqlGMtZ2mgpAs6LTV_ZNebXskSih66UrZ_zvlIS5mkwyWCKCYmVMs7YV6WJvqH6GjAEwpwbvLVvvVStb17jPErTs96tW2g/s320/8-17-2010+5-11-14+AM.png" width="320" /></a></div><span style="font-family: Georgia,'Times New Roman',serif;"><strong>click on save and you are done.</strong></span>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-75196859626373510212010-11-09T01:50:00.000-08:002010-11-10T10:34:57.540-08:00How to Copy Movie from a Scratched CD<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="http://cybernetnews.com/wp-content/uploads/2007/07/scratched-20cd.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br />
</a></div><br />
<img alt="http://i54.tinypic.com/195kwj.jpg" src="http://i54.tinypic.com/195kwj.jpg" /><br />
<span style="color: black;">This is the most common problem, people encounter. They get a CD/DVD on rent and try to copy the movie. But alas, the CD is scratched, so after sometime, you get a cyclic redundency check error.</span> <br />
<div><span style="color: black;"><br />
Well, things are not as hopeless as it seems. Here are few methods: <span style="font-weight: bold;">1.</span><br />
Use Nero to create an image of the media. In most of the ways, this happens, so that you can later use Nero Image Drive to mount the CD and then view it.<br />
<span style="font-weight: bold;">2.</span><br />
Create a new Briefcase, by right clicking and choosing a new BriefCase, in the folder that you want to copy the file. Then synchronize the briefcase with the MPEG/AVI file of the video. At any instant of time, if you feel that the system hangs up, just close the synchronization. This method will copy the file, to the scratched extent. This method isparticularly useful, if the scratch is at the end of the movie.</span></div>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-85405821408255234982010-11-09T01:43:00.001-08:002010-11-09T01:43:41.538-08:00How to Sign Out of Gmail Account Remotely?Gmail is one of the widely use email service.There are lot of features in gmail. There is a security feature for gmail known as <strong>remote logout</strong>. Many of use more than one computers to login to gmail account. Some times we often leave the browser opened & not being logged out of gmail or we are in cyber cafe and any power cut or computer faliure occurs and if the computer is at office or any public place your account may be hacked or misused by someone else.<br />
But there is a method by which you can l;og out from your gmail account remotely.<br />
Open you gmail account and go to bottom of the page ,there you will see something as shown below..<br />
<div class="wp-caption aligncenter" id="attachment_655" style="width: 445px;"><img alt="gmail-remote-logout" class="size-full wp-image-655" height="89" src="http://www.hackingtrick.com/wp-content/uploads/2010/11/Gmail-logout.png" title="Gmail-logout" width="435" /><div class="wp-caption-text">gmail-remote-logout</div></div>Now you can click on “Details” which shows you a pop-up having details about your last sessions.Click on “Sign out all other sessions” to sign out of gmail at all other places exept the current.<br />
By this simple feature you can check that your gmail account is hacked or not.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-48780384506497198112010-11-09T01:34:00.001-08:002010-11-09T01:34:32.846-08:00Share Access Data with Excel in Office 2010Being able to share Access data with other applications is easier in Office 2010. Today we take a look at how easy it is to share data from an Access 2010 Database to to an Excel spreadsheet and more.<br />
<strong>Share Access Data</strong><br />
First we’ll take a look at sharing an Access table to an Excel spreadsheet. Open the Access table you want to export and click on the External Data tab. From here you can see a bunch of different options you have for exporting the data. In this example we’re using exporting to Excel so click on that.<br />
<img alt="2
exp" border="0" height="341" src="http://www.howtogeek.com/wp-content/uploads/2010/01/2exp.png" style="border: 0px none; display: inline;" title="2 exp" width="537" /> <br />
A window comes up asking where to save the file, the file format, and some other exporting options. <br />
<img alt="3
exp" border="0" height="478" src="http://www.howtogeek.com/wp-content/uploads/2010/01/3exp.png" style="border: 0px none; display: inline;" title="3 exp" width="640" /> <br />
In the next screen you might want to save the Export Steps to make it easier the next time or if you’re working with several documents and need to do the same thing. From here you can also set up an Outlook task if you regularly need to repeat it.<br />
<img alt="4
exp" border="0" height="478" src="http://www.howtogeek.com/wp-content/uploads/2010/01/4exp.png" style="border: 0px none; display: inline;" title="4 exp" width="640" /> <br />
The data goes into Excel and you can start working on it here, or send it where it needs to go.<br />
<img alt="5
exp" border="0" height="560" src="http://www.howtogeek.com/wp-content/uploads/2010/01/5exp.png" style="border: 0px none; display: inline;" title="5 exp" width="621" /> <br />
There are a lot of other applications Access 2010 will let you export data, like text files, Word, a SharePoint List and more. There is an easy Word Merge feature so if you have a database of addresses you can easily incorporate it with Mail Merge.<br />
<img alt="6
exp" border="0" height="440" src="http://www.howtogeek.com/wp-content/uploads/2010/01/6exp.png" style="border: 0px none; display: inline;" title="6 exp" width="563" /> <br />
Sometimes getting the data you need out of an Access Database can be a bit daunting. It looks like these tasks will be a lot easier in Office 2010, which will be great for increasing productivity.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-3238503070797259392010-11-09T01:32:00.000-08:002010-11-09T01:32:57.718-08:00Working with PivotTables in ExcelPivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them.<br />
Note: This article is written using Excel 2010 (Beta). The concept of a PivotTable has changed little over the years, but the method of creating one has changed in nearly every iteration of Excel. If you are using a version of Excel that is not 2010, expect different screens from the ones you see in this article.<br />
<strong>A Little History</strong><br />
In the early days of spreadsheet programs, Lotus 1-2-3 ruled the roost. Its dominance was so complete that people thought it was a waste of time for Microsoft to bother developing their own spreadsheet software (Excel) to compete with Lotus. Flash-forward to 2010, and Excel’s dominance of the spreadsheet market is greater than Lotus’s ever was, while the number of users still running Lotus 1-2-3 is approaching zero. How did this happen? What caused such a dramatic reversal of fortunes?<br />
Industry analysts put it down to two factors: Firstly, Lotus decided that this fancy new GUI platform called “Windows” was a passing fad that would never take off. They declined to create a Windows version of Lotus 1-2-3 (for a few years, anyway), predicting that their DOS version of the software was all anyone would ever need. Microsoft, naturally, developed Excel exclusively for Windows. Secondly, Microsoft developed a feature for Excel that Lotus didn’t provide in 1-2-3, namely <em>PivotTables</em>. The PivotTables feature, exclusive to Excel, was deemed so staggeringly useful that people were willing to learn an entire new software package (Excel) rather than stick with a program (1-2-3) that didn’t have it. This one feature, along with the misjudgment of the success of Windows, was the death-knell for Lotus 1-2-3, and the beginning of the success of Microsoft Excel.<br />
<strong>Understanding PivotTables</strong><br />
So what is a PivotTable, exactly?<br />
Put simply, a PivotTable is a summary of some data, created to allow easy analysis of said data. But unlike a manually created summary, Excel PivotTables are interactive. Once you have created one, you can easily change it if it doesn’t offer the exact insights into your data that you were hoping for. In a couple of clicks the summary can be “pivoted” – rotated in such a way that the column headings become row headings, and vice versa. There’s a lot more that can be done, too. Rather than try to describe all the features of PivotTables, we’ll simply demonstrate them…<br />
The data that you analyze using a PivotTable can’t be just <em>any</em> data – it has to be <em>raw</em> data, previously unprocessed (unsummarized) – typically a list of some sort. An example of this might be the list of sales transactions in a company for the past six months.<br />
Examine the data shown below:<br />
<img alt="Sample monthly sales data" border="0" height="227" src="http://www.howtogeek.com/wp-content/uploads/2010/03/monthlysales.png" style="border-width: 0px;" width="640" /><br />
Notice that this is <em>not</em> raw data. In fact, it is already a summary of some sort. In cell B3 we can see $30,000, which apparently is the total of James Cook’s sales for the month of January. So where is the raw data? How did we arrive at the figure of $30,000? Where is the original list of sales transactions that this figure was generated from? It’s clear that somewhere, someone must have gone to the trouble of collating all of the sales transactions for the past six months into the summary we see above. How long do you suppose this took? An hour? Ten? <br />
Most probably, yes. You see, the spreadsheet above is actually <i><u>not</u></i> a PivotTable. It was created manually from raw data stored elsewhere, and it did indeed take a couple of hours to compile. However, it’s exactly the sort of summary that <i>could</i> be created using PivotTables, in which case it would have taken just a few seconds. Let’s find out how… <br />
If we were to track down the original list of sales transactions, it might look something like this:<br />
<img alt="Raw data" border="0" height="281" src="http://www.howtogeek.com/wp-content/uploads/2010/03/rawdata.png" style="border-width: 0px;" width="640" /><br />
You may be surprised to learn that, using the PivotTable feature of Excel, we can create a monthly sales summary similar to the one above in a few seconds, with only a few mouse clicks. We can do this – and a lot more too!<br />
<strong>How to Create a PivotTable</strong><br />
First, ensure that you have some raw data in a worksheet in Excel. A list of financial transactions is typical, but it can be a list of just about anything: Employee contact details, your CD collection, or fuel consumption figures for your company’s fleet of cars.<br />
So we start Excel…<br />
<img alt="Excel 2010 starting" border="0" height="363" src="http://www.howtogeek.com/wp-content/uploads/2010/03/excelstart.png" style="border-width: 0px;" width="528" /><br />
…and we load such a list…<br />
<img alt="Raw data" border="0" height="281" src="http://www.howtogeek.com/wp-content/uploads/2010/03/rawdata.png" style="border-width: 0px;" width="640" /><br />
Once we have the list open in Excel, we’re ready to start creating the PivotTable.<br />
Click on any one single cell within the list:<br />
<img alt="Raw data - selected" border="0" height="310" src="http://www.howtogeek.com/wp-content/uploads/2010/03/startselect.png" style="border-width: 0px;" width="640" /><br />
Then, from the <strong>Insert</strong> tab, click the <strong>PivotTable</strong> icon:<br />
<img alt="Insert/PivotTable" border="0" height="167" src="http://www.howtogeek.com/wp-content/uploads/2010/03/insertpivottable.png" style="border-width: 0px;" width="328" /><br />
The <strong>Create PivotTable</strong> box appears, asking you two questions: What data should your new PivotTable be based on, and where should it be created? Because we already clicked on a cell within the list (in the step above), the entire list surrounding that cell is already selected for us (<strong>$A$1:$G$88</strong> on the <strong>Payments</strong> sheet, in this example). Note that we could select a list in any other region of any other worksheet, or even some external data source, such as an Access database table, or even a MS-SQL Server database table. We also need to select whether we want our new PivotTable to be created on a <em>new</em> worksheet, or on an <em>existing</em> one. In this example we will select a <em>new</em> one:<br />
<img alt="Create PivotTable dialog" border="0" height="317" src="http://www.howtogeek.com/wp-content/uploads/2010/03/createpivotbox.png" style="border-width: 0px;" width="427" /><br />
The new worksheet is created for us, and a blank PivotTable is created on that worksheet:<br />
<img alt="PivotTable Area" border="0" height="434" src="http://www.howtogeek.com/wp-content/uploads/2010/03/pivotarea.png" style="border-width: 0px;" width="286" /><br />
Another box also appears: The <strong>PivotTable Field List</strong>. This field list will be shown whenever we click on any cell within the PivotTable (above):<br />
<img alt="PivotTable fields" border="0" height="534" src="http://www.howtogeek.com/wp-content/uploads/2010/03/pivotfields.png" style="border-width: 0px;" width="279" /><br />
The list of fields in the top part of the box is actually the collection of column headings from the original raw data worksheet. The four blank boxes in the lower part of the screen allow us to choose the way we would like our PivotTable to summarize the raw data. So far, there is nothing in those boxes, so the PivotTable is blank. All we need to do is drag fields down from the list above and drop them in the lower boxes. A PivotTable is then automatically created to match our instructions. If we get it wrong, we only need to drag the fields back to where they came from and/or drag <em>new</em> fields down to replace them.<br />
The <strong>Values</strong> box is arguably the most important of the four. The field that is dragged into this box represents the data that needs to be summarized in some way (by summing, averaging, finding the maximum, minimum, etc). It is almost always <em>numerical</em> data. A perfect candidate for this box in our sample data is the “Amount” field/column. Let’s drag that field into the <strong>Values</strong> box:<br />
<img alt="amountonly" border="0" height="534" src="http://www.howtogeek.com/wp-content/uploads/2010/03/amountonly.png" style="border-width: 0px;" width="278" /><br />
Notice that (a) the “Amount” field in the list of fields is now ticked, and “Sum of Amount” has been added to the <strong>Values</strong> box, indicating that the amount column has been summed.<br />
If we examine the PivotTable itself, we indeed find the sum of all the “Amount” values from the raw data worksheet:<br />
<img alt="amountonlypivot" border="0" height="162" src="http://www.howtogeek.com/wp-content/uploads/2010/03/amountonlypivot.png" style="border-width: 0px;" width="206" /><br />
We’ve created our first PivotTable! Handy, but not particularly impressive. It’s likely that we need a little more insight into our data than that.<br />
Referring to our sample data, we need to identify one or more column headings that we could conceivably use to split this total. For example, we may decide that we would like to see a summary of our data where we have a <em>row heading</em> for each of the different salespersons in our company, and a total for each. To achieve this, all we need to do is to drag the “Salesperson” field into the <strong>Row Labels</strong> box:<br />
<img alt="salespersonrow" border="0" height="533" src="http://www.howtogeek.com/wp-content/uploads/2010/03/salespersonrow.png" style="border-width: 0px;" width="279" /><br />
<strong><em>Now</em></strong>, finally, things start to get interesting! Our PivotTable starts to take shape….<br />
<img alt="rows1" border="0" height="229" src="http://www.howtogeek.com/wp-content/uploads/2010/03/rows1.png" style="border-width: 0px;" width="301" /><br />
With a couple of clicks we have created a table that would have taken a long time to do manually.<br />
So what else can we do? Well, in one sense our PivotTable is complete. We’ve created a useful summary of our source data. The important stuff is already learned! For the rest of the article, we will examine some ways that more complex PivotTables can be created, and ways that those PivotTables can be customized.<br />
First, we can create a <em>two-</em>dimensional table. Let’s do that by using “Payment Method” as a column heading. Simply drag the “Payment Method” heading to the <strong>Column Labels</strong> box:<br />
<img alt="2dim1" border="0" height="535" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2dim1.png" style="border-width: 0px;" width="281" /><br />
Which looks like this:<br />
<img alt="2dim1data" border="0" height="245" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2dim1data.png" style="border-width: 0px;" width="551" /><br />
Starting to get <em>very</em> cool!<br />
Let’s make it a <em>three</em>-dimensional table. What could such a table possibly look like? Well, let’s see…<br />
Drag the “Package” column/heading to the <strong>Report Filter</strong> box:<br />
<img alt="3dim1" border="0" height="533" src="http://www.howtogeek.com/wp-content/uploads/2010/03/3dim1.png" style="border-width: 0px;" width="279" /><br />
Notice where it ends up….<br />
<img alt="3dim1data" border="0" height="249" src="http://www.howtogeek.com/wp-content/uploads/2010/03/3dim1data.png" style="border-width: 0px;" width="550" /><br />
This allows us to filter our report based on which “holiday package” was being purchased. For example, we can see the breakdown of salesperson vs payment method for <em>all</em> packages, or, with a couple of clicks, change it to show the same breakdown for the “Sunseekers” package:<br />
<img alt="3dim1datafiltered" border="0" height="249" src="http://www.howtogeek.com/wp-content/uploads/2010/03/3dim1datafiltered.png" style="border-width: 0px;" width="561" /><br />
And so, if you think about it the right way, our PivotTable is now three-dimensional. Let’s keep customizing…<br />
If it turns out, say, that we only want to see <em>cheque and credit card</em> transactions (i.e. no cash transactions), then we can deselect the “Cash” item from the column headings. Click the drop-down arrow next to <strong>Column Labels</strong>, and untick “Cash”:<br />
<img alt="nocash" border="0" height="501" src="http://www.howtogeek.com/wp-content/uploads/2010/03/nocash.png" style="border-width: 0px;" width="549" /><br />
Let’s see what that looks like…As you can see, “Cash” is gone.<br />
<img alt="nocashdata" border="0" height="250" src="http://www.howtogeek.com/wp-content/uploads/2010/03/nocashdata.png" style="border-width: 0px;" width="497" /><br />
<strong>Formatting</strong><br />
This is obviously a very powerful system, but so far the results look very plain and boring. For a start, the numbers that we’re summing do not look like dollar amounts – just plain old numbers. Let’s rectify that.<br />
A temptation might be to do what we’re used to doing in such circumstances and simply select the whole table (or the whole worksheet) and use the standard number formatting buttons on the toolbar to complete the formatting. The problem with that approach is that if you ever change the structure of the PivotTable in the future (which is 99% likely), then those number formats will be lost. We need a way that will make them (semi-)permanent.<br />
First, we locate the “Sum of Amount” entry in the <strong>Values</strong> box, and click on it. A menu appears. We select <strong>Value Field Settings…</strong> from the menu:<br />
<img alt="dollar1" border="0" height="519" src="http://www.howtogeek.com/wp-content/uploads/2010/03/dollar1.png" style="border-width: 0px;" width="352" /><br />
The <strong>Value Field Settings </strong>box appears.<br />
<img alt="dollar2" border="0" height="353" src="http://www.howtogeek.com/wp-content/uploads/2010/03/dollar2.png" style="border-width: 0px;" width="393" /><br />
Click the <strong>Number Format</strong> button, and the standard <strong>Format Cells box</strong> appears:<br />
<img alt="dollar3" border="0" height="499" src="http://www.howtogeek.com/wp-content/uploads/2010/03/dollar3.png" style="border-width: 0px;" width="552" /><br />
From the <strong>Category </strong>list, select (say) <strong>Accounting</strong>, and drop the number of decimal places to 0. Click <strong>OK </strong>a few times to get back to the PivotTable…<br />
<img alt="dollar4" border="0" height="248" src="http://www.howtogeek.com/wp-content/uploads/2010/03/dollar4.png" style="border-width: 0px;" width="574" /><br />
As you can see, the numbers have been correctly formatted as dollar amounts.<br />
While we’re on the subject of formatting, let’s format the entire PivotTable. There are a few ways to do this. Let’s use a simple one…<br />
Click the <strong>PivotTable Tools/Design</strong> tab:<br />
<img alt="PivotTableDesign" border="0" height="112" src="http://www.howtogeek.com/wp-content/uploads/2010/03/PivotTableDesign.png" style="border-width: 0px;" width="523" /><br />
Then drop down the arrow in the bottom-right of the <strong>PivotTable Styles </strong>list to see a vast collection of built-in styles:<br />
<img alt="styles" border="0" height="646" src="http://www.howtogeek.com/wp-content/uploads/2010/03/styles.png" style="border-width: 0px;" width="560" /><br />
Choose any one that appeals, and look at the result in your PivotTable:<br />
<img alt="formatted" border="0" height="247" src="http://www.howtogeek.com/wp-content/uploads/2010/03/formatted.png" style="border-width: 0px;" width="582" /><br />
<strong>Other Options</strong><br />
We can work with dates as well. Now usually, there are many, many dates in a transaction list such as the one we started with. But Excel provides the option to group data items together by day, week, month, year, etc. Let’s see how this is done.<br />
First, let’s remove the “Payment Method” column from the <strong>Column Labels </strong>box (simply drag it back up to the field list), and replace it with the “Date Booked” column:<br />
<img alt="date1" border="0" height="518" src="http://www.howtogeek.com/wp-content/uploads/2010/03/date1.png" style="border-width: 0px;" width="279" /><br />
As you can see, this makes our PivotTable instantly useless, giving us one column for each date that a transaction occurred on – a very wide table!<br />
<img alt="date2" border="0" height="118" src="http://www.howtogeek.com/wp-content/uploads/2010/03/date2.png" style="border-width: 0px;" width="640" /><br />
To fix this, right-click on any date and select <strong>Group…</strong> from the context-menu:<br />
<img alt="date3" border="0" height="455" src="http://www.howtogeek.com/wp-content/uploads/2010/03/date3.png" style="border-width: 0px;" width="346" /><br />
The grouping box appears. We select <strong>Months</strong> and click OK:<br />
<img alt="date4" border="0" height="341" src="http://www.howtogeek.com/wp-content/uploads/2010/03/date4.png" style="border-width: 0px;" width="277" /><br />
Voila! A <em>much </em>more useful table:<br />
<img alt="date5" border="0" height="210" src="http://www.howtogeek.com/wp-content/uploads/2010/03/date5.png" style="border-width: 0px;" width="640" /><br />
(Incidentally, this table is virtually identical to the one shown at the beginning of this article – the original sales summary that was created manually.)<br />
Another cool thing to be aware of is that you can have more than one set of row headings (or column headings):<br />
<img alt="2row" border="0" height="209" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2row.png" style="border-width: 0px;" width="272" /><br />
…which looks like this….<br />
<img alt="2rowdata" border="0" height="357" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2rowdata.png" style="border-width: 0px;" width="640" /><br />
You can do a similar thing with column headings (or even report filters).<br />
Keeping things simple again, let’s see how to plot <em>averaged </em>values, rather than summed values.<br />
First, click on “Sum of Amount”, and select <strong>Value Field Settings…</strong> from the context-menu that appears:<br />
<img alt="dollar1" border="0" height="519" src="http://www.howtogeek.com/wp-content/uploads/2010/03/dollar1.png" style="border-width: 0px;" width="352" /><br />
In the <strong>Summarize value field by</strong> list in the <strong>Value Field Settings</strong> box, select <strong>Average</strong>:<br />
<img alt="average1" border="0" height="353" src="http://www.howtogeek.com/wp-content/uploads/2010/03/average1.png" style="border-width: 0px;" width="393" /><br />
While we’re here, let’s change the <strong>Custom Name</strong>, from “Average of Amount” to something a little more concise. Type in something like “Avg”:<br />
<img alt="average2" border="0" height="353" src="http://www.howtogeek.com/wp-content/uploads/2010/03/average2.png" style="border-width: 0px;" width="393" /><br />
Click <strong>OK</strong>, and see what it looks like. Notice that all the values change from summed totals to averages, and the table title (top-left cell) has changed to “Avg”:<br />
<img alt="average3" border="0" height="246" src="http://www.howtogeek.com/wp-content/uploads/2010/03/average3.png" style="border-width: 0px;" width="748" /><br />
If we like, we can even have sums, averages and counts (counts = how many sales there were) all on the same PivotTable!<br />
Here are the steps to get something like that in place (starting from a blank PivotTable):<br />
<ol><li>Drag “Salesperson” into the <strong>Column Labels</strong> </li>
<li>Drag “Amount” field down into the <strong>Values</strong> box three times </li>
<li>For the first “Amount” field, change its custom name to “Total” and it’s number format to <strong>Accounting</strong> (0 decimal places) </li>
<li>For the second “Amount” field, change its custom name to “Average”, its function to <strong>Average</strong> and it’s number format to <strong>Accounting</strong> (0 decimal places) </li>
<li>For the third “Amount” field, change its name to “Count” and its function to <strong>Count</strong> </li>
<li>Drag the automatically created <img alt="sigmavalues" border="0" height="16" src="http://www.howtogeek.com/wp-content/uploads/2010/03/sigmavalues.png" style="border-width: 0px;" width="55" /> field from <strong>Column Labels</strong> to <strong>Row Labels</strong> </li>
</ol>Here’s what we end up with:<br />
<img alt="combo" border="0" height="195" src="http://www.howtogeek.com/wp-content/uploads/2010/03/combo.png" style="border-width: 0px;" width="585" /><br />
Total, average and count on the same PivotTable!<br />
<strong>Conclusion</strong><br />
There are many, many more features and options for PivotTables created by Microsoft Excel – far too many to list in an article like this. To fully cover the potential of PivotTables, a small book (or a large website) would be required. Brave and/or geeky readers can explore PivotTables further quite easily: Simply right-click on just about everything, and see what options become available to you. There are also the two ribbon-tabs: <strong>PivotTable Tools/Options</strong> and <strong>Design</strong>. It doesn’t matter if you make a mistake – it’s easy to delete the PivotTable and start again – a possibility old DOS users of Lotus 1-2-3 never had.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-43129801866191345392010-11-09T01:29:00.001-08:002010-11-09T01:30:30.394-08:00VLOOKUP in Excel, part 2: Using VLOOKUP without a databaseIn a recent article, we introduced the Excel function called <b>VLOOKUP</b> and explained how it could be used to retrieve information from a database into a cell in a local worksheet. In that article we mentioned that there were two uses for VLOOKUP, and only one of them dealt with querying databases. In this article, the second and final in the VLOOKUP series, we examine this other, lesser known use for the VLOOKUP function.<br />
If you haven’t already done so, please read <a href="http://thecomputertricks.blogspot.com/2010/11/using-vlookup-in-excel.html" target="_blank">the first VLOOKUP article</a> – this article will assume that many of the concepts explained in that article are already known to the reader.<br />
When working with databases, VLOOKUP is passed a “unique identifier” that serves to identify which data record we wish to find in the database (e.g. a product code or customer ID). This unique identifier <i>must</i> exist in the database, otherwise VLOOKUP returns us an error. In this article, we will examine a way of using VLOOKUP where the identifier doesn’t need to exist in the database at all. It’s almost as if VLOOKUP can adopt a “near enough is good enough” approach to returning the data we’re looking for. In certain circumstances, this is <i>exactly</i> what we need.<br />
We will illustrate this article with a real-world example – that of calculating the commissions that are generated on a set of sales figures. We will start with a very simple scenario, and then progressively make it more complex, until the only rational solution to the problem is to use VLOOKUP. The initial scenario in our fictitious company works like this: If a salesperson creates more than $30,000 worth of sales in a given year, the commission they earn on those sales is 30%. Otherwise their commission is only 20%. So far this is a pretty simple worksheet:<br />
<img alt="original" border="0" height="233" src="http://www.howtogeek.com/wp-content/uploads/2010/04/original.png" style="border-width: 0px;" width="434" /><br />
To use this worksheet, the salesperson enters their sales figures in cell B1, and the formula in cell B2 calculates the correct commission rate they are entitled to receive, which is used in cell B3 to calculate the total commission that the salesperson is owed (which is a simple multiplication of B1 and B2).<br />
The cell B2 contains the only interesting part of this worksheet – the formula for deciding which commission rate to use: the one <i>below</i> the threshold of $30,000, or the one <i>above</i> the threshold. This formula makes use of the Excel function called <b>IF</b>. For those readers that are not familiar with IF, it works like this:<br />
<blockquote>IF(<i>condition,value if true,value if false</i>)</blockquote>Where the <i>condition</i> is an expression that evaluates to either <b>true</b> or <b>false</b>. In the example above, the <i>condition</i> is the expression <b>B1<B5</b>, which can be read as “Is B1 less than B5?”, or, put another way, “Are the total sales less than the threshold”. If the answer to this question is “yes” (true), then we use the <i>value if true</i> parameter of the function, namely <b>B6</b> in this case – the commission rate if the sales total was <i>below </i>the threshold. If the answer to the question is “no” (false), then we use the <i>value if false</i> parameter of the function, namely <b>B7</b> in this case – the commission rate if the sales total was <i>above</i> the threshold.<br />
As you can see, using a sales total of $20,000 gives us a commission rate of 20% in cell B2. If we enter a value of $40,000, we get a different commission rate:<br />
<img alt="original40k" border="0" height="234" src="http://www.howtogeek.com/wp-content/uploads/2010/04/original40k.png" style="border-width: 0px;" width="430" /><br />
So our spreadsheet is working.<br />
Let’s make it more complex. Let’s introduce a second threshold: If the salesperson earns more than $40,000, then their commission rate increases to 40%:<br />
<img alt="2thresholds" border="0" height="282" src="http://www.howtogeek.com/wp-content/uploads/2010/04/2thresholds.png" style="border-width: 0px;" width="492" /><br />
Easy enough to understand in the real world, but in cell B2 our formula is getting more complex. If you look closely at the formula, you’ll see that the third parameter of the original IF function (the <i>value if false</i>) is now an entire IF function in its own right. This is called a <i>nested function</i> (a function within a function). It’s perfectly valid in Excel (it even works!), but it’s harder to read and understand.<br />
We’re not going to go into the nuts and bolts of how and why this works, nor will we examine the nuances of nested functions. This is a tutorial on VLOOKUP, not on Excel in general.<br />
Anyway, it gets worse! What about when we decide that if they earn more than $50,000 then they’re entitled to 50% commission, and if they earn more than $60,000 then they’re entitled to 60% commission?<br />
<img alt="4thresholds" border="0" height="329" src="http://www.howtogeek.com/wp-content/uploads/2010/04/4thresholds.png" style="border-width: 0px;" width="640" /><br />
Now the formula in cell B2, while correct, has become virtually unreadable. No-one should have to write formulae where the functions are nested four levels deep! Surely there must be a simpler way?<br />
There certainly is. VLOOKUP to the rescue!<br />
Let’s redesign the worksheet a bit. We’ll keep all the same figures, but organize it in a new way, a more <i>tabular</i> way:<br />
<img alt="tableblank" border="0" height="331" src="http://www.howtogeek.com/wp-content/uploads/2010/04/tableblank.png" style="border-width: 0px;" width="382" /><br />
Take a moment and verify for yourself that the new <b>Rate Table</b> works exactly the same as the series of thresholds above.<br />
Conceptually, what we’re about to do is use VLOOKUP to look up the salesperson’s sales total (from B1) in the rate table and return to us the corresponding commission rate. Note that the salesperson may have indeed created sales that are <i>not</i> one of the five values in the rate table ($0, $30,000, $40,000, $50,000 or $60,000). They may have created sales of $34,988. It’s important to note that $34,988 does <i>not</i> appear in the rate table. Let’s see if VLOOKUP can solve our problem anyway…<br />
We select cell B2 (the location we want to put our formula), and then insert the VLOOKUP function from the <b>Formulas</b> tab:<br />
<img alt="findfunc" border="0" height="608" src="http://www.howtogeek.com/wp-content/uploads/2010/04/findfunc.png" style="border-width: 0px;" width="552" /><br />
The <b>Function Arguments </b>box for VLOOKUP appears. We fill in the arguments (parameters) one by one, starting with the <b>Lookup_value</b>, which is, in this case, the sales total from cell B1. We place the cursor in the <b>Lookup_value</b> field and then click once on cell B1:<br />
<img alt="args1" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/04/args1.png" style="border-width: 0px;" width="605" /><br />
Next we need to specify to VLOOKUP what table to lookup this data in. In this example, it’s the rate table, of course. We place the cursor in the <b>Table_array</b> field, and then highlight the entire rate table – <i>excluding the headings</i>:<br />
<img alt="args2" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/04/args2.png" style="border-width: 0px;" width="605" /><br />
Next we must specify which column in the table contains the information we want our formula to return to us. In this case we want the commission rate, which is found in the second column in the table, so we therefore enter a <b>2</b> into the <b>Col_index_num</b> field:<br />
<img alt="args3" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/04/args3.png" style="border-width: 0px;" width="605" /><br />
Finally we enter a value in the <b>Range_lookup</b> field.<br />
<i>Important: It is the use of this field that differentiates the two ways of using VLOOKUP. To use VLOOKUP with a database, this final parameter, <b>Range_lookup</b>, must always be set to <b>FALSE</b>, but with this other use of VLOOKUP, we must either leave it blank or enter a value of <b>TRUE</b>. When using VLOOKUP, it is vital that you make the correct choice for this final parameter.</i><br />
To be explicit, we will enter a value of <b>true</b> in the <b>Range_lookup</b> field. It would also be fine to leave it blank, as this is the default value:<br />
<img alt="args4" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/04/args4.png" style="border-width: 0px;" width="605" /><br />
We have completed all the parameters. We now click the <b>OK</b> button, and Excel builds our VLOOKUP formula for us:<br />
<img alt="vlookupdone" border="0" height="311" src="http://www.howtogeek.com/wp-content/uploads/2010/04/vlookupdone.png" style="border-width: 0px;" width="492" /><br />
If we experiment with a few different sales total amounts, we can satisfy ourselves that the formula is working.<br />
<b>Conclusion</b><br />
In the “database” version of VLOOKUP, where the <b>Range_lookup</b> parameter is <b>FALSE</b>, the value passed in the first parameter (<b>Lookup_value</b>) <i>must</i> be present in the database. In other words, we’re looking for an exact match.<br />
But in this other use of VLOOKUP, we are not necessarily looking for an exact match. In this case, “near enough is good enough”. But what do we mean by “near enough”? Let’s use an example: When searching for a commission rate on a sales total of $34,988, our VLOOKUP formula will return us a value of 30%, which is the correct answer. Why did it choose the row in the table containing 30% ? What, in fact, does “near enough” mean in this case? Let’s be precise:<br />
<blockquote>When <b>Range_lookup</b> is set to <b>TRUE</b> (or omitted), VLOOKUP will look in column 1 and match <i><u>the highest value that is not greater than</u></i> the <b>Lookup_value</b> parameter.</blockquote>It’s also important to note that for this system to work, <i>the table must be sorted in ascending order on column 1</i>!PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-91070241403763338632010-11-09T01:27:00.001-08:002010-11-09T01:27:56.024-08:00Using VLOOKUP in ExcelVLOOKUP is one of Excel’s most useful functions, and it’s also one of the least understood. In this article, we demystify VLOOKUP by way of a real-life example. We’ll create a usable <em>Invoice Template</em> for a fictitious company.<br />
So what is VLOOKUP? Well, of course it’s an Excel <em>function</em>. This article will assume that the reader already has a passing understanding of Excel functions, and can use basic functions such as SUM, AVERAGE, and TODAY. In its most common usage, VLOOKUP is a <em>database </em>function, meaning that it works with database tables – or more simply, <em>lists</em> of things in an Excel worksheet. What sort of things? Well, <em>any</em> sort of thing. You may have a worksheet that contains a list of employees, or products, or customers, or CDs in your CD collection, or stars in the night sky. It doesn’t really matter.<br />
Here’s an example of a list, or database. In this case it’s a list of products that our fictitious company sells:<br />
<img alt="database" border="0" height="210" src="http://www.howtogeek.com/wp-content/uploads/2010/03/database.png" style="border-width: 0px;" width="503" /><br />
Usually lists like this have some sort of unique identifier for each item in the list. In this case, the unique identifier is in the “Item Code” column. Note: For the VLOOKUP function to work with a database/list, that list <u>must</u> have a column containing the unique identifier (or “key”, or “ID”), and <em>that column must be the first column in the table</em>. Our sample database above satisfies this criterion.<br />
The hardest part of using VLOOKUP is understanding exactly what it’s for. So let’s see if we can get that clear first:<br />
<blockquote><strong>VLOOKUP retrieves information from a database/list based on a supplied instance of the unique identifier.</strong><br />
</blockquote>Put another way, if you put the VLOOKUP function into a cell and pass it one of the unique identifiers from your database, it will return you one of the pieces of information associated with that unique identifier. In the example above, you would pass VLOOKUP an item code, and it would return to you either the corresponding item’s description, its price, or its availability (its “In stock” quantity). Which of these pieces of information will it pass you back? Well, you get to decide this when you’re creating the formula.<br />
If all you need is one piece of information from the database, it would be a lot of trouble to go to to construct a formula with a VLOOKUP function in it. Typically you would use this sort of functionality in a reusable spreadsheet, such as a template. Each time someone enters a valid item code, the system would retrieve all the necessary information about the corresponding item.<br />
Let’s create an example of this: An <em>Invoice Template</em> that we can reuse over and over in our fictitious company.<br />
First we start Excel…<br />
<img alt="excelstart" border="0" height="363" src="http://www.howtogeek.com/wp-content/uploads/2010/03/excelstart1.png" style="border-width: 0px;" width="528" /><br />
…and we create ourselves a blank invoice:<br />
<img alt="invoice" border="0" height="470" src="http://www.howtogeek.com/wp-content/uploads/2010/03/invoice.png" style="border-width: 0px;" width="640" /><br />
This is how it’s going to work: The person using the invoice template will fill in a series of item codes in column “A”, and the system will retrieve each item’s description and price, which will be used to calculate the line total for each item (assuming we enter a valid quantity).<br />
For the purposes of keeping this example simple, we will locate the product database on a separate sheet in the same workbook:<br />
<img alt="selectsheet" border="0" height="115" src="http://www.howtogeek.com/wp-content/uploads/2010/03/selectsheet.png" style="border-width: 0px;" width="306" /><br />
In reality, it’s more likely that the product database would be located in a separate workbook. It makes little difference to the VLOOKUP function, which doesn’t really care if the database is located on the same sheet, a different sheet, or a completely different workbook.<br />
<img alt="database" border="0" height="210" src="http://www.howtogeek.com/wp-content/uploads/2010/03/database1.png" style="border-width: 0px;" width="503" /><br />
In order to test the VLOOKUP formula we’re about to write, we first enter a valid item code into cell A11:<br />
<img alt="itemcode" border="0" height="130" src="http://www.howtogeek.com/wp-content/uploads/2010/03/itemcode.png" style="border-width: 0px;" width="272" /><br />
Next, we move the active cell to the cell in which we want information retrieved from the database by VLOOKUP to be stored. Interestingly, this is the step that most people get wrong. To explain further: We are about to create a VLOOKUP formula that will retrieve the description that corresponds to the item code in cell A11. Where do we want this description put when we get it? In cell B11, of course. So that’s where we write the VLOOKUP formula – in cell B11.<br />
Select cell B11:<br />
<img alt="selectdescription" border="0" height="144" src="http://www.howtogeek.com/wp-content/uploads/2010/03/selectdescription.png" style="border-width: 0px;" width="496" /><br />
We need to locate the list of all available functions that Excel has to offer, so that we can choose VLOOKUP and get some assistance in completing the formula. This is found by first clicking the <strong>Formulas</strong> tab, and then clicking <strong>Insert Function</strong>:<br />
<img alt="formulas" border="0" height="183" src="http://www.howtogeek.com/wp-content/uploads/2010/03/formulas.png" style="border-width: 0px;" width="596" /><br />
<br />
<img alt="insertfunctionbox" border="0" height="403" src="http://www.howtogeek.com/wp-content/uploads/2010/03/insertfunctionbox.png" style="border-width: 0px;" width="461" /><br />
A box appears that allows us to select any of the functions available in Excel. To find the one we’re looking for, we could type a search term like “lookup” (because the function we’re interested in is a <em>lookup </em>function). The system would return us a list of all lookup-related functions in Excel. <strong>VLOOKUP</strong> is the second one in the list. Select it an click <strong>OK</strong>…<br />
<img alt="findlookup" border="0" height="403" src="http://www.howtogeek.com/wp-content/uploads/2010/03/findlookup.png" style="border-width: 0px;" width="461" /><br />
The <strong>Function Arguments</strong> box appears, prompting us for all the <em>arguments</em> (or <em>parameters</em>) needed in order to complete the VLOOKUP function. You can think of this box as the function is asking us the following questions:<br />
<ol><li><em>What unique identifier are you looking up in the database?</em> </li>
<li><em>Where is the database?</em> </li>
<li><em>Which piece of information from the database, associated with the unique identifier, do you wish to have retrieved for you?</em> </li>
</ol>The first three arguments are shown <strong>in bold</strong>, indicating that they are <em>mandatory</em> arguments (the VLOOKUP function is incomplete without them and will not return a valid value). The fourth argument is not bold, meaning that it’s optional:<br />
<img alt="funcarguments" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/03/funcarguments.png" style="border-width: 0px;" width="605" /><br />
We will complete the arguments in order, top to bottom.<br />
The first argument we need to complete is the <strong>Lookup_value</strong> argument. The function needs us to tell it where to find the unique identifier (the <em>item code</em> in this case) that it should be retuning the description of. We must select the item code we entered earlier (in A11).<br />
Click on the selector icon to the right of the first argument:<br />
<img alt="funcarguments1" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/03/funcarguments1.png" style="border-width: 0px;" width="605" /><br />
Then click once on the cell containing the item code (A11), and press <strong>Enter</strong>:<br />
<img alt="selectarg1" border="0" height="187" src="http://www.howtogeek.com/wp-content/uploads/2010/03/selectarg1.png" style="border-width: 0px;" width="640" /><br />
The value of “A11” is inserted into the first argument.<br />
Now we need to enter a value for the <strong>Table_array</strong> argument. In other words, we need to tell VLOOKUP where to find the database/list. Click on the selector icon next to the second argument:<br />
<img alt="funcarguments2" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/03/funcarguments2.png" style="border-width: 0px;" width="605" /><br />
Now locate the database/list and select the entire list – <u>not including the header line</u>. The database is located on a separate worksheet, so we first click on that worksheet tab:<br />
<img alt="selectsheet" border="0" height="115" src="http://www.howtogeek.com/wp-content/uploads/2010/03/selectsheet1.png" style="border-width: 0px;" width="306" /><br />
Next we select the entire database, not including the header line:<br />
<img alt="selectarg2" border="0" height="284" src="http://www.howtogeek.com/wp-content/uploads/2010/03/selectarg2.png" style="border-width: 0px;" width="640" /><br />
…and press <strong>Enter</strong>. The range of cells that represents the database (in this case “’Product Database’!A2:D7”) is entered automatically for us into the second argument.<br />
Now we need to enter the third argument, <strong>Col_index_num</strong>. We use this argument to specify to VLOOKUP which piece of information from the database, associate with our item code in A11, we wish to have returned to us. In this particular example, we wish to have the item’s <em>description</em> returned to us. If you look on the database worksheet, you’ll notice that the “Description” column is the <em>second</em> column in the database. This means that we must enter a value of “2” into the <strong>Col_index_num</strong> box:<br />
<img alt="arg3" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/03/arg3.png" style="border-width: 0px;" width="605" /><br />
It is important to note that that we are not entering a “2” here because the “Description” column is in the <strong>B</strong> column on that worksheet. If the database happened to start in column <strong>K</strong> of the worksheet, we would still enter a “2” in this field.<br />
Finally, we need to decide whether to enter a value into the final VLOOKUP argument, <strong>Range_lookup</strong>. This argument requires either a <strong>true</strong> or <strong>false</strong> value, or it should be left blank. When using VLOOKUP with databases (as is true 90% of the time), then the way to decide what to put in this argument can be thought of as follows:<br />
<blockquote>If the first column of the database (the column that contains the unique identifiers) is sorted alphabetically/numerically in ascending order, then it’s possible to enter a value of <strong>true</strong> into this argument, or leave it blank.<br />
If the first column of the database is <em>not</em> sorted, or it’s sorted in descending order, then you <em>must </em>enter a value of <strong>false</strong> into this argument<br />
</blockquote>As the first column of our database is <em>not</em> sorted, we enter <strong>false</strong> into this argument:<br />
<img alt="arg4" border="0" height="362" src="http://www.howtogeek.com/wp-content/uploads/2010/03/arg4.png" style="border-width: 0px;" width="605" /><br />
That’s it! We’ve entered all the information required for VLOOKUP to return the value we need. Click the <strong>OK</strong> button and notice that the description corresponding to item code “R99245” has been correctly entered into cell B11:<br />
<img alt="descfilledin" border="0" height="149" src="http://www.howtogeek.com/wp-content/uploads/2010/03/descfilledin.png" style="border-width: 0px;" width="509" /><br />
The formula that was created for us looks like this:<br />
<img alt="formula" border="0" height="138" src="http://www.howtogeek.com/wp-content/uploads/2010/03/formula.png" style="border-width: 0px;" width="442" /><br />
If we enter a <em>different</em> item code into cell A11, we will begin to see the power of the VLOOKUP function: The description cell changes to match the new item code:<br />
<img alt="changecode" border="0" height="112" src="http://www.howtogeek.com/wp-content/uploads/2010/03/changecode.png" style="border-width: 0px;" width="311" /><br />
We can perform a similar set of steps to get the item’s <em>price</em> returned into cell E11. Note that the new formula must be created in cell E11. The result will look like this:<br />
<img alt="2ndformula" border="0" height="112" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2ndformula.png" style="border-width: 0px;" width="607" /><br />
…and the formula will look like this:<br />
<img alt="2ndformula" border="0" height="121" src="http://www.howtogeek.com/wp-content/uploads/2010/03/2ndformula1.png" style="border-width: 0px;" width="454" /><br />
Note that the only difference between the two formulae is the third argument (<strong>Col_index_num</strong>) has changed from a “2” to a “3” (because we want data retrieved from the 3rd column in the database).<br />
If we decided to buy 2 of these items, we would enter a “2” into cell D11. We would then enter a simple formula into cell F11 to get the line total:<br />
<blockquote>=D11*E11<br />
</blockquote>…which looks like this…<br />
<img alt="linecomplete" border="0" height="106" src="http://www.howtogeek.com/wp-content/uploads/2010/03/linecomplete.png" style="border-width: 0px;" width="640" /><br />
<h2>Completing the Invoice Template</h2>We’ve learned a lot about VLOOKUP so far. In fact, we’ve learned all we’re going to learn in this article. It’s important to note that VLOOKUP can be used in other circumstances besides databases. This is less common, and may be covered in future How-To Geek articles.<br />
Our invoice template is not yet complete. In order to complete it, we would do the following:<br />
<ol><li>We would remove the sample item code from cell A11 and the “2” from cell D11. This will cause our newly created VLOOKUP formulae to display error messages:<br />
<img alt="errors" border="0" height="105" src="http://www.howtogeek.com/wp-content/uploads/2010/03/errors.png" style="border-width: 0px;" width="600" /><br />
We can remedy this by judicious use of Excel’s<strong> IF()</strong> and <strong>ISBLANK()</strong> functions. We change our formula from this… <strong>=VLOOKUP(A11,’Product Database’!A2:D7,2,FALSE)</strong><br />
<strong></strong>…to this…<br />
<strong>=IF(ISBLANK(A11),”",VLOOKUP(A11,’Product Database’!A2:D7,2,FALSE))</strong><br />
</li>
<li>We would copy the formulas in cells B11, E11 and F11 down to the remainder of the item rows of the invoice. Note that if we do this, the resulting formulas will no longer correctly refer to the database table. We could fix this by changing the cell references for the database to <em>absolute </em>cell references. Alternatively – and even better – we could create a <em>range name</em> for the entire product database (such as “Products”), and use this range name instead of the cell references. The formula would change from this… <strong>=IF(ISBLANK(A11),”",VLOOKUP(A11,’Product Database’!A2:D7,2,FALSE))</strong><br />
<strong></strong>…to this…<br />
<strong> =IF(ISBLANK(A11),”",VLOOKUP(A11,Products,2,FALSE))</strong><br />
<strong></strong>…and <em>then</em> copy the formulas down to the rest of the invoice item rows.<br />
</li>
<li>We would probably “lock” the cells that contain our formulae (or rather <em>unlock</em> the <em>other</em> cells), and then protect the worksheet, in order to ensure that our carefully constructed formulae are not accidentally overwritten when someone comes to fill in the invoice. </li>
<li>We would save the file as a <em>template</em>, so that it could be reused by everyone in our company </li>
</ol>If we were feeling <em>really</em> clever, we would create a database of all our customers in another worksheet, and then use the customer ID entered in cell F5 to automatically fill in the customer’s name and address in cells B6, B7 and B8.<br />
<img alt="customers" border="0" height="234" src="http://www.howtogeek.com/wp-content/uploads/2010/03/customers.png" style="border-width: 0px;" width="640" />PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-47455242017405662872010-11-09T01:25:00.000-08:002010-11-09T01:25:15.966-08:00Export an Access 2003 Report Into Excel SpreadsheetIn the corporate environment, Excel is king. So when you have an Access database report that you would really prefer to analyze in Excel spreadsheet form, there’s an easy way to convert it.<br />
To convert it, start by opening up your Access Report in Print Preview mode.<br />
<img height="598" src="http://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/ExportanAccess2003ReportIntoExcelSpreads_138BA/access%20to%20excel_1.png" width="646" /> <br />
Make sure you have the Print Preview Toolbar showing. You just need to right click an empty area on your toolbar and select “Customize” and check the toolbar.<br />
<img height="366" src="http://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/ExportanAccess2003ReportIntoExcelSpreads_138BA/access%20to%20excel_2.png" width="385" /><br />
From the Print Preview Taskbar click the drop down menu and select “Analyze It with Microsoft Office Excel”.<br />
<img height="198" src="http://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/ExportanAccess2003ReportIntoExcelSpreads_138BA/access%20to%20excel_4.png" width="288" /> <br />
Your Report will now be in Excel for you to change and analyze the data.<br />
<img height="686" src="http://www.howtogeek.com/wp-content/uploads/2007/05/WindowsLiveWriter/ExportanAccess2003ReportIntoExcelSpreads_138BA/access%20to%20excel_5.png" width="657" /><br />
<script src="http://www.howtogeek.com/wp-content/plugins/top-10/top-10-addcount.js.php?top_ten_id=478" type="text/javascript">
</script> <!-- google_ad_section_end --> <span class="date"></span>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-82843498682140253392010-11-09T01:23:00.001-08:002010-11-09T01:23:40.927-08:00Download and Keep Track of Stocks in Excel 2007Microsoft Excel is used by companies and individuals to keep track of and compute virtually anything that requires numbers. If you are computing financial symbols, did you know there’s a way to have Excel automatically update those values online?<br />
You can use smart tags in Excel to keep track of your stock quotes. (Keep in mind you do need an Internet connection for this). With this feature Excel will connect to MSN Money Central to download the information.<br />
First we need to enable the smart cell feature by clicking the Office Button \ Excel Options \ Proofing \ AutoCorrect Options and click on the Smart Tags tab. Make sure and place a check next to Financial Symbol. Click OK twice to get back to your worksheet.<br />
<img alt="1" border="0" height="407" src="http://www.howtogeek.com/wp-content/uploads/2007/12/1.png" width="412" /> <br />
Now that smart tags are enabled all we need to do is enter in our favorite stock symbol using all capital letters <em>(in this instance I am using Microsoft). </em>Now hover the mouse over the lower left corner of the cell until the smart tag appears and click. Select Insert refreshable stock price.<br />
<img alt="1" border="0" height="487" src="http://www.howtogeek.com/wp-content/uploads/2007/12/11.png" width="584" /> <br />
Now select where you would like the starting cell or you can also choose a new work sheet. Click OK.<br />
<img alt="1" border="0" height="186" src="http://www.howtogeek.com/wp-content/uploads/2007/12/12.png" width="285" /><br />
Excel will go retrieve the information regarding the stock from MSN Money Central. This will also include hyperlinks to additional information which will open in a separate browser.<br />
<img alt="1" border="0" height="523" src="http://www.howtogeek.com/wp-content/uploads/2007/12/13.png" width="600" /><br />
Is this a feature you’d actually use?PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-65213619011020846312010-11-09T01:21:00.001-08:002010-11-09T01:21:26.595-08:00Add Windows Calculator to the Excel 2007 Quick Launch Toolbar<h2><a href="http://www.howtogeek.com/howto/microsoft-office/add-windows-calculator-to-the-excel-2007-quick-launch-toolbar/" rel="bookmark" title="Permanent Link: Add Windows Calculator to the
Excel 2007 Quick Launch Toolbar">Add Windows Calculator to the Excel 2007 Quick Launch Toolbar</a> </h2><div> <div style="float: left; height: 30px; width: 450px;"><iframe allowtransparency="true" frameborder="0" scrolling="no" src="http://www.facebook.com/plugins/like.php?href=http://www.howtogeek.com/howto/microsoft-office/add-windows-calculator-to-the-excel-2007-quick-launch-toolbar/&layout=standard&show_faces=false&width=450&action=like&colorscheme=light&height=30" style="border: medium none; height: 30px; overflow: hidden; width: 450px;"></iframe></div></div><!-- google_ad_section_start --> If you like to use Windows Calculator to perform quick calculations while in Excel, you can save time by adding it to your Quick Access Toolbar.<br />
Click Customize Quick Access Toolbar and then choose “More Commands”.<br />
<img alt="11" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/07/11_thumb.png" /> <br />
On the left hand side choose “Commands Not in the Ribbon” from the drop down menu, and you’ll see Calculator in the list on the left pane. Just click the Add button to add it to the toolbar.<br />
<img alt="12" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/07/12_thumb.png" /> <br />
You now have the Calculator icon ready to use in the toolbar.<br />
<img alt="4" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/07/4_thumb4.png" /> <br />
Some of the newer Microsoft keyboards also have a button that launches the calculator for even quicker access.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-88181150072123869802010-11-09T01:18:00.000-08:002010-11-09T01:19:57.359-08:00Add Background Pictures To Excel 2007 WorksheetsChart, numbers, worksheets … at a business presentation it can get rather monotonous looking at the same data sheets. Here is a way to add background graphics to your Excel spreadsheets to spice up those meetings.<br />
First, open the spreadsheet you want to add the background to.<br />
<img alt="4" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/06/4_thumb12.png" /> <br />
On the Ribbon click on Page Layout and select background.<br />
<img alt="5" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/06/5_thumb12.png" /> <br />
This pops up the Sheet Background screen where you can select the background image you want to use. Once you have chosen your background click the Insert button.<br />
<img alt="6" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/06/6_thumb9.png" /> <br />
Now you have a background to your spreadsheet. You may have to adjust some of the fonts and colors depending upon the background image.<br />
<img alt="4" border="0" src="http://www.howtogeek.com/wp-content/uploads/2007/06/4_thumb13.png" width="640px" /><br />
Editor’s note: Might want to choose either a really dark or really light colored imagePRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-1047678601139278982010-11-09T01:15:00.000-08:002010-11-09T01:15:45.931-08:00Activate Flip 3D With Your Mouse in VistaOver the last few years I’ve had many people ask me if they can somehow activate Flip 3D by moving the mouse to a corner of the screen, and I’ve always told them to use the <a href="http://www.howtogeek.com/howto/windows-vista/great-expose-clone-for-windows-vista/">much more powerful Switcher replacement</a> instead, but that’s about to change.<br />
The solution to this problem comes in the form of a tiny little application called Vista Flip 3D Activator, and it lets you assign a corner of the screen to activate Flip 3D, providing you haven’t <a href="http://www.howtogeek.com/howto/windows-vista/disable-flip3d-in-windows-vista/">disabled Flip 3D like I have</a>.<br />
<strong>Using Vista Flip 3D Activator</strong><br />
Installing the application is as simple as downloading and extracting the program file and running through the install wizard. Once you’ve done that, you can then check the corner of the screen that you’d like to use for activating Flip 3D…<br />
<img alt="Vista Flip 3D Activator" border="0" height="405" src="http://www.howtogeek.com/wp-content/uploads/2009/01/image24.png" style="border: 0px none; display: inline;" title="Vista Flip 3D
Activator" width="338" /> <br />
You can also assign a mouse button if you want, although you should note that it doesn’t override IntelliMouse settings. Once you’ve activated Flip 3D, you can use your mouse wheel to scroll between the different windows, and then click to activate.<br />
<em>Note: for those of you that might be wondering, you can make Flip 3D stay on the screen without using any software by either clicking the “Window Switcher” icon in the Quick Launch (second to the left), or you can use the keyboard shortcut Win+Ctrl+Tab to make it stay on the screen. When it comes down to it, this utility really only saves clicking on the Quick Launch icon.</em><br />
<img alt="Vista Quick Launch Tray" border="0" height="114" src="http://www.howtogeek.com/wp-content/uploads/2009/01/image25.png" style="border: 0px none; display: inline;" title="Vista Quick
Launch Tray" width="219" /> <br />
I’ve never been a fan of Flip 3D, but it’s a good chance to <a href="http://www.howtogeek.com/howto/the-geek-blog/friday-fun-retro-nintendo-wallpapers/">show off my favorite wallpaper</a>!<br />
<img alt="Windows Vista Flip 3D" border="0" height="391" src="http://www.howtogeek.com/wp-content/uploads/2009/01/image28.png" style="border: 0px none; display: inline;" title="Windows Vista
Flip 3D" width="651" /> <br />
This utility is extremely lightweight, weighing in around 2mb on my system, and that was when I was toying with it.<br />
<img alt="Task Manager Flip 3D Activator" border="0" height="256" src="http://www.howtogeek.com/wp-content/uploads/2009/01/image27.png" style="border: 0px none; display: inline;" title="Task Manager
Flip 3D Activator" width="474" /> <br />
If you are a fan of Flip 3D, this is definitely the utility for you. <br />
<a href="http://notj.net/flip3d/windows_vista_flip_3d_activator.html" title="http://notj.net/flip3d/windows_vista_flip_3d_activator.html">Download Flip3D Activator from notj.net</a> | <a href="http://www.softpedia.com/get/System/OS-Enhancements/Vista-Flip-3D-Activator.shtml">Softpedia Download Mirror</a>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-67475018745554454312010-11-09T01:13:00.000-08:002010-11-09T01:13:28.555-08:00Awesome Music Desktop Gadgets for Vista and Windows 7Are you a music fan who wants an easy way to get the music you love with a simple application on your desktop? Today we bring you a list of some of the cooler music themed desktop gadgets for Vista and Windows 7.<br />
<strong>UnsignedBandWeb.com Radio</strong><br />
Check out new artists and bands emerging on the music scene with the UnsignedBandWeb.com gadget. It allows you to control playback, volume, and songs. You can can pick from a wide variety of music genres including Ska, Rock, Rap, and much more.<br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=b1a092d1-474d-4b22-91c4-e15786db39ef&=1&=1" title="http://gallery.live.com/liveItemDetail.aspx?li=b1a092d1-474d-4b22-91c4-e15786db39ef&=1&=1"><img alt="unsigned bands" border="0" height="531" src="http://www.howtogeek.com/wp-content/uploads/2009/08/unsignedbands.png" style="border-width: 0px; display: inline;" title="unsigned bands" width="512" /> </a><br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=b1a092d1-474d-4b22-91c4-e15786db39ef&=1&=1">Download UnsignedBandWeb.com Radio Desktop Gadget</a><br />
<strong>iTunes Accessory Gadget</strong><br />
This cool gadget allows you to control playback of tracks and other settings in iTunes without having to open up the entire iTunes application.<br />
<img alt="ituneshelper" border="0" height="128" src="http://www.howtogeek.com/wp-content/uploads/2009/08/ituneshelper.png" style="border-width: 0px; display: inline;" title="ituneshelper" width="308" /> <img alt="ituneshelp2" border="0" height="128" src="http://www.howtogeek.com/wp-content/uploads/2009/08/ituneshelp2.png" style="border-width: 0px; display: inline;" title="ituneshelp2" width="308" /><br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=609eb808-42e4-4c82-897a-ceeae4a074bd&bt=1&pl=1">Download iTunes Accessory Gadget</a><br />
<strong>ChroniX MetalRadio</strong> <br />
If you’re a fan of heavy metal, one of the coolest online metal stations is ChroniX Radio. This handy gadget lets you stream and control playback of their three channels–Aggression, Metal, and Grit–where each has a different flavor of hard rock and metal.<br />
<img alt="chronix2" border="0" height="565" src="http://www.howtogeek.com/wp-content/uploads/2009/08/chronix2.png" style="border-width: 0px; display: inline;" title="chronix2" width="634" /><br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=5f6564e5-5807-42c0-bc8f-1c4013f0cea9&bt=1&pl=1">Download Chronix MetalRadio Gadget</a><br />
<strong>iClassical Radio Player</strong><br />
For fans of classical music this gadget lets you stream classical music from a variety of online classical stations. The only controls are stop and play but being able to select from a wide variety of stations on your desktop make this a excellent app for the classical music connoisseur.<br />
<strong><img alt="Classical" border="0" height="202" src="http://www.howtogeek.com/wp-content/uploads/2009/08/Classical.png" style="border-width: 0px; display: inline;" title="Classical" width="235" /> </strong><br />
<img alt="Classical2" border="0" height="337" src="http://www.howtogeek.com/wp-content/uploads/2009/08/Classical2.png" style="border-width: 0px; display: inline;" title="Classical2" width="348" /><br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=78160e83-57c3-4fdb-93fe-28c2fda8c980&bt=1&pl=1">Download the iClassical Radio Player Gadget</a><br />
<strong>Media Player Gadget</strong><br />
This ties into your Windows Media Player library and allows you to easily search it. It also will display album artwork, track information, and give you visualizations when playing a song. It is a lot easier to navigate than opening the full WMP application.<br />
<img alt="Media Player" border="0" height="352" src="http://www.howtogeek.com/wp-content/uploads/2009/08/MediaPlayer.png" style="border-width: 0px; display: inline;" title="Media Player" width="656" /> <br />
<a href="http://gallery.live.com/liveItemDetail.aspx?li=7333ab20-11b8-4e85-afa9-f9360f38822b&bt=1&pl=1">Download Media Player Gadget</a>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-24505830126634207722010-11-09T01:08:00.001-08:002010-11-09T01:08:18.777-08:00Make Your Own Fake Virus with Notepad<img alt="image" border="0" height="303" src="http://www.howtogeek.com/wp-content/uploads/2010/11/image32.png" style="background-image: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="650" /><br />
Every geek wants to pretend that they are a dangerous hacker with the ability to take down any PC, and after you read this article, you can do show off your skills with nothing more than Notepad.<br />
Of course, we’re not making an actual virus—it’s a fake virus. In fact, it’s a test virus. But it’s still fun, and today’s article is sponsored by reader Erik, who wrote in and told us about it.<span id="more-34677"></span><br />
<h3>Create a Fake Virus with Notepad</h3>What we’re actually doing is re-creating the same technique talked about on eicar.org’s <a href="http://www.eicar.org/anti_virus_test_file.htm" target="_blank">test virus page</a>, except we’ve got better screenshots. <br />
Open up a Notepad window, paste in the following text, and then save it. <br />
<br />
<blockquote><code>X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*</code></blockquote>It should look exactly like this once you’ve pasted it…<br />
<img alt="image" border="0" height="301" src="http://www.howtogeek.com/wp-content/uploads/2010/11/image33.png" style="background-image: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="492" /><br />
And then you’ll almost instantly see a big fat warning that you’ve created a virus—as long as you’ve got anti-virus installed and working, of course. If you don’t see any warning, you should probably make sure your virus scanning software is properly enabled.<br />
<img alt="image" border="0" height="374" src="http://www.howtogeek.com/wp-content/uploads/2010/11/image34.png" style="background-image: none; border-width: 0px; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="640" />PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-91818207463242367982010-11-09T01:06:00.000-08:002010-11-09T01:06:12.826-08:00Help Troubleshoot the Blue Screen of Death by Preventing Automatic Reboot<img alt="image" border="0" height="125" src="http://www.howtogeek.com/wp-content/uploads/2010/11/image22.png" style="background-image: none; border: 0px none; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="612" /><br />
One of the most frustrating things about troubleshooting random blue screen errors is that the computer reboots before you have a chance to write down the error messages so you can Google them later. Here’s how to fix that.<span id="more-822"></span><br />
This is especially annoying if you keep getting blue screen errors because of some device conflict—I remember watching one of my friends trying to time it so he could snap a picture with his camera before it rebooted…<br />
<h3>Disable Automatic Reboot after Blue Screen Errors</h3>The quick and easy solution is to just turn off the automatic reboot option and force the blue screen to stay there, so that’s what we’ll show today.<br />
Right-click on the Computer icon and choose Properties. Windows 7 or Vista users will be taken to the system properties screen, so click on Advanced system settings.<br />
<img alt="image" border="0" height="308" src="http://www.howtogeek.com/wp-content/uploads/2010/11/image23.png" style="background-image: none; border: 0px none; display: inline; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="image" width="495" /><br />
The Advanced tab should already be selected, so you’ll want to click the Settings button under “Startup and Recovery”.<br />
<img alt="image" height="506" src="http://www.howtogeek.com/wp-content/uploads/2007/09/image176.png" width="457" /><br />
Here we go… just uncheck the option for Automatically restart under the System failure section.<br />
<img alt="image" height="499" src="http://www.howtogeek.com/wp-content/uploads/2007/09/image177.png" width="427" /><br />
Next time you get a BSOD you’ll be able to see it and able to write down the error message. You’ll have to manually reboot the computer if this happens, of course.<br />
<img alt="image" height="343" src="http://www.howtogeek.com/wp-content/uploads/2007/09/image178.png" width="639" />PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-3356275612497380242010-11-09T01:04:00.000-08:002010-11-09T01:04:09.750-08:00What is conhost.exe and Why Is It Running?You are no doubt reading this article because you are wondering what on earth this conhost.exe process is doing in Task Manager, and why it’s running on your shiny new Windows 7 PC. We’ve got the answer for you.<br />
<img alt="image" border="0" height="210" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image7.png" style="border: 0px none; display: inline;" title="image" width="560" /><br />
<strong>So What Is It?</strong><br />
The conhost.exe process fixes a fundamental problem in the way previous versions of Windows handled console windows, which broke drag & drop in Vista.<br />
It’s a completely legitimate executable—as long as it’s running from the system32 folder, and is signed by Microsoft. Scanning your computer for viruses is never a bad idea, though. <br />
<strong>Wait, What? So Why Do I Need It?</strong><br />
Oh, you wanted more information? I suppose I can oblige with some background information. Essentially, there’s a problem with the way the console process works on previous versions of Windows—they are <a href="http://blogs.msdn.com/oldnewthing/archive/2007/12/31/6909007.aspx" rel="nofollow">all hosted under the csrss.exe</a> (Client Server Runtime Process) service. This process runs as a system-privileged account. <br />
If you take a look at the command prompt on Windows XP, you’ll probably notice that the window doesn’t use the active theme at all. This is because the CSRSS process doesn’t have the ability to be themed. <br />
<img alt="image" border="0" height="273" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image8.png" style="border: 0px none; display: inline;" title="image" width="453" /> <br />
If you take a look at the console in Windows Vista, it looks like it uses the same theme as everything else, but you’ll notice that the scrollbars are still using the old style (look closely). This is because the <a href="http://www.howtogeek.com/howto/windows-vista/what-is-dwmexe-and-why-is-it-running/">DWM (Desktop Window Manager) process</a> handles drawing the title bars, but underneath it still works the same way, and the scrollbars are part of the window itself.<br />
<img alt="image" border="0" height="226" src="http://www.howtogeek.com/wp-content/uploads/2008/06/image17.png" width="517" /><br />
You might also notice that Windows Vista broke the ability to drag and drop files from Explorer straight into the command prompt. It just flat out doesn’t work, because of security issues between the CSRSS process running with a higher level of privileges. <br />
<strong>Windows 7 Does It Differently</strong><br />
Checking it out in Process Explorer under Windows 7 shows that the conhost.exe process is running underneath the csrss.exe process.<br />
<img alt="image" border="0" height="145" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image9.png" style="border: 0px none; display: inline;" title="image" width="524" /> <br />
The conhost.exe process sitting in the middle between CSRSS and cmd.exe allows Windows 7 to fix both of the problems in previous versions of Windows—not only do the scrollbars draw correctly, but you can actually drag and drop a file from Explorer straight into the command prompt:<br />
<img alt="image" border="0" height="175" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image10.png" style="border: 0px none; display: inline;" title="image" width="573" /> <br />
And it’ll paste in the path onto the command line. (of course this example isn’t very useful). <br />
<img alt="image" border="0" height="175" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image11.png" style="border: 0px none; display: inline;" title="image" width="573" /> <br />
<strong>Still Aren’t Convinced?</strong><br />
I can see our relationship has some trust issues. If you really want to be sure, check out the file properties for the conhost.exe executable, and you’ll see that the description says Console Window Host:<br />
<img alt="image" border="0" height="244" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image12.png" style="border: 0px none; display: inline;" title="image" width="400" /> <br />
If you look at the details of the process from within Process Explorer, you’ll notice that the ComSpec is set to cmd.exe, a clear indication that it’s hosting the command prompt. <br />
<img alt="image" border="0" height="551" src="http://www.howtogeek.com/wp-content/uploads/2009/10/image13.png" style="border: 0px none; display: inline;" title="image" width="479" /> <br />
So now you know what the conhost.exe process does, and why you should never attempt to delete it. Ever.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-34572296186963717442010-11-08T00:37:00.001-08:002010-11-08T00:37:48.153-08:00[How To] Always run an application as Administrator in Windows 7In Windows 7 you often need to run programs like DOS to run with Administrator rights to perform some critical tasks. To do this every time you have to right click on the icon and have to select Run as Administrator.<br />
Here is a little work around to avoid right clicking the application every time you open it. Follow the steps given below to do so…<br />
<img alt="" class="alignnone size-full wp-image-2390" height="368" src="http://tipsfromgeek.com/wp-content/uploads/2010/03/Windows-7-run-as-administrator1.jpg" title="Windows 7 run as
administrator" width="270" /><br />
<ol><li>Right click on the application icon or shortcut and click on Properties.</li>
<li>Click on “Compatibility” tab.</li>
<li>There check the <strong><em>Run this program as an administrator</em></strong> box.</li>
<li>Click on Apply and Ok.</li>
<li>If you want to allow all the users to run the application as Administrator then click on <strong><em>Change settings for all users </em></strong>.</li>
<li>Again check the <strong><em>Run this program as an administrator</em></strong> box in the newly opened dialogue box.</li>
<li>Click Apply and Ok.</li>
<li>You are done.</li>
</ol>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-81476032010507362202010-11-08T00:33:00.000-08:002010-11-08T00:33:15.126-08:00Free Download Big Book of Windows Hacks<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/_WWYb1nN_MQE/S2fLzWWzLCI/AAAAAAAAAlY/9KghIDBg9lM/s320/Big_Book_of_Windows_Hacks.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/_WWYb1nN_MQE/S2fLzWWzLCI/AAAAAAAAAlY/9KghIDBg9lM/s320/Big_Book_of_Windows_Hacks.jpg" /></a></div><br />
<br />
<span style="color: #6aa84f;">Need a single book that will guide you all about the hack and secrets in Windows? Its here available for Free download the Big Book of Windows Hacks. It contains a lots or tips and tricks for windows and decent hack for windows. Its really a very large collection of all types of hack and cracks in Windows. You must have this in you collection of Windows hacks or take it just for advanced information on Windows. <a href="" name="more"></a>This really a big book of all windows hacks collection from different sources and combind in all in one collection of tips and tricks for available hack in windows.<br />
<br />
</span><br />
<strong><span style="color: #a64d79;">Download Free Big Book of Windows Hacks:</span></strong><span style="color: #6aa84f;"> </span><span style="color: #6aa84f;"><a href="http://hotfile.com/dl/26565965/79b206f/OReilly_Big_Book_of_Windows_Hacks.pdf.html">Big Book of Windows Hacks.pdf</a></span><span style="color: #6aa84f;"> Size: 72.59 MB</span><br />
<span style="color: #6aa84f;"><br />
</span>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-14019237438322597072010-11-08T00:25:00.000-08:002010-11-08T00:25:24.967-08:00Quickly access files and folders using the stylish RocketDockRocketDock is kind of bar which allows you to easily access files and folders on your computer. If you don’t like to have icons on your desktop then this can be a very good option for you.<br />
<blockquote><blockquote>RocketDock is a smoothly animated, alpha blended application launcher. It provides a nice clean interface to drop shortcuts on for easy access and organization. With each item completely customizable there is no end to what you can add and launch from the dock.Now with added Taskbar support your minimized windows can appear as icons on the dock. This allows for better productivity and accessibility.</blockquote></blockquote><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" height="313" width="384"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><param name="src" value="http://www.youtube.com/v/d6UVb15it6A&hl=en_US&fs=1"><param name="allowfullscreen" value="true"><embed type="application/x-shockwave-flash" src="http://www.youtube.com/v/d6UVb15it6A&hl=en_US&fs=1" allowscriptaccess="always" allowfullscreen="true" height="313" width="384"></object><br />
<h3>Features:</h3><ul><li>Minimize windows to the dock</li>
<li>Real-time window previews in Vista</li>
<li>Running application indicators</li>
<li>Simple drag-n-drop interface</li>
<li>Multi-monitor support</li>
<li>Supports alpha-blended PNG and ICO icons</li>
<li>Icons zoom and transition smoothly</li>
<li>Auto-hide and Popup on mouse over</li>
<li>Positioning and layering options</li>
<li>Fully customizable</li>
<li>Completely Portable</li>
<li>ObjectDock Docklet support</li>
<li>Compatible with MobyDock, ObjectDock, RK Launcher, and Y’z Dock skins</li>
<li>Runs great on slower computers</li>
<li>Unicode compliant</li>
<!-- google_ad_section_start(weight=ignore) -->
<li>Supports many languages and can easily be translated</li>
<!-- google_ad_section_end -->
<li>A friendly user base <img alt=":)" class="wp-smiley" src="http://tipsfromgeek.com/wp-includes/images/smilies/icon_smile.gif" /> </li>
<li>And best of all… <strong><em>its FREE!!!</em></strong></li>
</ul><h3><span style="text-decoration: underline;"><a href="http://files.punklabs.com/RocketDock/RocketDock-v1.3.5.exe" rel="nofollow" target="_blank">Download RocketDock</a> </span> | <span style="text-decoration: underline;"><a href="http://rocketdock.com/" rel="nofollow" target="_blank">Homepage</a></span></h3>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-27568052095020199292010-11-08T00:18:00.000-08:002010-11-08T00:18:01.565-08:00[DOWNLOAD]Windows 7 BatteryBarWindows 7 BatteryBar is a free, good looking and customizable tool which lets you see your laptop’s current battery status.<br />
<br />
<img alt="" class="alignnone size-medium wp-image-2493" height="300" src="http://tipsfromgeek.com/wp-content/uploads/batterybar-261x300.jpg" title="batterybar" width="261" /><br />
<br />
To customize the settings click on the the <strong>Battery</strong> icon in the system tray. You can change the taskbar color to <strong>Red</strong>, <strong>Green</strong>, <strong>Yellow</strong> & <strong>Auto</strong>. If you change the color to <strong>Auto</strong> then it will change the color according to the remaining battery percentage:<br />
100% – 50% = Green<br />
49% – 11% = Yellow<br />
10% – 0% = Red<br />
<h4>License: Freeware</h4><h4>Works on: Windows 7</h4><h4>Download: <span style="text-decoration: underline;"><a href="http://www.door2windows.com/wp-content/downloads/windows7batterybar.zip" rel="nofollow" target="_blank">windows7batterybar.zip</a></span> [240 KB]</h4><h4>Home: <span style="text-decoration: underline;"><a href="http://translate.googleusercontent.com/translate_c?hl=en&sl=pt&u=http://www.door2windows.com/windows-7-battery-bar-show-battery-status-in-windows-7-taskbar/&rurl=translate.google.com&twu=1&usg=ALkJrhi0W0X-JZy44ilHtLyhfoHMtsZcRQ" rel="nofollow" target="_blank">www.door2windows.com</a></span></h4>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-48175999738909739482010-11-08T00:15:00.000-08:002010-11-08T00:15:45.462-08:00How to reset Windows admin password without knowing the old passwordHere is a simple tutorial on resetting the admin account password of any Windows Operating System. All you will require for this is one Ubuntu live CD.<br />
<ol><li>Insert Ubuntu Live CD and boot from it.</li>
<li>Open terminal and install <strong>chntpw </strong>in Ubuntu. To do so use the following commands.<br />
<strong>sudo apt-get update<br />
sudo apt-get install chntpw</strong></li>
<li>Now mount your Windows volume. In my case it was dev/sda1. Replace it with yours.<br />
<strong>sudo mkdir /media/WINDOWS<br />
sudo mount /dev/sda1 /media/WINDOWS</strong></li>
<li>Now navigate to the Windows configuration folder.<br />
<strong>cd /media/WINDOWS/WINDOWS/system32/config/</strong></li>
<li>To reset the administrator password enter<br />
<strong>sudo chntpw SAM</strong></li>
<li>After completing this command you will see 5 different choices. Select the 1st one and press Enter and done.<br />
<img alt="" class="alignnone size-medium wp-image-3437" height="230" src="http://tipsfromgeek.com/wp-content/uploads/2010/07/chntpw2-300x230.png" title="chntpw2" width="300" /></li>
</ol>PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0tag:blogger.com,1999:blog-33001420675025066.post-82606507070371855152010-11-08T00:10:00.001-08:002010-11-08T00:10:47.009-08:00How to show a banner at each startup in Windows<script type="text/javascript">
<!--
google_ad_client = "pub-9438595545669578";
/* TFG Linkunit 468x15, created 01/07/10 */
google_ad_slot = "9025561329";
google_ad_width = 468;
google_ad_height = 15;
//-->
</script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">
</script><script type="text/javascript">
<!--
google_ad_client = "pub-9438595545669578";
/* TFG HOME 336x280, created 01/07/10 */
google_ad_slot = "5975792563";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">
</script> <img alt="" class="alignright size-full wp-image-3452" height="133" src="http://tipsfromgeek.com/wp-content/uploads/2008/03/windows-logo-150-x-133.png" title="windows-logo
(150 x 133)" width="150" /><br />
<br />
There is a hidden feature in Windows and not many users know anything about it. You can setup a banner with a message in it. Each time your Windows boots up the same banner will pop up. The message can be anything from a welcome message to some important information. You can use it in the way you want. Follow the simple steps given below to setup a banner for your Windows system :<br />
<ul><li> First of all, go to “start” –> “run”.</li>
<li>Type “regedit” and hit Enter.</li>
<li> A new window will open named “registry editor”. In the left panal of the “registry editor”, go to the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\ system</li>
<li>Now right click on the right panel, choose “new”,Select “string value”. A new “string value” will be created.</li>
<li>Right click on it and choose “rename”. Type “LegalNoticeCaption” .</li>
<li>Right click on that “string value” and choose “modify”. On the “value data:” area, type the text or value that you want to see in the title bar of the banner.</li>
<li> Now create yet another new “string value” in the right panel and “rename” it to “LegalNoticeText”.</li>
<li> Right click on that “string value” and choose “modify”. On the “value data:” part, type the message you want to display each time windows boots.</li>
<li> Now, close the “registry editor”.</li>
<li> Restart your computer.</li>
</ul>Now, after the “boot screen” and just before the “welcome screen” a new banner will pop up which contains your message and an “OK” button. The users have to click on the “OK” button to proceed.PRASADhttp://www.blogger.com/profile/09788013734418818814noreply@blogger.com0