This is especially useful when using VLOOKUP functions which seach for values in one column and return values in other columns.

How to use it:

Using ISNA is conjunction with IF, you can create a formula that will replace #N/A when it appears.

=IF(ISNA(“<yourformula>”),”",”<yourformula>”)

for example:

=IF(ISNA(VLOOKUP(A1,B1:B26,1,FALSE)),”",VLOOKUP(A1,B1:B26,1,FALSE))

Ctrl + Pg Up / Pg Dn allows you to change worksheet in Excel

http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-HP005203781.aspx

There are a few articles posted on the support site which give a few idea’s but I though I would summarise what is necessary.  http://wordpress.org/support/topic/217419?replies=7

Try set the .narrowcolumn float to “right” and remove the #sidebar “margin-left”

I found that once I had done that I still had to adjust the column widths to then shift the text over to align it with the background.  These are the two extracts that I have used:

.narrowcolumn {
float: right;
padding: 0 45px 20px 45px;
margin: 0px 0 0;
width: 440px;
}

#sidebar
{
padding: 20px 0 10px 25px;
‘    margin-left: 45px;
width: 160px;
}

http://office.microsoft.com/en-gb/excel/HP052037811033.aspx

Command line switches are available for launching Windows Explorer (explorer.exe)

Information available from Microsoft here:

http://support.microsoft.com/kb/130510

They are USB flash storage.

An 8GB USB drive will cost you about £10.

I am particularly fond of the Lexar JD FireFly.

http://www.lexar.com/jumpdrive/jd_firefly.html

What most people overlook is that they already have this connectivity available to them.

Connect to the Internet via a Mobile Phone

A standard mobile phone (as sold in the UK) comes with 3G internet connectivity. This connectivity can be used by your laptop, via bluetooth or a direct cable, to connect to the internet.

The Costs

Most mobile phone companies will charge you for any data you use. These charges can be quite expensive if you don’t monitor them. One month I was hit with a GBP150 bill for data usage when I needed to connect to the internet.

Most mobile providers will add unlimited internet onto a mobile tariff for a small fee, or suggest you upgrade to a new tariff which includes unlimited data.

Many providers now put a cap on the maximum they can charge you for data access even if you are not on a data tariff.

The cost of upgrading an existing mobile phone tariff is normally cheaper than getting a new 3G contract, and you also don’t need to carry around another device.

Blackberry Users

Almost all blackberry devices have 3G connectivity, bluetooth and most of them are already connected on a mobile data tariff due to the way they send and receive emails.

Most companies however switch off the bluetooth on these devices which stops employees using them as 3G modems. This does not make good financial sense not to allow these to be used as internet gateways.

It always brings a wry smile to my face to hear of people who carry around a Blackberry, a mobile phone, a laptop and a 3G modem.

What about battery life?

Most mobile phones are able to charge themselves via a USB charger, so while you are using your laptop, your phone won’t be losing charge. You can also find very small retractable chargers for most mobile phones which are very small and light.

If you are worried that battery life of your laptop will be depleted by plugging in a phone, then you should be aware that there is little difference between powering a 3G modem plugged into your laptop than a mobile phone.

How do I connect?

This is the complicated bit. Essentially you need to set your mobile phone up as a modem. If you connect you phone to your laptop via bluetooth, then your laptop will normally detect that it has modem capabilities.

To tell the modem it needs to connect to the internet, you enter *99# where the phone number is entered.

For more information on how to connect, then a quick google search should provide you with tutorials and answers.

The birth of Tech Patrol on timjolley.com

The result of many people asking for advice on technology, and the need to dispense this advice in a simple and effective manner.

There is no agenda in this blog, and it will consist of random topics and posts of things I like and things I don’t like.

The site is not sponsored, and reviews are genuine.