Software Example

-

As a test of Excel's capabilities, I decided to create a Gantt Chart and in this post I will try to present the most important functions I used and the final result. This is an update to my Gantt Chart from previous posts, so from now on I will be using it. 



The first thing I have entered is the starting data, in the picture it shows the starting data on the left and I start to create a calendar using a formula that makes each week start from Monday which makes it easier to enter the data.




I continue to create months and years



I now format the cells and create tables to make everything look clear.




I am now starting to add data to the cells, formatting the appearance in such a way that everything looks as good as possible to me, so that subsequent work with the Gantt Chart is quick and easy.



Another formula I have used is to calculate in how many days an activity has been performed, and if the start and end cells are empty so that nothing appears.






I have now created a list of choices for the status, and changed the conditional formatting so that when Blocked is selected, the cell is painted red.



I have now created a diamond-shaped milestone to show a deadline or an already completed project




In this move, I am adding a formula that will show today's day in the calendar.



I have added some more forms to the conditional formatting to make excel mark completed tasks with a different colour, to show in dark blue what is the current percentage of the task and in light blue how much time we have given to complete the task. And this is the end of the Gantt Chart: 

(Because of the scaling, this photo doesn't look very good. It looks much better on a computer screen.)







The whole creation process was made possible by David McLachla (2022), thanks to whom I learned to work in excel. A detailed tutorial on how to create a similar Gantt Chart can be found in the references. 



References

McLachlan, D. (2022) How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!). 28 February. Available at: https://youtu.be/tuQpGzL_14g (Accessed: 30 November 2022)

Comments

Post a Comment

Popular posts from this blog

Initial Project Plan (Gantt Chart)

-
Image
(Office Timeline. 2022)      This is a Gantt Chart, i've used https://www.officetimeline.com/ to create it. The Gantt Chart is useful for planning, for example, projects or ro admaps. In the picture shown above, there is an unfinished plan for this semester. You can see on it the amount of time I have planned to write each post. After publishing all the posts presenting the milestone I have placed, it signifies the achievement of a certain goal.  In the near future, I plan to do all the planning for this semester. I will publish it separately in this post so that you can see the different stages of creating the Gantt Chart.
Read more

Major Project Theme

-
Database      A database is a structured set of data usually stored on a computer. Databases can contain all sorts of information, such as transaction histories, customer data and simpler data such as age, names, text, images or pdf files. Therefore, data is everything that can be processed mentally and by computer. It is designed to simplify access to and management of data (Lutkevich & Hughes, 2021).The most important feature of data is its usability, that is the possibility of using it. The database usually controls Database Management Systems (DBMS) (Bhojaraju & Koganurmath, 2003). Simple databases have only one or a few tables, while more complex databases have thousands of tables.  According to Lutkevich and Hughes (2021), there are many types of Database, for example  : Relational - This database type defines relations in the database in the form of tables. It is the most common type of database and ...
Read more

Software Functionality

-
Image
Formula bar is used to enter commands or to add and edit content. Ribbon is a set of commands to make the user's job easier. It is divided into sections, each containing the most useful commands.  Tabs are the Ribbons category and other options such as Help or File where you can save or create a new sheet. Name box and selected cell is the Cell that is currently chosen.  Columns and rows are letters in the case of columns and numbers in the case of rows, thanks to which each cell has an individual symbol. Sheet tabs allow you to navigate and create new sheets.
Read more