Lesson#58: How to analyse data with Pivottable
PivotTable has very powerful features to analyze data. One of them is PivotChart. PivotChart is a …
Author: Pushpendu Roy Karmakar
Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#57: Simple trick to count rows by color
Can you count rows by color? Yes, It’s very easy and simple. Here I have a …
Lesson#56: How to make birthday reminder in excel
Here I am having an employee database and I have to make a birthday reminder in …
Lesson#56: How to make birthday reminder in excel Read more →
Lesson#55: Some examples where Pie Chart can be used
In this post, I will discuss some examples where Pie Chart is applicable. Pie Chart is …
Lesson#55: Some examples where Pie Chart can be used Read more →
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 …
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#52: Let’s check your lifeline with Excel
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …
Lesson#51: What is the CODE function in Excel?
CODE is the opposite of the CHAR function. The syntax of this function is CODE(text). It …
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 →