Tag: Excel

Countifs with Multiple Criteria in Same Range in Google Sheets

Countifs with Multiple Criteria in Same Range in Google Sheets

Unlike Excel, it's not easy or nearly impossible to use Countifs with multiple criteria in same range in Google Sheets. There are alternative functions like Query which is far better in this case. But many...
girl using google sheets

How to Copy and Paste Images from Excel to Google Sheets

Some of the features in Excel have definitely an edge over Google Sheets. I've recently pointed out the Pivot Table. Now here in the case of shapes, in Google Sheets it's drawings, I think...
Different Sparkline Charts in Google Sheets

Use of Four Different Sparkline Charts in Google Sheets

This post is all about the superbly easy to create Sparkline charts. I often use different Sparkline charts in Google Sheets as well as in Excel. This way I try to make my reports...

Placement and Use of Single or Double Dollar Symbols in Formula in Spreadsheet

You can often see people use the $ sign in spreadsheet formulas. I also use dollar symbols in formula no matter whether it's Google Spreadsheets or Excel. Actually it helps us to reduce the...
copy paste formula - Excel and Google Sheets

How to Copy and Paste from Google Sheet to Excel with Formulas

In this post we will check two aspects of the copy and paste formulas between two popular spreadsheet applications - Excel and Google Sheets. First thing is copy and paste from Google Sheet to...

Google Sheets Formulas

Dynamic Ranges in Google Sheets Without Helper Cell

Here you can learn a unique way of creating DYNAMIC RANGES in Google Sheets. It's possible to create Dynamic Ranges in Google Sheets without...

Inspiration

Spiritual Quotes : 15 Picture Quotes Inspired by Spirituality

It's hard to define the term spirituality as it's often found discussed in a broader spectrum. In my understanding spirituality is not about becoming...