Technology - The Digital Indian

Dec302011 by Anchit PandeyNo Comments

Be Safe from Spamming on Facebook

Technology

Spammers/Hackers keep finding new and innovative ways to reach out to the masses. Since Facebook has been immensely popular social network, it becomes very attractive media for spammers. It also seems to be very easy to convince users to click a few buttons and steal all your data. They also post links on your friend's walls to attract more visitors. Found a couple of my innocent friends posting these materials again and again. How do you safeguard yourself? Don’t click on any link that you do not know or is suspicious. If any application asks you to approve/join/like do not do it unless you know the website/link They will have very attractive images/text - E.g. Osama bin Laden's uncensored pictures. If it’s too good to be true, it may not be safe link. What do they get by spread...

Dec182011 by Anchit PandeyNo Comments

Comparison Between Aakash and UbiSlate 7 Tablet Models

Technology

We have already been informing you about all possible details – technical specs, features, prices, availability for the Akash computer tablet as well as its upgraded model UbiSlate tablet. Now, when Aakash tablet has finally been made available for sale online and UbiSlate is available for online pre-booking, most of the users are some how confused about the difference between Aakash Tablet PC and UbiSlate tablet. We can also blame the company as well as Indian Govt. for this confusion. This is because at the time of launch, people just came to know about one name i.e. Aakash Tablet. However, Aakash tablet was subsidised as it was targeted to be a students model of the tablet. However, subsequently, company DataWind and Indian Govt. started taking different Aakash tablet models which they ...

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 suspicious chat ...

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 reserved fo...

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 Inserts or edi...

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 profil...

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 problem...