Microsoft Excel Tricks and Tips

Easy ways to get more from Excel



1: Shortcuts

What can I do to select a range of cells quickly?

You can quickly copy a range of cells by clicking the first cell of the range, holding the Shift key and clicking the last cell in the range. Excel will automatically select everything in between.

Is there a quick way to look at all my formulas on my spreadsheet?

There certainly is, touch CTRL/~ (tilde ~ keyboard character) This is an ON/OFF toggle – touch CTRL/~ again and it brings the results back and hides the formulas>

Is there a quick way to input names without using the capital lock button?

Yes! When you enter data always type it in lower case, to confirm press enter, the valid names are automatically converted into uppercase, verifying that you type them in correctly.

When I’m working with Excel I tend to have numerous workbooks open. How can I close them down swiftly?

There is a very easy way to close them all at the same time rather than closing them individually. Just hold down Shift and then choose File, Close All. Remember that there is no ‘close all’ command in the tool bar, it will only appear when you hold the Shift key down.

More Excel : Charts/pictures   Terminology   General

Activia, Regus House, 268 Bath Road, Slough, Berkshire   SL1 4DX
Telephone: 0845 230 6150 (local rate)
Microsoft Excel training courses UK   |   Why Activia
Copywriting for web sitesBook your accredited Microsoft Excel Training Courses with Activia

Why Activia for Microsoft Excel Training Courses ?

Microsoft Excel Training Courses in West London, Birmingham, Slough, London Heathrow, Aylesbury and Milton Keynes

Activia should be your first choice for training in Excel in the UK.   We provide you with a full range of classes for job-related Business Skills, HR & Supervision, Sales and Management Development as well as IT applications from Microsoft, MS Office, Sage, Adobe, Macromedia, Crystal Reports and Lotus. If you are looking for courses for Microsoft Excel, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Excel Training Courses at fiercely competitive prices.

Microsoft Excel Training

If your requirement is Microsoft Excel spreadsheet software training, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for classes for Microsoft Excel, Activia will provide more tailored, flexible and focused solutions, and this enables you to get the most from your budget using the minimum of resources.

Courses in London, the Midlands, Berkshire (Berks), Buckinghamshire (Bucks), Surrey, Middlesex and UK wide

We provide Microsoft Excel Training Courses courses all over the UK, with modern, fully equipped training centres in the following locations:

West London

Serving London, as well as areas like Brentford, Kew, Watford and Richmond.

London Heathrow

Serving Middlesex and Surrey, covering Uxbridge, Staines, Egham, Sunbury, Hounslow and Twickenham.

Birmingham

Serving Warwickshire and the Midlands, covering Solihull, Dudley and Wolverhampton as well as Coventry, Telford and Worcester.

Slough

Serving Berkshire and the Thames Valley, covering Slough, Reading, Windsor and Maidenhead as well as Bracknell, Newbury and Basingstoke.

Aylesbury

Serving Buckinghamshire, covering Aylesbury, High Wycombe and Hemel Hempstead, as well as Oxford, Bicester and Buckingham.

Milton Keynes

Also serving Buckinghamshire, covering Milton Keynes, Luton and Bedford, as well as Stevenage and Welwyn Garden City.

Our experienced, high quality trainers will deliver your training to the highest standards and with the maximum effect.

In House Microsoft Excel Training Courses across the UK

For in house delivery of Microsoft Excel Training, we have an established national UK network of trainers, as well as centres in London, Birmingham, Slough, London Heathrow Aylesbury and Milton Keynes, so you can be sure that your training in Excel will be delivered in a quality assured and cost effective manner.   For in-house Microsoft Excel spreadsheet software training, you need look no further than Activia.

[ Close ]

Activia for Microsoft Excel Training Courses

Activia Home page

Home

Activia courses

Courses

Activia prices

Prices

Course dates

Dates

Activia locations

Locations

Let's talk about quality assured, flexible Microsoft Excel Training Courses.
Call Activia to discuss your requirements for Microsoft Excel Training.