microsoft excel training

microsoft excel training - Excel intro

Resolved · Low Priority · Version Standard

Excel intro

Paul has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Paul [2 posts] (2008 Jan 24 Thu, 09:31) Reply

How do you create a pie 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 5 Fri	Bayswater	0	FULL
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	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel intro

by - trainer David gold contributer [428 posts] (2008 Jan 30 Wed, 15:36) Reply

Paul,

To create a pie chart all you need to do is select the data that you want to chart and then click the chart wizard icon, select pie chart. You will then have to choose which type of pie chart that you want and click next. You follow the instructions through on the screen and enter and titles etc.

Hope this helps
David

· Advanced level training: Microsoft Excel and the Web
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Basic Excel Training
· Microsoft Excel Training Course
· Microsoft Excel Training: Essential for Today's Employees

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips

Rate this page: