Let’s have some charting practice in excel. I have downloaded last month’s INFOSYS stock data from the National Stock Exchange website in CSV format. Now I will go to Insert>Charts>Other Charts>Stock>Volume-Open-High-Low-Close It shows a message box that the data should …
This is a project schedule format where I have a list of dates and works. I need to color all the Sundays in the list of dates and for that, I will use a simple trick. Select all the dates …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once Read more »
Press Ctrl+F to toggle the Find and Replace window>Replace Tab or go to Home Ribbon> Find & Select> Replace Here you will get the replacement feature of excel. In this post, I will discuss the 4 most useful ways of …
Lesson#50: 4 most useful way to use Find and Replace Read more »
Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …
Lesson#49: Make a parent Gantt chart from a data table Read more »
In this post, I will make a graphical 20X20 multiplication table and show the process of making it. Merged and centered these cells for showing data bar as I have shown in the picture below. Selected two random numbers between …
This post shows three ways to add any default word to the formula result. Here I have to calculate the difference between two dates and need to show the word “Days” with the result. 1. By using “&” I have …
Lesson#47: Three ways to add a default word to any formula result in Excel Read more »
Sometimes it needs to paste a list in reverse then a simple trick should keep in mind. A simple trick to paste in reverse order. Copy the list and paste it. Add an extra column beside this column. Add digits in …
Lesson#44: A Simple trick to paste in reverse order Read more »
Showing a random example worksheet where I have used conditional formatting and color formatting. Now I will make a switch that will trigger the Conditional Formatting ON or OFF. Besides the table, I have made a drop-down list of ON/OFF …
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 by pressing Ctrl+A. Now for coloring alternate rows of the entire sheet at once click on Conditional Formatting>New Rule>Use a formula to determine which …
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 using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more »