Microsoft Excel is a versatile and extensively used spreadsheet program that provides a wealth of tools to assist users in organizing, analyzing, and visualizing data. Understanding the fundamentals of Excel is critical for novices in order to navigate and use …
Lesson#210: 5 Essential Excel Features Every Beginner Should Know Read more →
Dear all, again welcome to my site with another simple trick discussion. Here I am going to discuss how to hide data without hiding cells or deleting data. Let’s assume that you are having a simple table like this. There …
Lesson#151: How to hide data without hiding or deleting cells Read more →
OK, I am having a sheet here which calculates the age when the birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also …
Lesson#121: How to make some cells unprotected when protecting a sheet 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 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 →
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. …