excel training in uk

excel training in uk - Chart

Resolved · Low Priority · Version Standard

Chart

Louise has attended:
Excel Advanced course

by - delegate Louise [2 posts] (2007 Sep 13 Thu, 09:45) Reply

how do you create a chart?

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: chart

by - trainer Katie gold contributer [214 posts] (2007 Sep 24 Mon, 13:10) Reply

Hi Louise,

Thank you for your question.

To create a chart:
1) Highlight the data - i.e. list of labels & numbers
2) Press F12 on your keyboard
3) Change Chart Option for: chart type / axis lables / background colour / legend box position...etc

Hope this helps.

Katie

RE: chart

by - delegate Louise [2 posts] (2007 Sep 24 Mon, 17:27) Reply

Thanks, but I think F12 is 'save as'?

RE: chart

by - trainer Katie gold contributer [214 posts] (2007 Sep 25 Tue, 09:16) Reply

Sorry I meant F11.

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Course
· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Rate this page: