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.
Main Menus : All Tricks & Tips Access Tricks & Tips More Excel : Shortcuts Charts/pictures 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's Quick Course Finder
Welcome to Activia's easy-to-use Quick Course Finder Just click on any heading (in black) or section (in blue) to go straight to where you need to be Or click here to close the Quick Course Finder and return to the page you were on
Staff Development Training Sales & Business Development training • Sales Training • Presentation Skills • Telephone Sales Training • Negotiation Skills • Sales Management Employee Skills training • Assertiveness Training • Communication Skills • Customer Service • Influencing Relationships • Presentation Skills • Time Management • Receptionist Skills • Telephone Techniques HR training • Interviewing Skills • Stress Management • HR for Non HR Managers • Train the Trainer (1 day) • Train the Trainer (2 days) MasterClasses Workshops training • Achieving Team Success • A Customer Mentality • Performance Coaching • Leading Change • Positive Relationships • Outstanding Performance	Professional & Management Training Management Skills training • Project Management • Change Management • Management Skills (1 day) • Management Skills (2 days) • Management Skills (3 days) • Decision Making Managing Staff training • Staff Performance • Supervisor Training • Coaching Skills • Motivating Staff • Building Relationships • Team Building & Working • Managing Discipline • Conflict Management • Facilitation Skills • Delegation Skills Accounts & Finance training • Sage Accounts • Excel for Accounts: Intro • Excel for Accounts: Adv • Finance for Managers • Business Accounting • Budgeting • Business Finance • Finance Management: Intro • Finance Management: Adv Mentoring training • Management Mentoring • Sales Staff Mentoring	IT Applications Training Microsoft training • Access Training • Excel Training • FrontPage Training • Office Training • Outlook Training • PowerPoint Training • Project Training • Publisher Training • Visio Training • Windows Training • Word Training Adobe training • Adobe Acrobat Training • Adobe Photoshop Training • Adobe Illustrator Training • Adobe InDesign Training Sage training • Sage Line 50 Training • Sage Payroll Training Macromedia training • DreamWeaver Training • Flash Training • FireWorks Training Lotus training • Lotus Notes Training • Lotus Domino Training Crystal Reports training • Reports 9.0 Introduction • Reports 9.0 Advanced • Reports 10.0 Introduction • Reports 10.0 Advanced • Reports XI Introduction • Reports XI Advanced Web Design training • HTML Introduction • HTML Advanced • JavaScript Introduction • JavaScript : Advanced • Effective Web Design
[ Close Quick Course Finder ]

Microsoft Excel Tricks and Tips

Easy ways to get more from Excel

3 : Terminology

What is an Absolute Address?

What is a Field?

What does a Goal Seek do?

What are Comparison Operators?

What are Pivot Tables?

How do I use Auto Fill?

How do I set up a Worksheet Template?

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

How do I insert Subtotals?

Why Activia for Microsoft Excel Training Courses ?

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

Microsoft Excel Training

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

West London

London Heathrow

Birmingham

Slough

Aylesbury

Milton Keynes

In House Microsoft Excel Training Courses across the UK

Activia's Quick Course Finder

Staff Development Training

MasterClasses

Professional & Management Training

IT Applications Training