Creating a Gantt Chart in Excel

Cam't afford fancy software for project scheduling? Try using Excel.

The image below is the end result we will achieve.

In this example, we took each activity and provided a sideways bar to visually show when that activity occurred within the total project. 

To accomplish this we will be using some logic functions as well as conditional formatting.

The project example we are going to use is below:

To read the whole article please click here....

Use Data Validation to check for Duplicate Entries

If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data.

To read more, please  click here.