Skip to main content

Posts

Showing posts from July, 2013

Search from the Address Bar

There are three things I’ll discuss in this post… Enable searching from the Address Bar of a browser Type “about:config” in your browser Accept the warning message given about being careful Search for “ keyword.enabled ” Toggle the value of the boolean variable by right clicking on it. If its set to false – you’ll not be able to search from the address bar If its set to true – you’ll be able to search from the address bar   Change the default search engine assigned Type “about:config” in your browser Accept the warning message given about being careful Search for “ keyword.enabled ” – Ensure that its “true” – if it isn’t then Toggle the value by right clicking on it and selecting “Toggle” Search for “ keyword.url ” Set the value to the search engine you want to use: For ex: to use Yahoo search engine – set the value to http://search.yahoo.com/search?p= To use Bing – set the value to http://www.bing.com/search?q= You are all set to search now…Just type the search li

Looking up for an example on VLOOKUP?

From all the questions I have been asked about and I have asked mostly are related to Excel Formulas If I filter even further I will find that I am looking for information on vlookup most of the times… Here is one attempt from my end to explain what vlookup is all about. What’s VLOOKUP? Ya ya apart from the obvious answer that its an excel formula, it’s a search function! It can find you matching information from a particular table of data – something similar to a hashtable or dictionary in data structures   You give it an identifier and it will find the corresponding value for it…   Can I get a VLOOKUP Example? Of course! That’s what this blog is about   Jokes apart, here is an example of VLOOKUP Problem Statement: Your boss asks you to find out the work experience in number of years of your team mates Data you have: Now you have to fill in this table to present it to your boss: Now you’ll get the data in columns H, I from C and D – isn’t it? that’s simple   You have

Can’t buy free apps on iPad?

I bought the iPad but I was really pissed off that I can’t seem to  buy any free app. I had an apple id, but then it wanted me to give my credit card details to download a free app too…Pch!!! So I googled a bit and got this solution…   Create an apple id if you don’t have one Now download the iTunes app on your computer Open iTunes and follow these steps: Go to iTunes Store under the “Store” category on your left side panel Now go to “Apps Store” on the top panel You will see “Top Free Apps” on the right side panel (Scroll down if you don’t see) Mouse over any of the free apps listed Click on the app name (Don’t click on the free button shown when we mouse over) Then you will be asked to signin – sign in with your apple id Then you will be asked to “review” Go ahead and select “none” on the payment screen Screen will be similar to this: http://www.simonblog.com/2011/01/09/why-there-is-no-none-option-when-registering-itunes-account/ Enjoy the free apps download from