Welcome to our new FREE newsletter designed to help you improve the way you work with your IT systems.  

Computer Technology Services (Durham) Ltd
ISSUE 3

"Our aim is to help our clients increase their efficiency and improve their method of operation"


This is our new FREE subscription based newsletter bringing you ideas and techniques from the world of IT. We are trying to build our readership so pass this on to your friends and colleagues and make sure you encourage them to sign up.

20%

Off

All 2-year Support Contracts

taken out in October 2014

Paid in 2 annual instalments




 CTS Lozenge

CONTRACTS - Are you getting the service you require and deserve

Support contracts should both protect your systems and help your staff resolve problems they may encounter, a simple repair contract is not enough.

The features you should look out for include 24/7 monitoring of your systems for early identification of any problems and, of course, telephone hotline and remote assistance for those problems that need quick solutions.

Other benefits could include such things as asset inventory, regular systems speed checks and hygiene cleans as well as backup monitoring.

Our contracts are tailored you your requirements and can include all of the above items. You can pay monthly or save significantly by paying annual amounts up front. So if you don't feel that your current support is good enough just give us a call- there's up to 20% off in October.

 



OFFICE CLIPBOARD

Office 2010/2013 includes the Office Clipboard which is an enhanced version of the long-established Clipboard but you need to know how to access it. The Office Clipboard stores up to the last 24 clipped items as opposed to just one. With the 'old' Clipboard if you saved a second clip you lost the first clip, now corrections etc. can be much easier.

To see the Office Clipboard click the Clipboard Dialog Box Launcher (that's the little box with an arrow in it at the bottom right hand corner of the Clipboard group and the Home tab).

There are some Options at the bottom of the Office Clipboard window which are self explanatory-the most useful is the Show Office Clipboard when Ctrl-C pressed twice. You can Clear or Paste the whole Office Clipboard using the two buttons at the top

 






SPEAK A FOREIGN LANGUAGE WITH GOOGLE TRANSLATE

This desktop and mobile app makes translation dead easy. You type in the phrase (or copy it if it has come, for example, by email). Not only does the software translate but it also automatically works out what language it is in.

The mobile app allows you to speak the text and it will translate into the language of your choice and not only speak it back but also show the words in text in both languages and will allow you to save the recording. This enables you to create your own phrase book.

Imagine you are on holiday in Italy and you don't know Italian; you want to find the nearest railway station. Grab a passer-by, dictate your question into your iPhone, in a few second your iPhone will speak the phrase in Italian back to your friend. Save the phrase in case you need it again and off you go. 

If need be the passer-by's answer can be spoken into your iPhone in Italian and translated into English 

It is not perfect but it should get you by and the app is FREE.  

 








 

DEALING WITH WIDE SPREADSHEETS

When using wide spreadsheets, you will often need to work with data on the far right of the sheet but also keep visible the related data on the left. The widely know solution is to use Freeze Panes:-
  1. select the column to the right of the one you want to freeze
  2. from the View tab
  3. click Freeze Panes
  4.  click Freeze Panes again

Now you can scroll to the right while the frozen column remains visible on the left.

Another solution which works where you regularly need to hide and unhide specific columns is to use Grouping which is normally used for hiding the details of subtotalled data:-

select the contiguous group of columns (e.g. Columns C:E)

go to the Data tab
click Group

An outline bar and [-] symbol will appear above the columns. When you hit the [-] symbol the group of columns will disappear and the symbol will change to a [+]. Once you have finished all you have to do is press the [+] symbol and the columns will reappear.

To remove the Grouping :-

  1. go to the Data tab
  2. click Ungroup 

A similar principle works for rows.








BATTERY SAVING ON THE iPhone AND iPad

  1. Make sure that you regularly close down applications that you are not using - double-click the Home button to reveal all your open apps and then swipe up all the apps that you don't need (suggest doing this daily)
  2. Go to Settings/Privacy/Location Services and turn off those applications that you do not need
  3. Go to Settings/General/Background App Refresh and turn off those applications that you do not need
  4. Go to Settings/General/Spotlight Search and turn of those applications that you do not require to be indexed for searching
  5. Go to Settings/General/Siri and make sure Raise to Speak is turned off
  6. Go to Settings/Notification Centre and disable apps where you do not require notification in the Notification Centre (i.e. where you swipe down and a notification window opens) - this is quite a long exercise but you only do it once!
  7. Go to Settings/ WiFi and switch off WiFi if you are not using it
  8. Go to Settings/Bluetooth and switch of Bluetooth if you are not using it 


   

BACKGROUND

Based in the historic city of Durham we bring together a unique mix of computer, business management and marketing skills to form a leading IT support organisation for small and medium sized businesses covering the North East of England.

We are a small, family business with over 30 years experience supporting a wide range of computer systems and designing IT solutions for local organisations.

Qualification in accounting and business management ensure the highest standards of competence and confidentiality.


We want to know what you think of the new IT Techniques. Are you finding things of interest?

Are you having difficulty following the instructions etc.? Let us know.


Computer Technology Services (Durham) Ltd
75 Willowtree Avenue, Gilesgate Moor, Durham, Co. Durham, DH1 1DZ
Tel: 0191 3841140 
Email: enquiries@computertechnologyservices.co.uk     Website: www.computertechnologyservices.co.uk 
We don't just supply computer equipment - we make IT work
Join Our Mailing List!
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.