Lesson#82: Type in multiple sheets at one time in Excel
There is a nice feature in Excel by which we can type in multiple sheets at …
Lesson#82: Type in multiple sheets at one time in Excel Read more →
Excel Features
Lesson#65: Inserting Slicer and Timeline in PIvottable
Slicer and Timeline are just more interactive filters. We can show the pivot of filtered data …
Lesson#65: Inserting Slicer and Timeline in PIvottable Read more →
Lesson#64: Freeze panes must be kept in mind
Freeze Panes is a very important feature that is required in spreadsheets. It’s better to keep …
Lesson#62: Making a Sine curve
Here I will show how to make a Sine curve but before that, we have to …
Lesson#61: Making a semi analog clock with pie chart
OK friends! How is everyone? Now in this post, we will learn an unusual trick to …
Lesson#61: Making a semi analog clock with pie chart Read more →
Lesson#60: Excel shows global warming
Here I have gathered 100 year’s precipitation and average temperature data from www.indiawaterportal.org. For example, I …
Lesson#58: How to analyse data with Pivottable
PivotTable has very powerful features to analyze data. One of them is PivotChart. PivotChart is a …
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 →