GANTT CHART MAKER EXCEL TEMPLATE V1 - Indzara

Transcription

GANTT CHART MAKER EXCEL TEMPLATEV1PURPOSEGantt chart is the most common methodused to visualize project schedule. TheGantt Chart Maker Excel template allowsone to easily create Gantt charts instantly. Instant Gantt charts saves timeFlexibility to filter tasksColor them to fit your needsAll within Excel and easy to extendVery easy to learn and useREQUIREMENTS Microsoft Excel for Windows (2010,2013, 2016)MORE -template/SITE: indzara.comwww.indzara.comGantt Chart Maker Excel Template v11

GANTT CHART MAKER EXCEL TEMPLATE V1CONTROL PANELLEGENDSCROLL TOMOVE DAYSPROJECTNOTESSCROLLTO SEEMORETASKSWEEKENDHOLIDAYTODAYWBSTasks% COMPLETEwww.indzara.comGantt Chart Maker Excel Template v12

FEATURES: Applicable to projects of any size (that span across days, weeks, months or years) Create two levels of Tasks (WBS - Summary tasks and subtasks)o Summary Tasks’ dates are automatically calculated based on subtasks Multiple views (Plan, Actual, Actual vs Plan or Current Status) Simple and easy data entryo Automatic End Date calculationo Exclude Holidays & Weekends as non-working dayso Enter Actual dates only where there is variance Option to use automatically calculated % of Work Days complete or user input Control which tasks are displayedo Filter to select tasks easilyo Show only summary level tasks or Milestoneso Show tasks of one resourceo Incomplete tasks, and delayed tasks are automatically identified Visualizationo Assign each task a color. Assign each resource a color.o 10 colors available (4 of them are theme based)o Milestone markers are automatically created Outputo Ready to print. Or export as PDF and share Extension possibilitieso 52 periods (days/weeks/months/years) are shown at a time. Can be extended.o View 40 tasks at a time by default. Can be extended.www.indzara.comGantt Chart Maker Excel Template v13

CHOOSE TO VIEW GANTT CHART FOR 52 DAYS/WEEKS /MONTHS/YEARSChoose to viewGantt Chart for52 days/weeks/months/years.www.indzara.comGantt Chart Maker Excel Template v14

CHOOSE TO VIEW PLAN / ACTUAL / ACTUAL VS PLAN / CURRENT STATUSPLANACTUAL VS PLANACTUALCURRENT STATUSFour differentviewswww.indzara.comGantt Chart Maker Excel Template v15

MORE OPTIONSFILTER TASKSwww.indzara.comCHOOSE COLORSGantt Chart Maker Excel Template v1ACCOUNT FORWEEKENDS/HOLIDAYS6

www.indzara.comGantt Chart Maker Excel Template v17

www.indzara.comGantt Chart Maker Excel Template v18

LIMITATIONS Duration is specified in days (not hours or minutes) Predecessors are not automatically handled. User will input start dates. Resource availability is not considered. Feature available in Project Planner (Advanced)www.indzara.comGantt Chart Maker Excel Template v19

MORE DETAILSProduct .indzara.comGantt Chart Maker Excel Template v110

www.indzara.com Gantt Chart Maker Excel Template v1 1 GANTT CHART MAKER EXCEL TEMPLATE V1 PURPOSE Gantt chart is the most common method used to visualize project schedule. The Gantt Chart Maker Excel template allows one to easily create Gantt charts instantly. Instant Gantt charts saves time Flexibility to filter tasks