Tag Archives for " Project Management "

45 Excel Timesheet Calculator Template [FREE DOWNLOAD]

Since I have started this blog, Excel timesheet calculator template has been one of the most requested ones. I often get queries on how to calculate regular hours and overtime hours of employees based on the ‘In time’ and ‘Out time’. I also couldn’t find a good Excel timesheet template online, so I decided to make one. […]

Continue reading >>

24 Calendar Integrated with a To Do List Template in Excel

Starting this month, I have decided to create and share an Excel Template every month. I already have a ready-to-download Excel Templates section on this blog, and I will keep on adding these new templates to this section. Before I come to this month’s template, I have a favour to ask. If you have any ideas […]

Continue reading >>

612 Free Excel Leave Tracker Template (Updated for 2017)

One of my teammates has the onus of creating a leave tracker template in Excel for the entire team to track vacations/holidays and planned leaves. Till now, she used a simple Excel Gantt chart but wanted something better. So I created this Excel Leave Tracker Template to make leave management easy and track monthly and […]

Continue reading >>

8 How to Create a Gantt Chart in Excel – Batman Style

Last week I wrote an article on how to create a Dynamic Pareto Chart in Excel. With the charting fever still riding high, today I will show you how to create a Gantt Chart in Excel. Gantt Chart is a simple yet powerful project management tool that can be used for creating a schedule or tracking the […]

Continue reading >>

23 Creating a Pareto Chart in Excel (Static & Dynamic)

Watch Video – How to Make a Pareto Chart in Excel Pareto Chart is based on the Pareto principle (also known as the 80/20 rule), which is a well-known concept in project management. According to this principle, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could […]

Continue reading >>