Lesson#107: How did I add MS Project features in Excel project schedule

Here I will discuss a long topic about Excel gantt chart making. I will show how I made my excel chart work like ms project schedule by adding some basic features. Some basic features of ms project which I added

Tagged with: , , , , , , , , , , , , ,

Lesson#87: How to make month wise auto updating program schedule

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating gantt chart without using excel chart It was a day wise scheduling format. Here I will show how to make a month wise scheduling format. First

Tagged with: , , , , , ,

Lesson#52: Let’s check your lifeline with Excel

Just a different exercise of excel. I have downloaded a list country wise average life expectancy by WHO. Lets check where are we in our lifeline by this sheet. Lets take an input of date of birth from user. I

Tagged with: , , , , , , , , , ,

Lesson#31: Current dynamic calendar for whole Year

This post is continuation for 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 the whole

Tagged with: , , , , , , , ,

Lesson#27: How to make a calendar in excel without VBA

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

Tagged with: , , , , , ,

Lesson#20: Making an age calculator in excel with DATEDIF function

In this post we will talk about a formula DATEDIF(). This formula is used to get the difference in days, months or years between two dates. In excel we are unable to find any help about the formula but it

Tagged with: , , , ,

Lesson#15: Know about functions DATE, DAY, MONTH, YEAR

In this post we will talk about the functions DATE, DAY, MONTH, YEAR. DATE function converts date, month and year value into single line date format. Let me show you an example. I have written DAY, MONTH, YEAR for indicating

Tagged with: , , ,