Excel is one of the most useful and underrated pieces of software out there. Yes, it might not have the glitz and glamor of some of the newer programs on the market, but trust me when I say that Excel …
Lesson#166: Why Microsoft Excel Is Still the Most Useful Software? Read more »
Hello friends! I hope you all are very well. Today we shall go a little outside of Microsoft Excel. Don’t be disappointed, and I am talking about the brother of Excel, Mr. Word. Yes, I am going to discuss the …
Lesson#164: How to easily create a mail merge in Word from Excel – step by step Read more »
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 »
Here in this post, I will show you how to hyperlink all files and folders in the worksheet within a minute. This can be done very easily. Often we need to make the summary of soft copies and link those …
Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more »
So, my friend, I will here discuss an important lesson which is really required for office people. That is how to make a salary slip from an employee database. This is not about salary slips only, we can make many …
Lesson#88: How to make a Salary slip format from Employee Database 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 »
Here I have got a case where my colleague was working with a project schedule. He had a schedule with a start date, end date, and scope and he had to break up the scope month-wise. With a long schedule, …
Lesson#77: Scope the breakup program schedule and explain the formula Read more »
Hello friend. In this post, I will show how to get a new fresh formatted sheet every time when you click the button in the excel sheet. That thing is exactly needed for making invoices in a store, shop, or …
Lesson#75: Get a new fresh formatted sheet every time when you click the button Read more »
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more »
Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …
Lesson#49: Make a parent Gantt chart from a data table Read more »