You searched for google sheets - Xelplus - Leila Gharani https://www.xelplus.com/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 18:21:11 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png You searched for google sheets - Xelplus - Leila Gharani https://www.xelplus.com/ 32 32 Google Sheets – The Comprehensive Masterclass https://www.xelplus.com/course/google-sheets/ Mon, 13 Feb 2023 17:29:59 +0000 https://www.xelplus.com/?post_type=xp_course&p=8810 Master the Powerful Features of Google Sheets from data collection, automation to proper data analysis and visualization. This course will teach you everything you need to know about Google Sheets. Plus you'll benefit from our EXCLUSIVE bonuses.

The post Google Sheets – The Comprehensive Masterclass appeared first on Xelplus - Leila Gharani.

]]> Unlock Excel VBA & Excel Macros https://www.xelplus.com/course/excel-vba-excel-macros/ Mon, 13 Feb 2023 17:24:07 +0000 https://www.xelplus.com/?post_type=xp_course&p=8807 Automate ANYTHING you need done in Excel with VBA and macros. Go from Beginner to VBA Expert and design automations with confidence.

The post Unlock Excel VBA & Excel Macros appeared first on Xelplus - Leila Gharani.

]]> Master Excel Power Query – Beginner to Pro https://www.xelplus.com/course/excel-power-query/ Mon, 13 Feb 2023 16:49:11 +0000 https://www.xelplus.com/?post_type=xp_course&p=8769 Power Query is essential for Excel users who work with lots of data. This course teaches you how to use Excel in Power Mode and create meaningful reports with far less effort.

The post Master Excel Power Query – Beginner to Pro appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> Top 10 Tips to Make the Most of Google Sheets https://www.xelplus.com/top-10-tips-for-google-sheets/ Sun, 28 Feb 2021 22:02:00 +0000 https://www.xelplus.com/?p=10240 This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

The post Top 10 Tips to Make the Most of Google Sheets 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 Use Google Sheets IMPORTRANGE Function https://www.xelplus.com/google-sheets-importrange/ Tue, 22 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=9021 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.

]]> 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 Create QR Code for Free in Google Sheets https://www.xelplus.com/create-qr-codes/ Tue, 01 Dec 2020 12:00:00 +0000 https://www.xelplus.com/?p=10412 Easily create QR codes for free. You can copy and paste the QR code into any application including Microsoft Word, Excel and PowerPoint. I use a function in Google Sheets to set this up. You can grab your copy and replace the URLs with your own.

The post How to Create QR Code for Free in Google Sheets appeared first on Xelplus - Leila Gharani.

]]>