Microsoft Excel Tricks and Tips Easy ways to get more from Excel 2 : Charts & pictures
How do I copy one data series to another? Firstly, select the series on the first chart. Follow by clicking in the formula bar, select and copy the series formula. Click on the edge of the second chart to select the chart. Then click in the formula bar, paste and press enter. How do I Add pictures to bars in Excel charts? To add pictures in your bars you would simply, create a chart, go to the insert menu on your tool bar, selecting Object. Then click on clipart, decide what image you require and either double click on it or click on OK. Now that you are back in Excel select the picture and go to the edit menu and click on cut, alternatively press (Ctrl + X) on your key board, To get your picture to appear in the bar, just double-click on one of the bars and select Paste from the Edit menu alternatively press (Ctrl + V) on your keyboard. How do I move the Legend on my chart? To move the legend to a different location you must, right-click on the legend. Click Format Legend. Then click the Placement tab. From here you can choose the new location, Right, Left, Bottom, Corner, or Top. And lastly click on OK. Is there a way in which I can add some text to an existing chart? There certainly is. Open the View menu, select Toolbars and click on Drawing. Click the Text Box tool (The button which has an ‘A’ on it) and use your mouse to draw your text box. Finally type in the text you wish to use. Are there any shortcuts to creating a chart in Microsoft Excel 97? Yes! Once you have the data for your chart ready, select the data, and simply press F11. How do I change the colors on my Excel chart? You simply have to double-click on the chart, double click on one of the charts bars, select a new color from the menu and press enter! How do I get information about clipart in Excel? This is very simple. Click on Insert in the toolbar, Select picture, click on clipart, chose the Clip Art that you wish to use and click on it, Click on Clip properties, this will show you the file size and the name. If you ever want to use the file again record its name. Then use the Find feature that is located in the Edit menu in the toolbar to find the Clip Art. Then you simply click on the picture to insert it. How do I import an access table into Excel? Ok so, you’ve gathered the data, now you want to analyze it. Here's a quick way to copy an Access table into Excel. Firstly you go into the Access database window, click the table you want to export. Then, on the Standard toolbar, click Office Links. And finally Click Analyze It with Excel. Excel automatically opens and displays your table in a worksheet.
Main Menus : All Tricks & Tips Access Tricks & Tips More Excel : Shortcuts Terminology General

Activia, Regus House, 268 Bath Road, Slough, Berkshire SL1 4DX
Telephone: 0845 230 6150 (local rate)

MS Excel training courses UK | Why Activia
Copywriting for web sitesBook your accredited Microsoft Excel Courses with Activia

Why Activia for Microsoft Excel Courses ?

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

Activia should be your first choice for courses 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 Microsoft Excel classes, you will find that Activia offers a level of service that is unrivalled in the market, with quality, flexible 1 day Microsoft Excel Courses at fiercely competitive prices.

MS Excel Training Course

If your requirement is Microsoft Excel spreadsheet software courses, we can provide you with training courses from introduction to advanced level at highly competitive prices. You will find that for learning 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 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 Courses across the UK

For in house delivery of MS Excel Training Course, 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 courses in Excel will be delivered in a quality assured and cost effective manner. For in-house Microsoft Excel spreadsheet software courses, 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

2 : Charts & pictures

How do I copy one data series to another?

How do I Add pictures to bars in Excel charts?

How do I move the Legend on my chart?

Is there a way in which I can add some text to an existing chart?

Are there any shortcuts to creating a chart in Microsoft Excel 97?

How do I change the colors on my Excel chart?

How do I get information about clipart in Excel?

How do I import an access table into Excel?

Why Activia for Microsoft Excel Courses ?

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

MS Excel Training Course

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 Courses across the UK

Activia's Quick Course Finder

Staff Development Training

MasterClasses

Professional & Management Training

IT Applications Training