gantt charts
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 » Gantt Charts

Gantt Charts

resolvedResolved · Medium Priority · Version 2007

replyReply Thu 20 Oct 2011, 15:54Delegate Meghan said...

Meghan has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course

Gantt Charts

Hello! I'm looking to create a spreadsheet where I can add project management tasks, who is responsible for those tasks and status in the left columns. For each task, I'd like to have a start date and an end date. Once both dates are entered, I'd like excel to 'spit' them out into a Gantt Chart. This would enable me to quickly update my project management doc as well as my gantt chart, without having to spend time in a Word doc and then transferring the info to an excel doc.

Many thanks!

For upcoming training course dates see: Pricing & availability

replyReply Fri 21 Oct 2011, 14:12Trainer Simon said...

RE: Gantt Charts

Hi Meghan,

Thank you for your question.

Do you mean export your excel data to ms Project?

If so, you can use the Import Data Wizard within ms Project. In Project you do File, Open and change the Files of Type to Excel.

This will then start the Import Wizard.

I hope this helps.

Regards

Simon

 

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

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

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