Excel Training Courses | Accredited Microsoft Excel Training For 2003, 2007 & 2010


Microsoft Excel Tricks and Tips

Easy ways to get more from Excel



3 : Terminology

What is an Absolute Address?

An absolute address in a formula refers to a specific cell location or range. It always points to the location of a specific cell, even if you copy it. Absolute addresses are created by adding a $ sign in front of each character in the cell address. For example, $C$8 always refers to cell C8.

What is a Field?

A field is a cell in a database that contains information. In Excel, fields appear in columns. For example, fields in a Customer database might include Name, Address, and Zip Code.

What does a Goal Seek do?

A Goal Seek adjusts the value of a specific cell until a formula that includes that cell reaches the result you want.

What are Comparison Operators?

Comparison operators are symbols used to specify criteria in searches and in formulas. The most common operators are, Equals, Greater than, less than, Greater than or equal to, less than or equal to, not equal to.

What are Pivot Tables?

PivotTables are interactive worksheet tables that allow you to summarize data with great flexibility. Their row and column headings can be adjusted to get different looks at original data.

How do I use Auto Fill?

To fill a series across columns or down rows type January or Jan in any cell and place your mouse pointer over the bottom right corner of the cell (Fill handle) until the mouser pointer changes to a small black cross. Click and drag down or across. This can also be done with Numbers, Weekdays, Quarters or any text that ends in a number e.g. Day1.

How do I set up a Worksheet Template?

To set a worksheet up for e.g. formatting, formulas etc then delete all other sheets in the Workbook. Now go to File>Save or Alt+F2 and select "Template (*.xlt)" from the "Save as Type". Type a name and click "Save" Now right click on the sheet tab and select Insert you should see your Template sheet.

How do I copy and transpose formulas without the reference changing?

That is simple, in cell A1 of sheet 2 put: =Sheet1!A1 now copy this down a max of 255 rows. Now with the formulas selected go to Edit>Replace and Replace = with #. Now copy, select cell B1, goes to Edit>Paste special and choose Transpose. Delete Column "A" and with Row 1 selected go to Edit>Replace and Replace # with =

How do I insert Subtotals?

To insert subtotals into your list automatically, click any cell in the list, and then click Subtotals on the data menu.

More Excel : Shortcuts   Charts/pictures   General  

Activia Training   Head Office:   Regus House   268 Bath Road   Slough SL1 4DX
Tel (local rate): 0845 230 6150 (sales)   0845 230 6159 (customer service)   0845 230 6157 (accounts)
[Please note that calls may be recorded for training or monitoring purposes]
[ Close ]

Why Activia for Microsoft Excel Training for 2003, 2007 and 2010 ?

Microsoft Excel Training for 2003, 2007 and 2010 in London, Birmingham, Manchester, Leeds, Bristol and the South East

Activia should be your first choice for training in Excel 2003, 2007 and 2010 in the UK.   We provide you with a full range of classes for Microsoft Excel Training for Office 2003, 2007 and 2010.
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 for 2003, 2007 and 2010 at fiercely competitive prices.

Microsoft Excel Training for Office 2003, 2007 and 2010

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 Office 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, Manchester, Bristol, Berkshire (Berks), Buckinghamshire (Bucks), Hampshire (Hants), Surrey and UK wide

We provide Microsoft Excel Training for Office 2003, 2007 and 2010 courses all over the UK, with modern, fully equipped training centres in the following locations:

Microsoft Excel Training for 2003, 2007 and 2010 in the City of London

Serving the City in Liverpool Street and Fleet Street, and the West End of London, as well as areas like Leytonstone, Walthamstow, Barking, Chingford and Ilford.

Microsoft Excel Training for 2003, 2007 and 2010 in West London

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

Microsoft Excel Training for Office 2003, 2007 and 2010 in the centre of Bristol

Serving South West England, covering Bristol, Avon and Bath and Radstock in Somerset as well as Clevedon and Chepstow.

Microsoft Excel Training for 2003, 2007 and 2010 in Birmingham City Centre

Serving Warwickshire and the Midlands, covering Birmingham, Walsall and Dudley as well as Wolverhampton, Solihull and Tamworth.

Microsoft Excel Training for Office 2003, 2007 and 2010 in Leeds

Serving Yorkshire and the North of England, covering Leeds, Bradford and Harrogate as well as Halifax, Wakefield and Castleford.

Microsoft Excel Training for 2003, 2007 and 2010 in Manchester

Serving Lancashire and the North West, covering Manchester, Salford, Stockport and Oldham as well as Bolton, Rochdale, Wigan, Warrington and Macclesfield.

Microsoft Excel Training for 2003, 2007 and 2010 in Reading

Serving Berkshire and the Thames Valley, covering Reading, Theale and Newbury as well as Henley and South Oxfordshire.

Microsoft Excel Training for 2003, 2007 and 2010 in Bracknell

Serving Berkshire and the Thames Valley, covering Bracknell, Wokingham and Ascot as well as Crowthrone, Camberley and Woking.

Microsoft Excel Training for Office 2003, 2007 and 2010 in Slough

Serving Berkshire and the Thames Valley, covering Slough, Windsor and Maidenhead as well as High Wycombe, Uxbridge and Watford.

Microsoft Excel Training for Office 2003, 2007 and 2010 in Milton Keynes

Serving Buckinghamshire, covering Milton Keynes, Aylesbury and Buckingham, as well as Luton, Bedford, Stevenage, St Albans and Welwyn Garden City.

Microsoft Excel Training for 2003, 2007 and 2010 in Basingstoke

Serving Hampshire, covering Basingstoke, as well as Farnham, Farnborough and Aldershot to the east, and Newbury, Andover and Winchester to the west.

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

In House Microsoft Excel Training for 2003, 2007 and 2010 Courses across the UK

For in house delivery of Microsoft Excel Training for Office 2003, 2007 and 2010, we have an established national UK network of trainers, as well as twelve centres in London, Birmingham, Manchester, Leeds, Bristol, Slough, Reading, Basingstoke, Bracknell and Milton Keynes. So you can be sure that your training in Excel 2003, 2007 and 2010 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 Home page

Home

Activia courses

Courses

Activia prices

Prices

Course dates

Dates

Activia locations

Locations

Private Individuals

Private Individuals

Let's talk about quality assured, flexible Microsoft Excel Training for 2003, 2007 and 2010.
Call Activia to discuss your requirements for Microsoft Excel Training for Office 2003, 2007 and 2010.