Sort Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sort/ Bestselling Excel and Power BI Courses Wed, 08 Nov 2023 10:16:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Sort Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sort/ 32 32 Excel’s TAKE Function – Real World Examples https://www.xelplus.com/excel-take-function/ Wed, 12 Jul 2023 14:56:00 +0000 https://www.xelplus.com/?p=17473 Learn to properly use Excel’s TAKE function. With TAKE you’ll be able to extract a specified number of rows or columns from the start or end of your dataset. This opens many opportunities for data extraction in combination with other Excel functions.

The post Excel’s TAKE Function – Real World Examples appeared first on Xelplus - Leila Gharani.

]]> How to Mail Merge from Excel https://www.xelplus.com/mail-merge-from-excel/ Thu, 22 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10143 Mail Merge is what you need if you'd like to create multiple letters, emails or documents with data from Excel. This way you can easily create invoices for your customers or send bulk personalized emails. You'll learn how to quickly get started with Merge. Merge and save a ton of time.

The post How to Mail Merge from Excel 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.

]]> Create Excel Filled Map Charts with Power Query https://www.xelplus.com/excel-filled-map-chart-using-power-query/ Thu, 02 Jul 2020 17:51:00 +0000 https://www.xelplus.com/?p=10886 Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

The post Create Excel Filled Map Charts with Power Query appeared first on Xelplus - Leila Gharani.

]]> Excel Sort (by Value, Color, Icon, Own List) & How to Unsort https://www.xelplus.com/excel-sort-by-value-color-icon-own-list-how-to-unsort/ Mon, 22 Oct 2018 16:02:00 +0000 https://www.xelplus.com/?p=9626 Quickly learn how to use Excel's Sort feature to sort your data by value, color, icon and even your own custom list. Use this trick to Unsort your data.

The post Excel Sort (by Value, Color, Icon, Own List) & How to Unsort appeared first on Xelplus - Leila Gharani.

]]>