Tag: DATA VALIDATION
Lesson#88: How to make a Salary slip format from Employee Database
So, my friend, I will here discuss an important lesson which is really required for office …
Lesson#88: How to make a Salary slip format from Employee Database Read more →
Lesson#83: How to add a drop-down in an excel sheet
I always hear a common question from beginner Excel users “How to make a drop-down menu …
Lesson#83: How to add a drop-down in an excel sheet Read more →
Lesson#52: Let’s check your lifeline with Excel
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …
Lesson#48: Graphical 20X20 multiplication table
In this post, I will make a graphical 20X20 multiplication table and show the process of …
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet
Showing a random example worksheet where I have used conditional formatting and color formatting. Now I …
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet Read more →
Lesson#31: Current dynamic calendar for whole Year
This post is a continuation of one of my previous posts Lesson#27: How to make a …
Lesson#31: Current dynamic calendar for whole Year Read more →
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 …
Lesson#27: How to make a calendar in excel without VBA Read more →
Lesson#20: Making an age calculator in excel with DATEDIF function
In this post, we will talk about the formula DATEDIF(). This the formula is used to …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more →
Lesson #13: Make a perfect SIP Planner in Excel
Hello friends! in this post I will give you an example of making a SIP planner …