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 →
Select the entire sheet by clicking on the most left upper corner of the sheet or …
Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once Read more →
Hi, friend today I will show you how to make an automatically updating Gantt chart without …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →
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 →
LEN is a function that is used for finding out the number of characters in a …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more →
In this lesson, we will learn a method to convert digits into words. I will use …
Lesson#19: How to convert digit into word in excel Read more →