EXCEL PROJECT

CREATION OF GANTT CHART WITH THE USE OF MICROSOFT EXCEL

WHAT IS GANTT CHART?

A Gantt chart is a diagram which is used in preparation of task or project. It helps show the starting date and the finishing date and as well shows the duration of the project or task in a diagram form.

Steps to create a Gantt chart;

® Step 1÷ arrange your project or task name, date in which the project is to start and end in different cells/ rows.

Table

® Step 2÷ use the simple formula in order to get the duration.

Start Date- End Date= Duration

Table 2

Table 3

Step 3÷ copy and paste the task name, start date and duration below the first table this is because we will not be needing the end date any more.

®
Step 4÷ highlight start date then go to insert and click on bar pick the second option. [ Note-the bar chart is meant to appear with the start date.]

® Step 5÷ go to your chart and right click on it , some options will be displayed click on select data

® Step6÷ after clicking on select date you click on add. Another formant will be displayed. Click on the series name then highlight ‘DURATION’, the cells mane will appear on the series name

®
Steps 7÷click on series values then highlight the details below duration, the cells names will appear on the series values then click on ok.

This will be the outcome

® Step 8÷ right click on the chart again and select ‘Select Data’, click on start date then go to the axis labels and click on edit

A small axis window will open, highlight the content below task/project then click on ok.

This will be the outcome

® Step 9÷ right click on the blue part on the chart in order to highlight the entire order blue chart, a window will appear click on ‘FORMAT DATA SERIES’.

® Step10÷ a fresh window will appear, go to fill and click on NO FILL

This will be the outcome

® Step 11÷ click on the list of tasks in the left part of the chart, a format axis window will be opened. Select on categories in reverse order option under axis options then click on ok or close.

Out come

Step 12÷ below start date and right on any of the cell [ table]. A window will appear, click on format cell go to general and copy the number you see there.

Step 13÷ right click on any of the date above. A small window will appear click on format axis. Under axis option change major unit and minor unit to fixed then add the number you want for the date intervals. The change minimum to fix and then input the number you copied.

® Step 14÷ in order to remove excess space right click on any of the orange bar and select on format data series. In the format data series set separated to 100% and gap to 0% the click on close or ok.

This will be the outcome;

Steps 15÷ in order to make you work more attractive right click on the red bar then click on format data series. Go 3 D format and reset the width and height of top to be 6pt then click on close.

This will be the outcome;

ENDS OF GANTT CHART

CREATION OF MULTIPLICATION

TABLE

In order to create a multiplication table you need to make use of mixed formula. Mixed formula is an example of formulas which is used in Microsoft excel to solve mathematical problem. It makes use of dollar sign in the beginning and middle of the calculation e.g. = ($A2-B$2), = ($A1+C$3), = ($C2*B$2).

STEPS TO CREATE A MULITIPLICATION TABLE