Here I will discuss a long topic about Excel Gantt chart making. I will show how I made my excel chart work like the ms project schedule by adding some basic features. Some basic features of the ms project which …
Lesson#107: How did I add MS Project features to the Excel project schedule Read more →
Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format. First I …
Lesson#87: How to make month wise auto-updating program schedule Read more →
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
This post is a continuation of one of my previous posts Lesson#27: How to make a calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
Lesson#31: Current dynamic calendar for whole Year Read more →
In this post, we will learn to make a calendar which will take input of month from 1 (JAN) to 12 (DEC) and year in numeric format and show the whole month calendar. 1st Step: Make a 2×2 table like …
Lesson#27: How to make a calendar in excel without VBA Read more →
In this post, we will talk about the formula DATEDIF(). This the formula is used to get the difference in days, months, or years between two dates. In excel we are unable to find any help with the formula but …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more →
In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function converts date, month, and year values into single-line date format. Let me show you an example. I have written DAY, MONTH, and YEAR for …
Lesson#15: Know about functions DATE, DAY, MONTH, YEAR Read more →