Excel

The UK's most regular instructor-led training courses.
Training information: excel+training · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Rita has attended:
Excel Introduction course

by - delegate Rita [1 post] (2008 Mar 17 Mon, 16:57) Reply

What is the short cut for creating a chart?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel

by - trainer Pete platinum contributer [864 posts] (2008 Mar 18 Tue, 09:06) Reply

Hi Rita, Thank you for your post, Welcome to the Forum, In answer to your question, the Sortcut key for creating a chart is the F11 (Function 11) key pressed after selecting a range of cells (dont forget to include headings etc). This will create a basic chart on a new Worksheet, you can then format the chart or adjust it to your requirements. If you wish to place the chart on the same sheet as your data, you will have to use the wizard which can be activated by clicking the chart button on the Standard Toolbar. I hope that helps, best regards Pete.

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Advanced Excel Training - takes you to the next level
· Microsoft Excel Training: Essential for Today's Employees
· MS Excel: Excel At Making The Most Of Your Christmas
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Rate this page: