excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

replyReply Tue 9 Sep 2008, 16:53Delegate Jason said...

Jason has attended:
Excel Intermediate course

Excel

How to create a chart

For upcoming training course dates see: Pricing & availability

replyReply Wed 10 Sep 2008, 14:36Trainer Amanda said...

RE: Excel

Hello Jason

Thank you for your question and welcome to the forum.

Here's how to create a chart:

1. Select the data you wish to have represented in the chart.
2. Click the Chart Wizard button (normally to the right of the sort descending button on the standard toolbar).
3. Follow through the four steps for creating your chart (chart type, data source, chart options, chart location).

You can also quickly make a column chart on it's own sheet by selecting the data and pressing the F11 key.

Amanda

 

Please browse our web site to find out more about
microsoft excel training day courses near kent and other Microsoft training courses.

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard