Excel for Chartered Accountants
ABCAUS Excel Project Gantt Chart Maker
A Gantt Chart is a kind of bar graph which represents various elements, phases and activities of a given assignment or project. Gantt Charts illustrates the start dates and finish dates for each activity and project as a whole. For monitoring and scheduling any project, gantt charts are very helpful.
ABCAUS Excel based Gantt Chart utilizes the REPT Function of the Microsoft Excel to generate text graph.
The formula used to generate a text graph is :
= REPT (text, number_times)
“REPT” stands for Repeater. It basically repeats a certain string for a given number of times.
For Example:
1. =REPT(“X”,10) XXXXXXXXXX here “X” is repeated 10 times
2. =REPT(“CA”,5) CACACACACA here “CA” is repeated 5 times
3. =REPT(“I”,21) IIIIIIIIIIIIIIIIIIIII here “I” is repeated 21 times
4. =REPT(“5”,12) 555555555555 here “5” is repeated 12 times
Users are required to fill the Project Title which can be any activity including an audit program and sub divisions of activities along with their likely start and finish dates.
By default an audit program has been sub illustrated by dividing it into (a) Audit Planning, (b) Field Work, (c) Exit Discussion and (d) Audit Follow up. Each Audit Activity from (a) to (d) has been further segmented into various sub-activities forming its part. Start and Finish Dates should be provided against all these sub-activities . Start and finish dates of sub-activities can be interdependent or independent of other sub-activities.
Excel Gantt Chart gets prepared immediately after start and finish dates are fed.
ABCAUS Excel Gantt Chart Maker Download
Download Help File
