CTS Lozenge
 Issue 2.9
 
"We don't just supply computer equipment - we make IT work"

THIS ISSUE
Safety is paramount and Excel is useful

This issue has some really good tips for improving your Excel productivity and some good advice on how to protect your system from attack. 

We also advise on protecting your good name at up to half price and we have some clearance items for sale. 




ARE YOU SAFE?
Are your systems safe and productive

Most people have heard of antivirus and lots have heard of anti malware but both of these are not enough in this era of cyber crime. All systems need some sort of firewall - the hardware protection unit that prevent access to your computer system(s) by blocking ALL external access to your system(s) and allowing only those that are definitely needed. Not only that but they can also stop users accessing inappropriate websites. 

 

If you can imagine two houses with a wasps nest in the garden between them. One householder leaves  all the windows and doors open each day and the other has his house closed up tight and only opens a door when he leaves the building. Which house gets the most wasps? Well, it's pretty obvious. 

 

Exactly the same principle applies to a firewall - every access port to your system is closed until you decide it must be opened.

 

For further information ring 0191 3841140

 

TOGETHER - SHAPING THE FUTURE

 

As a full-service IT management consulting firm, we work with our clients to deliver solutions that help solve their specific needs. Our services are designed to help smaller businesses at an economic price. Utilising decades of industry experience, Computer Technology Services goes beyond the norm to develop solutions, drive results, and help grow your business.

 

IT Techniques is designed to highlight opportunities to increase your personal and your business's productivity by helping you master your current IT and its future development .
 

EXCEL HAS A BETTER CYCLE
Save time moving round spreadsheets


Most people know, and use, [Alt][Tab] to cycle through open applications which can be a wonderful timesaver BUT if you have loads of applications open and you are working on a few Excel spreadsheets it can be a bind having to cycle past a lot of applications just to get to the next spreadsheet.

We have an answer - using [Ctrl][Tab] instead of [Alt][Tab] will cycle you through just your spreadsheets (you obviously need to be in Excel to start with).
 

FIND THE RIGHT SHEET
Save time searching your workbook


If you have a large number of spreadsheets in your workbook try this:-

1. Go to the bottom left of a worksheet

2. Right-Click on the sheet arrows (the area with left and right arrows etc.) - y ou will get a pop-up list of all your active sheets

3. Click on the sheet you are looking for and you will be taken straight to it.  
 

QUICK ADDY-UPS
Add and cross-cast in one easy step


If you have a number of rows and columns you want to add up try this :-

1. Select the whole area plus one column and one row (so if you have figures in A1 to C10 select A1 to D11)

2. Hold the [Alt] key and press the [=] key

You should find that column D will have the totals for each row and row 11 will have the totals of each column all with a couple of keystrokes.

A similar principle applies to adding up columns - select the first empty row after your figures and press [Alt][=].

And for adding up rows select the first empty column and press [Alt][=].

OUR EXCEL SERVICE
Let us solve your problems

 

If you have a complex spreadsheet requirement or you just need to 'take the pressure off' don't forget our 
Excel Spreadsheet Service.  

We can, and have, developed anything from pricing, invoicing and database systems to complete accounting systems for our clients. Our management accounting background and experience enables us to quickly assess your needs and come up with the right solution. 

 

Just give us a call on 0191 3841140  

 up to
HALF PRICE DURING JULY

FULLY MANAGED DOMAINS AND EMAIL ADDRESSES
Protect your names
    
up to
HALF PRICE DUR ING JUL Y

 

  • Protect your business and your personal names. 
  • Make sure that people aren't directed to a competitor or that you can't use your own name in the future. 
  • Get rid of .hotmail, .gmail etc. and have your own domain and email address that promotes you.
Ring 0191 3841140
 
 
FOR SALE

Prices
ex. VAT
100 GByte Solid State Drive - secondhand, refurbished and fully tested
?30
1 only
TP-Link ADSL2+ Ethernet/USB Modem Router
?15
EVGA NVIDIA GeForce 210 Graphics Card - dual port
?25
1/2 metre Cat 6 Patch Lead - snagless RJ45 grey
?5
2 metre Cat 6 Patch Lead - snagless RJ45 grey
?5
15 metre Cat 6 Patch Lead - snagless RJ45 grey
?10

 

Ring 0191 3841140

John M Foster
FCMA CGMA FCCA MCIM

We don't just supply computer equipment - we make IT work