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

 

 

LAPTOP REPAIRS

from �49+ VAT 

Ring 0191 3841140 for estimate

 

 

 

SPREADSHEET DESIGN

One of the most useful and versatile pieces of software is the spreadsheet. In fact VisiCalc was one of the first software applications that were developed for what was then called the microcomputer back in the 70's followed shortly by Lotus-1-2-3. Nowadays at the forefront of this type of application is Microsoft's Excel.

The spreadsheet can perform many tasks-here are just a few :-

 

  • Accounting
  • Stock Control
  • Budgeting
  • Cashflow Forecasting
  • Marketing
  • Invoicing
  • Estimating
  • Costing
  • Sales and order tracking
  • Human Resources

  

 

 

 

 

 




 

This is apart from the industry specific applications within the chemical, engineering and other industries using sines, cosines and other things I don't really understand.

Any job that requires figures to be manipulated has a home in the humble spreadsheet and the humble spreadsheet has a home in every business. For example the latest versions of Excel has over 400 different functions (a long way from the original addy-ups and takey-aways).

The service is managed by John, our Chartered Management Accountant, who not only has many years' experience of spreadsheets but has been around figures all his working life and has produced everything from a simple invoice to complete accounting systems.

But Excel is not just about numbers it has a host of text manipulation functions and, in fact, it is used extensively where tabular lists are built, sorted and shared.

So, if you have wanted to automate a financial or database function within your business give us a call, we may be able to help.

 

MOVE TEXT WITHOUT COPY & PASTE

Have you been using the Cut-Paste (Ctrl-x Ctrl-v) function to move text from one location to another within a Word document. Here's an alternative:-

  1. Highlight the block of text you want to move
  2. Press F2
  3. Place the cursor at the spot where you wish to move that text
  4. Press Enter and the selection will be moved.
 

 

MORE SPACE FOR WORD and ALL OFFICE PROGRAMS

If you find that the ribbon takes up too much space use [Ctrl] + [F1] to toggle the ribbon on and off.



AUTOSUM KEYBOARD SHORTCUT

You will probably use Excel's AutoSum button ∑ for quickly summing values but did you know there is a keyboard shortcut that performs this same function? It is great for times when you'd prefer to use your keyboard.

Simply press the Alt key plus the equal sign (i.e. Alt + =)

This shortcut will save lots of time trying to find the button with the mouse.

 


 

DISAPPEARING TABLES

Wanting a Word table but also need to see where the borders are but don't want them printing?

  1. Insert table and adjust with borders on
  2. Select table
  3. Go to Layout tab
  4. On table section click View Gridlines

Now if you remove the borders you will see the Gridlines (Grey dotted lines) where the borders were. When you print the gridlines will not be printed.

 

 

 

 

 

ZOOM ON iPHONE/iPAD

From your iPhone home screen, tap Settings, General, Accessibility, Zoom, then switch Zoom to "On."

  • Now double-tap the screen with three fingers at once, and well ... zoom!
  • Want to pan around your zoomed-in iPhone display? Just swipe around as your normally would, except using three fingertips at once rather than just one.
  • You can also adjust the magnification level by double-tapping and holding with three fingers (it's a "tap" and a "hold," not a double-tap and then a hold), then dragging your fingertips up (to increase the zoom level) or down (to decrease the magnification).

Had enough? Double-tap the screen with three fingers again to make it jump back to the normal view. 

     

CLEAR A SPREADSHEET BUT LEAVE THE FORMULAS

  1. Select spreadsheet area to be cleared or [Ctrl] + [A] to select all
  2. Press [f5] to show Goto window
  3. Press Special Button to open Go To Special
  4. Select Constants and just Numbers to highlight Numbers or Numbers and Text to highlight both (neither will select formulas)
  5. Press your Delete button on your keyboard

This will delete all Numbers or Numbers & Text but leave formulas intact.


   

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.

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
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.
Join Our Mailing List!