Click here to print this page

Planning Retirement Online

You can do IT in laterlife 

 

You can do IT is a regular feature of laterlife.com aimed at trying to help laterlife visitors make the most of Information Technology on or off the web. 

Jackie Sherman who runs the You can do IT Question & Answer section is an IT trainer and author. Jackie has spent her career in education and specialises in teaching IT to adults. Her courses for adults include such topics as MS Office, the Internet, e-mail and basic web page authoring.  

Jackie has also written several books - you can find more details about these by clicking here. Jackie has also been running a course specifically for over 50s.

Via laterlife.com Jackie aims to particularly help those new to IT and the web to build up knowledge and confidence, so no question is too basic. At the same time she will cover Q&As for the more experienced user. 

So if you would like to ask a question of Jackie, why not email her jackie@laterlife.com 

Or if you have discovered something which may be of interest to others in making the most of the web, then she would love to hear about that too.




View previous editions of YoucandoIT for more useful Questions and Answers



November 2012 

Storing Files Online - Cloud Storage; Totalling in MS Word Tables

Q: I want to keep important files and music backed up but it is difficult as I have to keep buying CDs to save to and my CD writer is not very efficient. Is there a way now to store things online? My internet provider does not offer free web space.

A: One new development is Google's Drive that allows you to store files online (otherwise known as "cloud" storage). Once you have a Google account (which is very easy to set up) you can download the programme that creates a folder on your computer. Whatever you put into that folder will ALSO be stored online and can be accessed via Google's website. As it is so straightforward, you can copy any important documents into the Google Drive folder whenever you create or update them and know they will be safe online if anything happens to your own computer copy.

You can set your computer to synchronise the folders and so update the online Drive folder automatically, or sign in to Google Drive and click the Upload button to add your PC's folder contents. The contents of the folder on the Web will be listed in the window so you just double click to view them online. You will find that your Office-type files here are all converted to a new Google format, but you can download them in other formats if you need to create a new version, for example if your original becomes lost or corrupted.

Google DriveTo download the Drive software that creates the folder on your computer, go to www.google.co.uk and click the Documents tab (which will be amended to say Drive). Sign in and there will be a download button to click. Once installed, you will see a Google Drive link on your desktop.

Double click to open it and then drag any files you want to keep copies of into the folder.

Amazon have their own version of this service known as Amazon Cloud Drive and you can find out more and download the software via the linked text above.

Once installed, you will be asked to sign in to your Amazon account and then follow the steps to upload the files you want to keep.

Amazon Cloud Drive Sign-In

To find your files online, go to www.amazon.co.uk/clouddrive and sign in. You will see that they also have a music storage and player system known as Cloud Player.

Amazon Cloud Drive Interface




Q: I need to send out regular invoices and prefer to use a Word table. How do I get this to produce totals?

A: When you set up your table, make sure you use a new cell for every numerical entry and just use figures on their own. The table can then be treated rather like a simplified spreadsheet program as it will calculate totals by adding all the entries in the cells above the Total cell.

In this example, I have set up a simple table of figures.

Item Price(£) Date
Gems8502/10/12
Watches15011/09/12
Cufflinks62.9914/11/12
TOTAL    

To find the total price, click in the empty Total cell and select Table – Formula.

In the menu that opens, you will see the term =SUM(ABOVE) entered automatically, although you can change this to other Excel-style functions.

Click OK and a shaded total will appear in your cell.

Item Price(£) Date
Gems 85 02/10/12
Watches 150 11/09/12
Cufflinks 62.99 14/11/12
TOTAL 297.99  

If you change or add entries, update the total any time by right-clicking the shaded entry and selecting Update Field. Note that the figures will NOT necessarily update automatically, so always check any final invoices carefully before you send them off!



Back to Laterlife YoucandoIT Index


 

    Keep in touch with everything happening in Laterlife Today!

    Subscribe to our free monthly email newsletters for the latest articles, offers and events. You can unsubscribe at any time should you want to.

 


Bookmark This

Share on Facebook Receive more like this

 

everyday computersTell us your computer experiences

Want to comment on this article or ask other laterlife visitors a question?

Then visit the comment section of the Later Lifestyle Network, click on the 'Discussion Tab' (you can't see this until you are logged in) and create a new topic or add your views to an existing one. 

feeling Good

Feeling Good

The above article is part of the features section of laterlife.com called laterlife interest. laterlife interest contains a variety of articles of interest for visitors to laterlife.com written by a number of experienced and new journalists.

It includes both one off articles and also associated regular columns of a more specialist nature such as Healthwise, Gardener's Diary, our regular IT question and answer section called YoucandoIT and there's also 'It could be you' by Maggi Stamp laterlife's counsellor on human relationships. 

Looking to the future

Looking to the future

Tell us about what you would like to see here on laterlife.com in the future or any changes you would like to see. Just email views@laterlife.com
 

Latest articles

To view the latest articles click on laterlife interest index. To search for articles about a certain topic, use the site search feature at the top right of the page.
 
Back to Laterlife Today

Visit our Pre-retirement Courses section here on laterlife or our dedicated Retirement Courses site

Bookmark


Advertise on laterlife.com



LaterLife Travel Insurance in Association with Avanti