Lesson#48: Graphical 20X20 multiplication table
In this post, I will make a graphical 20X20 multiplication table and show the process of …
Lesson#47: Three ways to add a default word to any formula result in Excel
This post shows three ways to add any default word to the formula result. Here I …
Lesson#47: Three ways to add a default word to any formula result in Excel Read more →
Lesson#46: Count cells that contain any text or part of that text
This character “*” (Asterisk) is used to denote any text within a cell. 1. If you …
Lesson#46: Count cells that contain any text or part of that text Read more →
Lesson#45: “&” can replace the function CONCATENATE
If you know the use of the character “&” then it can replace the function CONCATENATE. …
Lesson#45: “&” can replace the function CONCATENATE Read more →
Lesson#44: A Simple trick to paste in reverse order
Sometimes it needs to paste a list in reverse then a simple trick should keep in …
Lesson#44: A Simple trick to paste in reverse order Read more →
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#42: Tricks to color alternate rows or columns of the entire sheet at once
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 →
Lesson#41: Combination of INDEX and MATCH function is better than any other lookup function
The INDEX function returns a value or reference of the cell at the intersection of a …
Lesson#40: OR function in Excel
OR function checks whether any of the arguments are TRUE then it returns TRUE or it will …
Lesson#39: Cool tricks to make automatically updating Gantt chart
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 →