0 Access facebook is free now on Airtel.

if you are big fan of Facebook and love to connect with your friends using your mobile via Facebook then good news for you is Access facebook is free now on Airtel.

Bharti Airtel, one of the leading emerging markets’ telecom company in india, announced today that they will offer the full mobile site of Facebook in free, the popular social networking service that gives people the power to share and make the world more open and connected, free of charge for its 130 million plus customers across India. 

For the 2-month period, the partnership enables Airtel customers to access Facebook’s full mobile site faster and at no data cost from their Airtel mobiles via m.facebook.com.

Customers are accessing the mobile internet for the first time need to simply SMS ‘FACEBOOK’ to54321 to take advantage of this special offer.

Free access to Facebook Mobile on Airtel is available for the entire months of July and August, 2010.

0 Multiple value VLOOKUP

Creating a multiple value VLOOKUP. The Microsoft Excel VLOOKUP() function is one of the most useful but confused spreadsheet functions. It allows you to look up a value in a range based on a value of an ‘index column’.

In the table below, you can see a standard product list:

If we wanted to retrieve the price of an item based on the Product ID, we would use the VLOOKUP() function, as seen here:

• The first parameter of the VLOOKUP() function is the value to look for. In our case it is the Product ID found in cell A12
• The second parameter is the range where we want to look for the value. In our case, it is the range containing the products table: A1:C6.
• The third parameter is the column from which the value will be returned. In our case it is the third column in the range, which is column C (The price column).
• The fourth column indicates whether the VLOOKUP() function will look for an exact match or if it will settle for a close match. In our case we selected FALSE which says – Exact match.

If you are already familiar with VLOOKUP then you know how powerful a function it is. And if you have just heard about it now – congratulations, you have become a better Excel user.

The problem with VLOOKUP()

VLOOKUP is very useful, but it also has a lot of limitations. One of the most obvious limitations is that you can only look up a value based on one parameter. Another obvious problem is that you can only find rows that exactly match the parameter. You can’t define logical rules such as ‘bigger than’, ‘smaller than’ and so on.
So, if we wanted to retrieve an employee from the following table. A deck hand that has 8 or more years of seniority, for example, we would not be able to use the VLOOKUP function.

Fortunately for us, there is a way to do perform this lookup:

This lookup formula is built from three parts:


First we create an array, that has 1 column and as many rows as our lookup table. This array will hold the value 1 for each row in the lookup table that has the value ‘Deck Hand’ in the Role column and holds a number greater or equal in the ‘Seniority’ column.
This is done by this expression:
(C1:C9="Deck Hand")*1*(D1:D9>=8)*1
When this expression is entered as a formula (you need to enter this formula with CTRL+SHIFT+ENTER because it is an array formula), it will return two arrays of 1s and 0s and multiply them. The result would be the array described above.
In the second step, we use the MATCH() function to find the location (the index) of the cell that contains 1 within the array.
We use the INDEX() function to retrieve the employee name from column B, based on the index of the row that we discovered above.


Summary


If you found it difficult to follow the above, the best approach to learning this technique is to give it a try in your own project. You will quickly see how powerful it is!
This formula template can be used to retrieve values based on any number of parameters and is a de-facto, multi-parameter VLOOKUP function.
What do you think? Can you use this type of formula in your work? Please share your thoughts with us in the comments.

0 What is 4G technology?

4G is the term used to refer to the next wave of high-speed mobile technologies that will be used to replace current 3G networks. The two top contenders are LTE and WiMAX, both of which are IP based networks that are built from similar, yet incompatible, technologies. Sprint and Clearwire are currently offering 4G WiMAX service in the USA, while Verizon and AT&T have committed to the use of LTE and are trialing their own 4G networks.








4G technology is the fourth level of wireless technology available from wireless cellular carriers that utilizes ultra mobile broadband. The first generation of wireless technology available, 1G, refers to the analog signal used by cellular towers. 2G technology upgraded the analog signal to digital and allowed the inclusion of sending text messages across the network. 3G technology made use of electromagnetic wavelengths, known as spectrum, to broadcast a wireless broadband signal that allowed users to access the Internet and download applications using a 3G data card or a handheld mobile device such as a Blackberry or iPhone. 4G technology upgrades further to faster information transfer times, heightened security and greater information exchange abilities.


Ultra mobile broadband refers to the rate of data transmission available on the wireless network. 4G technology may provide data transmission rates between 100Mbps and 1Gbps. For comparison, 3G networks offer data transmission speeds averaging around 200kbps. Network connections on 4G may also be more accurate during travel when user and tower locations are at a constant rate of change—for example, when a user is traveling in a car and signals transfer between towers. This faster, more accurate connection likely can enable the transmission of larger packets of data than 3G networks. Users may be able to access increasingly information-heavy applications, such as HD television signals and real time audio during video chat.








What Is a 3G Netbook?
What Is a 4G Phone?
What Is the iPad™?
How Do I Create iPhone® Web Apps?
How Can I Convert an MP3 to M4R?
What Is a Touch PDA?
What Is a PDA Smartphone?
Category
Technology and Gadgets


Print this Article
Link to this Article
Comment on this Article
Add Page to Favorites
Suggest a Topic
Follow wiseGEEK


Did You Know?
Xanax is the most prescribed psychiatric drug in the US - 44 million prescriptions per year. more...
get widget
This Day in History
October 26, 2001: US President George W. Bush signed the USA Patriot Act. more...
get widget
Wireless Technology
4g Technology
4g Wireless Technology
4g Mobile Technology
Technology Mobile
4g Cellular Technology
4g Network Technology
Ads by Google
Dell™ Computer Networking
Dell™ Provides Computer Networking w/ 2010 Intel® Core. Visit Now. www.takeyourownpath.in/Dell_India
Green Technology Design
Design Green Technology Systems With Fully Automated CAD Software www.TurboTools.com
Information Technology
Middle East Job Opportunities. Upload your Resume now: Free! www.Bayt.com
3g Technology
Find Buyers for your Old Mobile. Simply Post an Ad on Quikr. Free! www.quikr.com
4G technology is the fourth level of wireless technology available from wireless cellular carriers that utilizes ultra mobile broadband. The first generation of wireless technology available, 1G, refers to the analog signal used by cellular towers. 2G technology upgraded the analog signal to digital and allowed the inclusion of sending text messages across the network. 3G technology made use of electromagnetic wavelengths, known as spectrum, to broadcast a wireless broadband signal that allowed users to access the Internet and download applications using a 3G data card or a handheld mobile device such as a Blackberry or iPhone. 4G technology upgrades further to faster information transfer times, heightened security and greater information exchange abilities.




Mobile Phone Security
Prevent eavesdropping, cloning Wireless crypto- voice, sms, files www.global-teck.com
Ultra mobile broadband refers to the rate of data transmission available on the wireless network. 4G technology may provide data transmission rates between 100Mbps and 1Gbps. For comparison, 3G networks offer data transmission speeds averaging around 200kbps. Network connections on 4G may also be more accurate during travel when user and tower locations are at a constant rate of change—for example, when a user is traveling in a car and signals transfer between towers. This faster, more accurate connection likely can enable the transmission of larger packets of data than 3G networks. Users may be able to access increasingly information-heavy applications, such as HD television signals and real time audio during video chat.


4G wireless service may include modems, netbooks and cell phones. 4G mobile hotspots may offer wireless connections for multiple devices, including computers, netbooks, handheld gaming systems, and mobile phones; with the 4G technology, users may be able to simultaneously download large applications to each device as well. A 4G netbook could operate similarly to a lap top, but with smaller memory and fewer drives; it may offer instant Internet access, downloading, and real-time Web chatting.


Related topics Wireless Technology 4g Technology 4g Wireless Technology 4g Mobile Technology Technology Mobile 4g Cellular Technology 4g Network Technology
4G technology may provide a new wave in downloading capabilities for consumers regardless of which device they choose. Developers have established certain standards for the high performance capabilities of the 4G network; this service may be difficult to provide on on existing cellular towers, however, as they number of users increases. Data transmission slows naturally when there is a large ratio of users to local towers. The United States Congress, with the implementation of digital television, increased available spectrum bandwidth, boosting the networks’ transmission capacity, but such technological improvements may not be enough for a full transition to 4G technology.

0 Microsoft has launched its latest office suite “Microsoft Office 2010” globally.

The Office productivity suit that has been out for some time, got a new face lift. The new Microsoft Office 2010 is heavily tested product. Apart from the Office 2010 Suite, Microsoft has also launched its lighter version for the web.

Microsoft Office is one of the widely used office productivity suit. It can be found on PC’s in offices, homes, universities, and many other places.

Microsoft office 2010 is now available at hundreds of retailer stores around the globe. It can also be downloaded from Microsoft website.

Microsoft Office 2010 is available in 3 different packages

Office Home and Student 2010 ($149.99)

1. Word
2. Excel
3. Power Point
4. One Note

Office Home and Business 2010 ($279.99)

1. Word
2. Excel
3. Power Point
4. Outlook
5. One Note

Office Professional 2010 ($499.99)

1. Word
2. Excel
3. Power Point
4. Outlook
5. One Note
6. Publisher
7. Access

Office can also be availed with other programs such as MS Project 2010 and MS Share Point workspace 2010. The new Office release has Communicator 2007 R2.

0 Open Multiple Gmail Accounts in Google Talk Chat Application

Nowadays Everyone have different email accounts for different uses. One for family one for friends and other for business and so on . Most of the people have many accounts on the same service like Gmail. As the Google Talk messenger does not support the invisible status and there is no multi gmail messenger. So i am giving you a trick to open multi Gmail accounts on Google talk on the same PC.

• Right click on the Google Talk shortcut on the desktop or any where else.
• Goto Properties and Click on the Shortcut Tab.
• After That Change The Following:

“c:\ program files\ google\ google

talk\ googletalk.exe” / startmenu

To

“c:\ program files\ google\ google talk \ googletalk .exe” /nomutex

Now every time when you will click on google talk shortcut, You will see a new google talk window and you can run as many accounts as you like. Enjoy!

0 What is KeyScrambler ? software that provides u r password....!

KeyScrambler Personal protects you from keyloggers.Here is a useful addon to protect your personal information.Install KeyScrambler Personal plugin to your browser like Mozilla, and Google chrome.




this is the one type of the software program that used to save the key punches from the computers keyboard and then saves that file to the computer as the text file or other format this way you can track anybody using the internet login forms and using input passwords will be easy to fetch. 

0 Nokia Photo Browser For 5230 and all S60 Sambian Users

Nokia Security Super codes

*#0000# – Shows software/firmware version. The latset Nokia 5230 firmware is v 12.0.089. Check the software version of yuor phone and if its not the latest one follow this Nokia firmware update tutorial.

*#06# – It tells the IMEI number of your Nokia 5230 mobile phone. The IMEI ( International Mobile Equipment Identity) number of each phone is different, its like finger print different for each and every mobile phone.

*#7780# – Soft Reset Code, It restores the factory setting without affecting your contacts, messages, files etc.It’ll ask for the lock code. The dafult lock code is 12345.

*#7370# – Hard Reset Code, on entering this code it’ll show you the same message “Restore all original phone settings” but this time it’ll erase all the data stored in the phone memory. So, use it only when some serious software problem occurs such as virus attack.Take phone meory data backup on memory card or PC  before doing hard format.

*#2820# - Bluetooth device address for manually connecting to a bluetooth device.

*#92702689# – Life Timer, shows total outgoing call minutes till date.