QUERY Archives - Xelplus - Leila Gharani

Google Sheets QUERY Function Explained

Leila Gharani — Tue, 29 Dec 2020 18:42:00 +0000

The Query function in Google sheets is one of the most powerful Google Sheets functions. It's easy to learn if you follow the rules laid out in this tutorial. You'll be ready to solve any data analysis problem in Google Sheets.

The post Google Sheets QUERY Function Explained appeared first on Xelplus - Leila Gharani.

How to Use Google Sheets IMPORTRANGE Function

Leila Gharani — Tue, 22 Dec 2020 12:00:00 +0000

Learn how to use IMPORTRANGE in Google Sheets. You can also use it together with QUERY to import and append data from multiple sheets. IMPORTRANGE is great when you'd like to import data from other spreadsheets.

The post How to Use Google Sheets IMPORTRANGE Function appeared first on Xelplus - Leila Gharani.

Do You Need to Learn Google Sheets?

Leila Gharani — Tue, 17 Nov 2020 08:21:00 +0000

What can Google Sheets do and should I learn it? This was a question I asked myself some time ago. I noticed more companies were switching to Google Sheets specially because of the events of 2020. In this post I talk about what Google Sheets can do.

The post Do You Need to Learn Google Sheets? appeared first on Xelplus - Leila Gharani.

Google Sheets vs. Excel – Is Google Sheets Better?

Leila Gharani — Thu, 24 Sep 2020 09:00:00 +0000

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It's a mix of Google sheets basic to advanced functions and hidden features.

The post Google Sheets vs. Excel – Is Google Sheets Better? appeared first on Xelplus - Leila Gharani.