Sheets Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sheets/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:40:54 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Sheets Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sheets/ 32 32 Google Sheets – How to Create a Unique List from Multiple Columns https://www.xelplus.com/sheets-unique-list-from-multiple-columns/ Wed, 28 Jul 2021 17:20:00 +0000 https://www.xelplus.com/?p=9943 Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you're done!

The post Google Sheets – How to Create a Unique List from Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Google Sheets QUERY Function Explained https://www.xelplus.com/google-sheets-query-function/ Tue, 29 Dec 2020 18:42:00 +0000 https://www.xelplus.com/?p=8961 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 Create MULTIPLE Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-multiple-dependent-dropdown-lists/ Tue, 15 Dec 2020 12:40:00 +0000 https://www.xelplus.com/?p=9182 There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check it out here.

The post How to Create MULTIPLE Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Setup Dependent Drop-Down Lists in Google Sheets https://www.xelplus.com/google-sheets-dependent-drop-down-lists/ Tue, 08 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10395 Learn how to create dependent drop-down lists in Google Sheets. Dependent drop-downs can be tricky in Google Sheets because you can't add a formula to the drop-down version of the data validation. But there is another way.

The post How to Setup Dependent Drop-Down Lists in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Use the Google Sheets FILTER Function https://www.xelplus.com/google-sheets-filter-function/ Tue, 24 Nov 2020 12:00:00 +0000 https://www.xelplus.com/?p=10434 Learn how to properly use the FILTER Function in Google Sheets. You can use the Filter function to check for one condition or apply it to multiple columns. You can also sort the filtered results by wrapping FILTER inside the SORT function.

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

]]> What are Cleanup Suggestions and Column Statistics in Google Sheets https://www.xelplus.com/google-sheets-cleanup-suggestions-column-stats/ Tue, 17 Nov 2020 12:00:00 +0000 https://www.xelplus.com/?p=10451 Find out to quickly use column stats in Google Sheets to get information about a specific column. Cleanup suggestions is another new feature in Sheets - but can you rely on it?

The post What are Cleanup Suggestions and Column Statistics in Google Sheets appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets Smart Fill https://www.xelplus.com/smart-fill-in-google-sheets/ Tue, 10 Nov 2020 13:00:00 +0000 https://www.xelplus.com/?p=10541 With SmartFill in Google Sheets you get to auto fill a column based on a pattern. For example, if you'd like to grab the first name of a person, you don't have to write the formula. Just write the end result and Sheets will fill down with the correct formula.

The post How to Use Google Sheets Smart Fill appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets Filters & Filter Views https://www.xelplus.com/google-sheets-filter-view/ Tue, 03 Nov 2020 13:08:00 +0000 https://www.xelplus.com/?p=10558 Learn how to use Filter and Filter Views in Google Sheets. A Filter View is really easy to create. Plus, you get to sort your data without changing the original sort order.

The post How to Use Google Sheets Filters & Filter Views appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets Version Recovery and Cell Edit History https://www.xelplus.com/google-sheets-version-history/ Tue, 27 Oct 2020 15:45:00 +0000 https://www.xelplus.com/?p=10581 With Version Recovery and Version History in Google Sheets you get to easily revert back to any previous version of your Google Spreadsheet. You can even create Named versions and use cell edit history to track changes to values inside cells.

The post How to Use Google Sheets Version Recovery and Cell Edit History appeared first on Xelplus - Leila Gharani.

]]> Google Sheets vs. Excel – Is Google Sheets Better? https://www.xelplus.com/google-sheets-vs-excel/ Thu, 24 Sep 2020 09:00:00 +0000 https://www.xelplus.com/?p=10665 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.

]]>