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 2007

replyReply Wed 25 May 2011, 16:25Delegate Joyce said...

Joyce has attended:
Excel Intermediate course

Excel

hwo to do chart

For upcoming training course dates see: Pricing & availability

replyReply Thu 26 May 2011, 20:52Trainer Anthony said...

RE: Excel

Hi Joyce, thanks for your query and welcome to the forum. The link to the dynamic chart I mentioned to you is:

http://chandoo.org/wp/2010/08/31/dynamic-chart-with-check-boxes/

It includes a free spreadsheet download of the chart in action. I hope it proves useful! Good luck in your new job and post any questions here if something arises which you're not familiar with.

All the best,

Anthony

Thu 2 Jun 2011: Automatically marked as resolved.

 

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

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

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