Lesson#54: Charting practice with stock data
Let’s have some charting practice in excel. I have downloaded last month’s INFOSYS stock data from …
Excel Features
Lesson#53: Simple trick to color all the Sundays in the list of dates at once
This is a project schedule format where I have a list of dates and works. I …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once Read more →
Lesson#50: 4 most useful way to use Find and Replace
Press Ctrl+F to toggle the Find and Replace window>Replace Tab or go to Home Ribbon> Find …
Lesson#50: 4 most useful way to use Find and Replace Read more →
Lesson#49: Make a parent Gantt chart from a data table
Here I have to make a parent Gantt chart from a data table. It is a …
Lesson#49: Make a parent Gantt chart from a data table Read more →
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#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#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 →