This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more »
PivotTable has very powerful features to analyze data. One of them is PivotChart. PivotChart is a different feature of Pivot Tools to represent the PivotTable data with the chart. Here I am having a practice with the employee database and …
Can you count rows by color? Yes, It’s very easy and simple. Here I have a data table that has different colors in rows. I have counted rows by color in these simple steps. 1. I will add a Filter …
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more »
In this post, I will discuss some examples where Pie Chart is applicable. Pie Chart is generally used to show percentage or proportional data. Here I have downloaded a mutual fund portfolio allocation data sector-wise in the stock market. I …
Lesson#55: Some examples where Pie Chart can be used Read more »
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 »
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
CODE is the opposite of the CHAR function. The syntax of this function is CODE(text). It will return the ASCII value of the first character of the text. I have shown in the above pictures how an ASCII table is …
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 »