excel 甘特图模板

1、Website Development Project ScheduleCompany NameProject Lead: NameProject Start Date: 1/3/2011 (Monday)Todays Date: 11/13/2012 (Tuesday)4203/01/2011WBSTaskLeadPredecessorsStartEndWork Days% CompleteDuration (Days)Days CompleteDays Remaining03 - Jan - 1110 - Jan - 1117 - Jan - 1124 - Jan - 1131 - Jan

2、 - 1107 - Feb - 1114 - Feb - 1121 - Feb - 1128 - Feb - 1107 - Mar - 1114 - Mar - 1121 - Mar - 1128 - Mar - 1104 - Apr - 1111 - Apr - 1118 - Apr - 1125 - Apr - 1102 - May - 1109 - May - 1116 - May - 1123 - May - 1130 - May - 1106 - Jun - 1113 - Jun - 1120 - Jun - 1127 - Jun - 1104 - Jul - 1111 - Jul

3、- 1118 - Jul - 1125 - Jul - 1101 - Aug - 1108 - Aug - 1115 - Aug - 1122 - Aug - 111Inception PhaseMikeMon 1/03/11Mon 1/24/11160%220221.1Client Planning MeetingMon 1/03/11Mon 1/03/1110%1011.2Website Requirements Survey1.1Tue 1/04/11Thu 1/06/1130%3031.3Analyze Survey1.2Fri 1/07/11Mon 1/10/1120%4041.4S

4、toryboard Concept1.3Tue 1/11/11Wed 1/12/1120%2021.5Concept Approval1.4Thu 1/13/11Fri 1/14/1120%2021.6Risk Analysis1.5Tue 1/18/11Wed 1/19/1120%2021.7Compeleted Contract1.6Thu 1/20/11Thu 1/20/1110%1011.8Kick-off Meeting1.7Fri 1/21/11Mon 1/24/1120%4041.9Insert Rows above this one, then Hide or Delete t

5、his row2Requirements PhaseSallyTue 1/25/11Wed 2/09/11120%160162.1Customer Requirements (Draft)1Tue 1/25/11Thu 1/27/1130%3032.2Define scope2.1Fri 1/28/11Fri 1/28/1110%1012.3Design Branding (Look and Feel)2.2Mon 1/31/11Tue 2/01/1120%2022.4SEO Strategy2.2Mon 1/31/11Tue 2/01/1120%2022.5Define Keyword Li

6、st2.4Wed 2/02/11Wed 2/02/1110%1012.6Define Technical Requirements2.2Mon 1/31/11Tue 2/01/1120%2022.7Identify Hardware Requirements2.6Wed 2/02/11Thu 2/03/1120%2022.8Final Requirements2.52.7Fri 2/04/11Mon 2/07/1120%4042.9Phase Review2.8Tue 2/08/11Wed 2/09/1120%2022.10Insert Rows above this one, then Hi

7、de or Delete this row3Specifications PhaseSallyThu 2/10/11Fri 3/11/11220%300303.1Define Site Map2Thu 2/10/11Mon 2/14/1130%5053.2Define Page List3.1Tue 2/15/11Wed 2/16/1120%2023.3Create page layouts3.2Thu 2/17/11Tue 2/22/1130%6063.4Define graphic lists3.3Wed 2/23/11Thu 2/24/1120%2023.5UI Design Proto

8、types3.4Fri 2/25/11Tue 3/01/1130%5053.6Define Form Requirements3.5Wed 3/02/11Fri 3/04/1130%3033.7Create Production Guide3.6Mon 3/07/11Wed 3/09/1130%3033.8Phase Review3.7Thu 3/10/11Fri 3/11/1120%2023.9Insert Rows above this one, then Hide or Delete this row4Construction (Development)BillMon 3/14/11Tu

9、e 4/05/11170%230234.1Create page templates3Mon 3/14/11Thu 3/17/1140%4044.2Setup Database3Mon 3/14/11Fri 3/18/1150%5054.3Setup CMS3Mon 3/14/11Tue 3/15/1120%2024.4Custom programming4.14.24.3Mon 3/21/11Fri 3/25/1150%5054.5Validation Testing4.4Mon 3/28/11Wed 3/30/1130%3034.6Refinement of programming4.5T

10、hu 3/31/11Fri 4/01/1120%2024.7Phase Review4.6Mon 4/04/11Tue 4/05/1120%2024.8Insert Rows above this one, then Hide or Delete this row5Content Population & TestingBillWed 4/06/11Thu 4/21/11120%160165.1Create page content4Wed 4/06/11Fri 4/08/1130%3035.2Create additional custom graphics4Wed 4/06/11F

11、ri 4/08/1130%3035.3Integration Testing5.1Mon 4/11/11Wed 4/13/1130%3035.4User Testing5.3Thu 4/14/11Tue 4/19/1140%6065.5Phase Review5.4Wed 4/20/11Thu 4/21/1120%2025.6Insert Rows above this one, then Hide or Delete this row6LaunchMikeFri 4/22/11Tue 5/17/11180%260266.1Migrate to Production Environment5F

12、ri 4/22/11Tue 4/26/1130%5056.2User Training6.1Wed 4/27/11Thu 4/28/1120%202WBSTaskLeadPredecessorsStartEndWork Days% CompleteDuration (Days)Days CompleteDays Remaining03 - Jan - 1110 - Jan - 1117 - Jan - 1124 - Jan - 1131 - Jan - 1107 - Feb - 1114 - Feb - 1121 - Feb - 1128 - Feb - 1107 - Mar - 1114 -

13、 Mar - 1121 - Mar - 1128 - Mar - 1104 - Apr - 1111 - Apr - 1118 - Apr - 1125 - Apr - 1102 - May - 1109 - May - 1116 - May - 1123 - May - 1130 - May - 1106 - Jun - 1113 - Jun - 1120 - Jun - 1127 - Jun - 1104 - Jul - 1111 - Jul - 1118 - Jul - 1125 - Jul - 1101 - Aug - 1108 - Aug - 1115 - Aug - 1122 -

14、Aug - 116.3Go Live (Turn on site)6.2Fri 4/29/11Mon 5/02/1120%4046.4External Promotion6.3Tue 5/03/11Wed 5/04/1120%2026.5On Going Support6.4Thu 5/05/11Wed 5/11/1150%7076.6Post Go Live Analysis6.5Thu 5/12/11Fri 5/13/1120%2026.7Post Go Live Review6.6Mon 5/16/11Tue 5/17/1120%2026.8Insert Rows above this

15、one, then Hide or Delete this rowWebsite Development Project ScheduleCompany NameProject Lead: NameProject Start Date: 1/3/2011 (Monday)Todays Date: 11/13/2012 (Tuesday)4203/01/2011WBSTaskLeadPredecessorsStartEndWork Days% CompleteDuration (Days)Days CompleteDays Remaining03 - Jan - 1110 - Jan - 111

16、7 - Jan - 1124 - Jan - 1131 - Jan - 1107 - Feb - 1114 - Feb - 1121 - Feb - 1128 - Feb - 1107 - Mar - 1114 - Mar - 1121 - Mar - 1128 - Mar - 1104 - Apr - 1111 - Apr - 1118 - Apr - 1125 - Apr - 1102 - May - 1109 - May - 1116 - May - 1123 - May - 1130 - May - 1106 - Jun - 1113 - Jun - 1120 - Jun - 1127

17、 - Jun - 1104 - Jul - 1111 - Jul - 1118 - Jul - 1125 - Jul - 1101 - Aug - 1108 - Aug - 1115 - Aug - 1122 - Aug - 1129 - Aug - 1105 - Sep - 1112 - Sep - 1119 - Sep - 1126 - Sep - 1103 - Oct - 1110 - Oct - 1117 - Oct - 1124 - Oct - 1131 - Oct - 1107 - Nov - 1114 - Nov - 1121 - Nov - 1128 - Nov - 111In

18、ception PhaseMikeMon 1/03/11Mon 1/24/11160%220221.1Client Planning MeetingMon 1/03/11Mon 1/03/1110%1011.2Website Requirements Survey1.1Tue 1/04/11Thu 1/06/1130%3031.3Analyze Survey1.2Fri 1/07/11Mon 1/10/1120%4041.4Storyboard Concept1.3Tue 1/11/11Wed 1/12/1120%2021.5Concept Approval1.4Thu 1/13/11Fri

19、1/14/1120%2021.6Risk Analysis1.5Tue 1/18/11Wed 1/19/1120%2021.7Compeleted Contract1.6Thu 1/20/11Thu 1/20/1110%1011.8Kick-off Meeting1.7Fri 1/21/11Mon 1/24/1120%4041.9Insert Rows above this one, then Hide or Delete this row2Requirements PhaseSallyTue 1/25/11Wed 2/09/11120%160162.1Customer Requirement

20、s (Draft)1Tue 1/25/11Thu 1/27/1130%3032.2Define scope2.1Fri 1/28/11Fri 1/28/1110%1012.3Design Branding (Look and Feel)2.2Mon 1/31/11Tue 2/01/1120%2022.4SEO Strategy2.2Mon 1/31/11Tue 2/01/1120%2022.5Define Keyword List2.4Wed 2/02/11Wed 2/02/1110%1012.6Define Technical Requirements2.2Mon 1/31/11Tue 2/

21、01/1120%2022.7Identify Hardware Requirements2.6Wed 2/02/11Thu 2/03/1120%2022.8Final Requirements2.52.7Fri 2/04/11Mon 2/07/1120%4042.9Phase Review2.8Tue 2/08/11Wed 2/09/1120%2022.10Insert Rows above this one, then Hide or Delete this row3Specifications PhaseSallyThu 2/10/11Fri 3/11/11220%300303.1Defi

22、ne Site Map2Thu 2/10/11Mon 2/14/1130%5053.2Define Page List3.1Tue 2/15/11Wed 2/16/1120%2023.3Create page layouts3.2Thu 2/17/11Tue 2/22/1130%6063.4Define graphic lists3.3Wed 2/23/11Thu 2/24/1120%2023.5UI Design Prototypes3.4Fri 2/25/11Tue 3/01/1130%5053.6Define Form Requirements3.5Wed 3/02/11Fri 3/04

23、/1130%3033.7Create Production Guide3.6Mon 3/07/11Wed 3/09/1130%3033.8Phase Review3.7Thu 3/10/11Fri 3/11/1120%2023.9Insert Rows above this one, then Hide or Delete this row4Construction (Development)BillMon 3/14/11Tue 4/05/11170%230234.1Create page templates3Mon 3/14/11Thu 3/17/1140%4044.2Setup Datab

24、ase3Mon 3/14/11Fri 3/18/1150%5054.3Setup CMS3Mon 3/14/11Tue 3/15/1120%2024.4Custom programming4.14.24.3Mon 3/21/11Fri 3/25/1150%5054.5Validation Testing4.4Mon 3/28/11Wed 3/30/1130%3034.6Refinement of programming4.5Thu 3/31/11Fri 4/01/1120%2024.7Phase Review4.6Mon 4/04/11Tue 4/05/1120%2024.8Insert Ro

25、ws above this one, then Hide or Delete this row5Content Population & TestingBillWed 4/06/11Thu 4/21/11120%160165.1Create page content4Wed 4/06/11Fri 4/08/1130%3035.2Create additional custom graphics4Wed 4/06/11Fri 4/08/1130%3035.3Integration Testing5.1Mon 4/11/11Wed 4/13/1130%3035.4User Testing5

26、.3Thu 4/14/11Tue 4/19/1140%6065.5Phase Review5.4Wed 4/20/11Thu 4/21/1120%2025.6Insert Rows above this one, then Hide or Delete this row6LaunchMikeFri 4/22/11Tue 5/17/11180%260266.1Migrate to Production Environment5Fri 4/22/11Tue 4/26/1130%5056.2User Training6.1Wed 4/27/11Thu 4/28/1120%202WBSTaskLead

27、PredecessorsStartEndWork Days% CompleteDuration (Days)Days CompleteDays Remaining03 - Jan - 1110 - Jan - 1117 - Jan - 1124 - Jan - 1131 - Jan - 1107 - Feb - 1114 - Feb - 1121 - Feb - 1128 - Feb - 1107 - Mar - 1114 - Mar - 1121 - Mar - 1128 - Mar - 1104 - Apr - 1111 - Apr - 1118 - Apr - 1125 - Apr -

28、1102 - May - 1109 - May - 1116 - May - 1123 - May - 1130 - May - 1106 - Jun - 1113 - Jun - 1120 - Jun - 1127 - Jun - 1104 - Jul - 1111 - Jul - 1118 - Jul - 1125 - Jul - 1101 - Aug - 1108 - Aug - 1115 - Aug - 1122 - Aug - 1129 - Aug - 1105 - Sep - 1112 - Sep - 1119 - Sep - 1126 - Sep - 1103 - Oct - 1

29、110 - Oct - 1117 - Oct - 1124 - Oct - 1131 - Oct - 1107 - Nov - 1114 - Nov - 1121 - Nov - 1128 - Nov - 116.3Go Live (Turn on site)6.2Fri 4/29/11Mon 5/02/1120%4046.4External Promotion6.3Tue 5/03/11Wed 5/04/1120%2026.5On Going Support6.4Thu 5/05/11Wed 5/11/1150%7076.6Post Go Live Analysis6.5Thu 5/12/1

30、1Fri 5/13/1120%2026.7Post Go Live Review6.6Mon 5/16/11Tue 5/17/1120%2026.8Insert Rows above this one, then Hide or Delete this rowWebsite Development Project ScheduleCompany NameProject Lead: NameProject Start Date: 1/3/2011 (Monday)Todays Date: 11/13/2012 (Tuesday)Display Week:1421 / 3 / 111 / 4 /

31、111 / 5 / 111 / 6 / 111 / 7 / 111 / 10 / 111 / 11 / 111 / 12 / 111 / 13 / 111 / 14 / 111 / 17 / 111 / 18 / 111 / 19 / 111 / 20 / 111 / 21 / 111 / 24 / 111 / 25 / 111 / 26 / 111 / 27 / 111 / 28 / 111 / 31 / 112 / 1 / 112 / 2 / 112 / 3 / 112 / 4 / 112 / 7 / 112 / 8 / 112 / 9 / 112 / 10 / 112 / 11 / 11

32、2 / 14 / 112 / 15 / 112 / 16 / 112 / 17 / 112 / 18 / 112 / 21 / 112 / 22 / 112 / 23 / 112 / 24 / 112 / 25 / 112 / 28 / 113 / 1 / 113 / 2 / 113 / 3 / 113 / 4 / 113 / 7 / 113 / 8 / 113 / 9 / 113 / 10 / 113 / 11 / 113 / 14 / 113 / 15 / 113 / 16 / 113 / 17 / 113 / 18 / 113 / 21 / 113 / 22 / 113 / 23 / 1

33、13 / 24 / 113 / 25 / 113 / 28 / 113 / 29 / 113 / 30 / 113 / 31 / 114 / 1 / 11Week 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12Week 131 / 3 / 111 / 10 / 111 / 17 / 111 / 24 / 111 / 31 / 112 / 7 / 112 / 14 / 112 / 21 / 112 / 28 / 113 / 7 / 113 / 14 / 113 / 21 / 113 / 28 / 11W

34、BSTaskLeadPredecessorsStartEndWorkDays%DoneCalDaysDaysDoneDaysLeftM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th FM Tu W Th F1Inception PhaseMikeMon 1/03/11Mon 1/24/11160%220221.1Client Planning MeetingMon 1/03/11Mon

35、 1/03/1110%1011.2Website Requirements Survey1.1Tue 1/04/11Thu 1/06/1130%3031.3Analyze Survey1.2Fri 1/07/11Mon 1/10/1120%4041.4Storyboard Concept1.3Tue 1/11/11Wed 1/12/1120%2021.5Concept Approval1.4Thu 1/13/11Fri 1/14/1120%2021.6Risk Analysis1.5Tue 1/18/11Wed 1/19/1120%2021.7Compeleted Contract1.6Thu

36、 1/20/11Thu 1/20/1110%1011.8Kick-off Meeting1.7Fri 1/21/11Mon 1/24/1120%4041.9Insert Rows above this one, then Hide or Delete this row2Requirements PhaseSallyTue 1/25/11Wed 2/09/11120%160162.1Customer Requirements (Draft)1Tue 1/25/11Thu 1/27/1130%3032.2Define scope2.1Fri 1/28/11Fri 1/28/1110%1012.3D

37、esign Branding (Look and Feel)2.2Mon 1/31/11Tue 2/01/1120%2022.4SEO Strategy2.2Mon 1/31/11Tue 2/01/1120%2022.5Define Keyword List2.4Wed 2/02/11Wed 2/02/1110%1012.6Define Technical Requirements2.2Mon 1/31/11Tue 2/01/1120%2022.7Identify Hardware Requirements2.6Wed 2/02/11Thu 2/03/1120%2022.8Final Requ

38、irements2.52.7Fri 2/04/11Mon 2/07/1120%4042.9Phase Review2.8Tue 2/08/11Wed 2/09/1120%2022.10Insert Rows above this one, then Hide or Delete this row3Specifications PhaseSallyThu 2/10/11Fri 3/11/11220%300303.1Define Site Map2Thu 2/10/11Mon 2/14/1130%5053.2Define Page List3.1Tue 2/15/11Wed 2/16/1120%2

39、023.3Create page layouts3.2Thu 2/17/11Tue 2/22/1130%6063.4Define graphic lists3.3Wed 2/23/11Thu 2/24/1120%2023.5UI Design Prototypes3.4Fri 2/25/11Tue 3/01/1130%5053.6Define Form Requirements3.5Wed 3/02/11Fri 3/04/1130%3033.7Create Production Guide3.6Mon 3/07/11Wed 3/09/1130%3033.8Phase Review3.7Thu

40、3/10/11Fri 3/11/1120%2023.9Insert Rows above this one, then Hide or Delete this row4Construction (Development)BillMon 3/14/11Tue 4/05/11170%230234.1Create page templates3Mon 3/14/11Thu 3/17/1140%4044.2Setup Database3Mon 3/14/11Fri 3/18/1150%5054.3Setup CMS3Mon 3/14/11Tue 3/15/1120%2024.4Custom progr

41、amming4.14.24.3Mon 3/21/11Fri 3/25/1150%5054.5Validation Testing4.4Mon 3/28/11Wed 3/30/1130%3034.6Refinement of programming4.5Thu 3/31/11Fri 4/01/1120%2024.7Phase Review4.6Mon 4/04/11Tue 4/05/1120%2024.8Insert Rows above this one, then Hide or Delete this row5Content Population & TestingBillWed

42、4/06/11Thu 4/21/11120%160165.1Create page content4Wed 4/06/11Fri 4/08/1130%3035.2Create additional custom graphics4Wed 4/06/11Fri 4/08/1130%3035.3Integration Testing5.1Mon 4/11/11Wed 4/13/1130%3035.4User Testing5.3Thu 4/14/11Tue 4/19/1140%6065.5Phase Review5.4Wed 4/20/11Thu 4/21/1120%2025.6Insert Ro

43、ws above this one, then Hide or Delete this row6LaunchMikeFri 4/22/11Tue 5/17/11180%260266.1Migrate to ProductionEnvironment5Fri 4/22/11Tue 4/26/1130%5056.2User Training6.1Wed 4/27/11Thu 4/28/1120%2026.3Go Live (Turn on site)6.2Fri 4/29/11Mon 5/02/1120%4046.4External Promotion6.3Tue 5/03/11Wed 5/04/

44、1120%2026.5On Going Support6.4Thu 5/05/11Wed 5/11/1150%7076.6Post Go Live Analysis6.5Thu 5/12/11Fri 5/13/1120%2026.7Post Go Live Review6.6Mon 5/16/11Tue 5/17/1120%2026.8Insert Rows above this one, then Hide or Delete this rowHolidays to Exclude from Work DaysSee help (F1) on the NETWORKDAYS() and WO

45、RKDAY() functionsDateNon-Working Days25/12/2010 Christmas25/12/2011 Christmas25/12/2012 Christmas25/12/2013 Christmas25/12/2014 Christmas25/12/2015 Christmas25/12/2016 Christmas25/12/2017 Christmas25/12/2018 Christmas25/12/2019 Christmas25/12/2020 Christmas11/10/2010 Columbus Day10/10/2011 Columbus

46、Day8/10/2012 Columbus Day14/10/2013 Columbus Day13/10/2014 Columbus Day12/10/2015 Columbus Day10/10/2016 Columbus Day9/10/2017 Columbus Day8/10/2018 Columbus Day14/10/2019 Columbus Day12/10/2020 Columbus Day4/07/2010 Independence Day4/07/2011 Independence Day4/07/2012 Independence Day4/07/2013 Indep

47、endence Day4/07/2014 Independence Day4/07/2015 Independence Day4/07/2016 Independence Day4/07/2017 Independence Day4/07/2018 Independence Day4/07/2019 Independence Day4/07/2020 Independence Day6/09/2010 Labor Day5/09/2011 Labor Day3/09/2012 Labor Day2/09/2013 Labor Day1/09/2014 Labor Day7/09/2015 La

48、bor Day5/09/2016 Labor Day4/09/2017 Labor Day3/09/2018 Labor Day2/09/2019 Labor Day7/09/2020 Labor Day18/01/2010 M.L.King Jr. Day17/01/2011 M.L.King Jr. Day16/01/2012 M.L.King Jr. Day21/01/2013 M.L.King Jr. Day20/01/2014 M.L.King Jr. Day19/01/2015 M.L.King Jr. Day18/01/2016 M.L.King Jr. Day16/01/201

49、7 M.L.King Jr. Day15/01/2018 M.L.King Jr. Day21/01/2019 M.L.King Jr. Day20/01/2020 M.L.King Jr. Day31/05/2010 Memorial Day30/05/2011 Memorial Day28/05/2012 Memorial Day27/05/2013 Memorial Day26/05/2014 Memorial Day25/05/2015 Memorial Day30/05/2016 Memorial Day29/05/2017 Memorial Day28/05/2018 Memori

50、al Day27/05/2019 Memorial Day25/05/2020 Memorial Day1/01/2010 New Years Day1/01/2011 New Years Day1/01/2012 New Years Day1/01/2013 New Years Day1/01/2014 New Years Day1/01/2015 New Years Day1/01/2016 New Years Day1/01/2017 New Years Day1/01/2018 New Years Day1/01/2019 New Years Day1/01/2020 New Year

51、s Day15/02/2010 Presidents Day21/02/2011 Presidents Day20/02/2012 Presidents Day18/02/2013 Presidents Day17/02/2014 Presidents Day16/02/2015 Presidents Day15/02/2016 Presidents Day20/02/2017 Presidents Day19/02/2018 Presidents Day18/02/2019 Presidents Day17/02/2020 Presidents Day25/11/2010 Thanksgiv

52、ing24/11/2011 Thanksgiving22/11/2012 Thanksgiving28/11/2013 Thanksgiving27/11/2014 Thanksgiving26/11/2015 Thanksgiving24/11/2016 Thanksgiving23/11/2017 Thanksgiving22/11/2018 Thanksgiving28/11/2019 Thanksgiving26/11/2020 Thanksgiving11/11/2010 Veterans Day11/11/2011 Veterans Day11/11/2012 Veterans D

53、ay11/11/2013 Veterans Day11/11/2014 Veterans Day11/11/2015 Veterans Day11/11/2016 Veterans Day11/11/2017 Veterans Day11/11/2018 Veterans Day11/11/2019 Veterans Day11/11/2020 Veterans DayGantt Chart TemplateINSTRUCTIONSIf this page does not answer your questions, visit the following page:IntroThe Ver

54、tex42 Gantt Chart Template is designed to make creating a project schedule verysimple. You only need to know some very basic Excel techniques to make this gantt chartwork for you, such as how to copy and paste entire rows. Be sure to read the Getting StartedTips below.Cell Color KeyInput Cell : Indi

55、cates which set of inputs to useFormula to Edit : Indicates formulas you may need to verifyIncomplete Task : In the Gantt chart, indicates the incomplete portion of the taskCompleted Task : In the Gantt chart, indicates the completed portion of the taskGetting Started Tips - Input cells have a light

56、 green background. - Cells with a darker green background are formulas you may need to verify and edit.When you insert new rows or move rows around, you should double-check these formulas. - Bracketed Text is meant to be edited, like the project title and task descriptions. - Some of the labels incl

57、ude cell comments (marked with little red triangles) to provideextra help information. - The Project Start Date determines the first week shown in the gantt chart, and may also be referenced by some tasks, so be careful when changing it. - Instead of changing the Project Start Date, use the slider b

58、ar to adjust the range of datesshown in the gantt chart. - The red line in the gantt chart represents the date in the Todays Date cell.You can enter Todays Date manually or use the formula =TODAY()The range of dates displayed is limited by the number of columns in Excel 2003.Excel 2007 lets you incr

59、ease the number of columns. See the FAQ below. - To insert additional tasks, copy an exising row from the selection of Template Rows at the bottom of the worksheet. - This workbook uses a lot of conditional formatting. Look up conditional formatting in theExcel help system (F1) if you want to know h

60、ow it works. - Edit the Holidays worksheet to choose which dates you want to exclude from Work Days. - If you see # in a cell, widen the COLUMN to display the cell contents. - Backup your file regularly to avoid losing data! Excel files DO get corrupted occasionally.Using the Template Rows for Different Sets o