Anchit Pandey, Author at Electronic Gurudev

Dec82011 by Anchit PandeyNo Comments

Excel – Check to see if a value exists in a list?

Technology

Many times while using excel you have come across a situation where you have you need to check if a value exists in a list or not. Well its easy to check manually if the list is not long or you have plenty of time :P However, there is a cool workaround here which I use always. believe me it has saved me a lot of time. Formula= OR(INDEX([range of list]=[value],)) If the value exists in the referenced list then the output will be TRUE otherwise FALSE. For example in above image as you can see for yourself entry PEN does exist in the list so the output will be TRUE by default. There are many other workarounds and I shall be glad if you would like to share you own way with readers.

Dec62011 by Anchit PandeyNo Comments

Fix Error – “Word Cannot Start the Converter MSWRD632.WPC”

Technology

Recently, I had a user in my office get the following error when trying to open a Word document: Word cannot start the converter mswrd632.wpc. Whenever the user clicked the OK button, it would simply pop back up. What was really weird is that if she clicked on the red X button, the document would open just fine! Strange! The user was running Office 2007 and getting this error. After doing some research, we came across a few possible solutions. In this post, I’ll list them out here. Method 1 – Unregister Text Converter Basically, in Windows XP SP2 and above and Windows Server 2003 SP1 and above, if you have a plain text file or another kind of file that is not a Microsoft Word file, but has a .doc extension, you will get this error. This can also happen if you are opening a really...

Nov272011 by Anchit PandeyNo Comments

7 Super Tips to Prevent Virus, Trojans & Malwares

Technology

Once infected, these deadly worms can cause computer crashes and install malware that steals your personal and security information. Here is a quick 7 step guide on how to prevent your computer from being infected. Turn on your firewall: Turning on your firewall prevent the installation of malware and spyware on your computer significantly and block access of these worms to your computer. Make sure firewall is on and you have blocked unnecessary open ports Handle email attachments carefully: Never open an email attachment from someone you do not know or any attachment that looks suspicious as they might contain virus and malicious codes Avoid malicious websites: Do not go to porn sites or any malicious or suspiciou...

Nov242011 by Anchit PandeyNo Comments

Increase internet Speed by tweaking QoS in Windows Xp

Technology

The following tweak has been tested with Windows XP only. however I am not denying that fact that these settings may be able to tweak and optimize Windows 7 internet and network speed. The default system behavior is that all 100% bandwidth is available, however, if there is a running application that indicates to the OS it needs to send high priority/real time data, then as long as it has the socket open, Windows XP will restrict “best effort” traffic to 80% of the bandwidth so that high priority traffic can be accommodated. Basically, applications can make this request to the operating system for QoS support using the QoS application programming interfaces (APIs) in Windows and this only applies if a specific app is requesting QoS. If you'd like to change how much bandwidth is reserve...

Nov222011 by Anchit PandeyNo Comments

Top 10 Excel ShortCuts (Always Help You)

Technology

Most of us understand & knows the importance of Excel keyboard shortcuts. While it may be a good idea to know a 97 different shortcuts for everything in Excel, the fact is, you don’t use them all the time. So, it all boils down to memorizing the few shortcuts that you use all the time. In this post, I am sharing 10 such shortcuts that I can’t live without, especially, when I am analyzing data, making charts and formatting my workbooks. 1. CTRL+1 – Format I use this all the time, to format cells, charts, text boxes – you name it.2. CTRL+SHIFT+L – Turn on/ off filtersMost of the time, I use filters to do ad-hoc analysis of my data. So, Once I set a couple of filters, If I want to revert back to full data, I find clearing each filter a pain. So I just turn-off and turn-on the filters...

Nov172011 by Anchit PandeyNo Comments

Important MS Excel Shortcuts

Technology

Function Keys F1 Displays the Office Assistant or (Help > Microsoft Excel Help) F2 Edits the active cell, putting the cursor at the end F3 Displays the (Insert > Name > Paste) dialog box F4 Repeats the last worksheet action (Edit > Repeat) F5 Displays the (Edit > GoTo) dialog box F6 Moves to the next pane in a workbook (if the window is split) F7 Displays the (Tools > Spelling) dialog box F8 Toggles whether to extend a selection with the arrow keys F9 Calculates All the worksheets in All the open workbooks F10 Toggles the activation of the Menu Bar F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range F12 Displays the (File > Save As) dialog box Shift + Function Keys Shift + F2 Inse...

Nov142011 by Anchit PandeyNo Comments

Facebook Timeline : Know how to Get Back to Old Profile

Technology

In early September Facebook flooded users profiles with lots of new updates which even becomes harder for users to understand and manage. Among those updates, ‘Facebook Timeline’ profile was the major update which could decide Facebook’s upcoming days. It’s not always that all the pushed updates are liked by the users, some even gets irritating for users such as the new Facebook chat and the news ticker, which can be fixed with Facebook News Ticker Remover and FB chat sidebar disabler, all thanks to third party developers. When Facebook introduced the new timeline profile it was available only for developers. So if you are among those many people who enabled the new Facebook Timeline profile utilizing the developer account and among those only few who hasn’t yet revert back to old pro...

Nov122011 by Anchit PandeyNo Comments

Cannot Open a particular website? See What to do

Technology

Your computer is connected to the Internet but you are unable to open a particular website though all the other sites are loading without issues. For instance, you can open yahoo.com and bing.com but it takes forever to load www.google.com even though the site is up for everyone else in the world. How to Troubleshoot your Internet Connection Step 0: Like with everything else, switch off the modem, restart the computer, and turn on the modem again. Also clear the Internet cookies and browser cache. Problem gone? No, proceed to the next step. Step 1: Temporarily disable your computer's firewall and close any anti-virus software that may be running in the background. If you are now able to access the websites that were previously not loading, your security program is causing the proble...

Nov112011 by Anchit Pandey1 Comment

Best 10 Free Blog Directories

Technology

One of the many ways to increase the web blog or site popularity is by submitting your URL to as many Blog directories, these a common part of SEO (Search Engine Optimization) to make your blog more searchable by most of Search Engine and increasing your web traffic. Best Free Web Blog Directories Submitting URL to the blog directories can be a little bit difficult and tedious, because some blog directory are required to register before you can submitting URL, adding reciprocal link for validation etc. The list below is the best of blog directory that I know. Actually, there are so many blog directories, but I pick just 10 blog directory based on popularity, SEO friendly, fastest approved directory, free and trusted site. If you want to submit to another web directory, you c...

Nov102011 by Anchit PandeyNo Comments

Top Microsoft Windows Media Player Plug-ins

Technology

It’s hard to find good WMP plugins. If you couldn’t yet find good plugins, despair not! Now that you’ve made your way to this article, you should have no trouble picking out some of the best WMP plugins available. 1. Now Playing Plugin The Now Playing plugin is one of the best Windows Media Player plugins. It is easy to use and the best for basic and advanced WMP enhances. It has many features, but the one I like the most is the ability to automatically update Facebook and Twitter statuses with the song that you’re listening to. The plugin lets you choose what information you want to pull from WMP, from the filename to the bitrate or the artist and song title. Advanced computer users can also export their “now playing” information to an XML file. This is particularly us...