excel xp training

excel xp training - MS-Excel

Resolved · Low Priority · Version Standard

MS-Excel

Mohammad has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Mohammad [1 post] (2007 Sep 26 Wed, 10:09) Reply

How should I create/cut&paste a chart in Excel and how can we colour the fields ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: MS-Excel

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 1 Mon, 16:38) Reply

Hi Mohammad

Thank you for your question.

You can create a chart in Excel by:

1. Selecting the data you wish to have represented in the chart from your spreadsheet.
2. Click the Chart Wizard button on the standard toolbar at the top of your screen.
3. Follow through the chart wizard's 4 steps to create your chart.

Once the chart is complete, double-click on one of the charts bars whose colours you wish to change, then select Patterns, choose a colour and click OK.

Hope this helps.
Amanda

· Excel Macros for the Non-Programmer
· Tap the Power of Recorded Macros with MS Excel Courses
· Basic Excel Training
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Course

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Rate this page: