 |
|
This is a collection of tips on different areas in the computing world. Come back to check every once in a while for new additions.
Excel There's plenty of things that you can use to make Excel do the hard work for you Beginner When you have your Excel spreadsheet open you can see the horizontal bar showing alphabets starting from A (columns), and the vertical bar showing numbers from 1 (rows). These work like map co-ordinates, A1 being the top left cell. - If you don't have any suitable excel-documents to try this out on, type a couple of letters on each cell on rows 1-3 on columns A and B. Left-click with the mouse on the letter A (whole column changes colour),release the mouse, then move the mouse very slightly down on top of the bottom border of that A cell. (Mouse pointer has changed into a white pointy arrow.) Left-click with the mouse, keep the mouse button pressed down and move with the mouse to the next empty column (C in this example). All the data has moved on one go to the new column. One Step Further Let's make finding the correct row a bit easier You will need to have a document with headings ie on the first row each column needs to have a title for that data that belongs underneath it (eg firstname OR telephone). Left-click on the A1 cell choose from the top-most toolbar 'Data' 'Filter' 'Autofilter' Each column heading has now an arrow on the right side of it. If you click on it you can choose which row of data it will show you! You'll get back to seeing everything by clicking the same arrow and choosing 'All' iTunes / Spotify
This works in a handful of countries so far, luckily UK being one of them.If you already use iTunes, you've probably bought songs over the internet. Sometimes you would like to be sure that you are buying the correct song, but the short sample might not be long enough to determine this... Try Spotify - it's free and legal. You can listen the whole song all the way through! http://www.spotify.com/ How to put links in your word document Let's say you've written a great article and would like to give your reader the chance to find out where your business is located by giving them the web address to Google maps. "We are located in Finchley, London" You could of course just copy the whole address into the article but if you have actually pin pointed your location, this address will be a couple of rows long and wont' look very tidy. You'll want to highlight the words "Finchley, London" and click on the little icon of a globe OR go 'insert' 'hyperlink'. This opens a pop-up window where you will need to put your google maps web address. Ie go to your web browser (e.g. Firefox, internet Explorer etc), go to maps.google.com and put in your postcode. Google Maps shows the location on the map. Click on the word 'link' on the top right. Copy the address from the address bar ('paste link in email') and go back to Word and to the pop-up window still open there. Paste the address in, click ok and you are done! Next time: how to put in a real Google Map! |
