Excel Tips Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-tips/ Bestselling Excel and Power BI Courses Tue, 07 Nov 2023 20:19:33 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Excel Tips Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-tips/ 32 32 How to Fix Slow Excel Spreadsheets https://www.xelplus.com/how-to-fix-slow-excel-spreadsheets/ Mon, 06 Nov 2023 17:50:39 +0000 https://www.xelplus.com/?p=13496 Poor design slows down your spreadsheets. There are several frequent offenders to watch out for. Find out what they are and how you can optimize your workbooks.

The post How to Fix Slow Excel Spreadsheets appeared first on Xelplus - Leila Gharani.

]]> You Won’t Believe These Excel PIVOT TABLE Hacks! https://www.xelplus.com/pivot-table-pro-tips/ Thu, 24 Aug 2023 15:21:37 +0000 https://www.xelplus.com/?p=17817 Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

The post You Won’t Believe These Excel PIVOT TABLE Hacks! 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.

]]> Excel Charts: Dynamic Line Series Labels https://www.xelplus.com/excel-charts-dynamic-line-series-labels/ Mon, 18 Jul 2016 10:34:00 +0000 https://www.xelplus.com/?p=13712 Default legends often put a lot of effort on the chart reader. Consider how you can improve the readability of your charts so that your readers don't struggle to interpret them. One solution can be replacing the default legend with dynamic series labels.

The post Excel Charts: Dynamic Line Series Labels appeared first on Xelplus - Leila Gharani.

]]> Why you Need This Feature Before Distributing Your Excel Files https://www.xelplus.com/why-you-need-excels-inspect-document-before-distributing-your-files/ Fri, 24 Jun 2016 08:54:00 +0000 https://www.xelplus.com/?p=13677 Discover the Inspect Document feature in Excel. It is particularly useful when you collaborate on files with others. It helps you find hidden information in your workbook, such as comments, personal information, hidden sheets, rows and columns, etc.

The post Why you Need This Feature Before Distributing Your Excel Files appeared first on Xelplus - Leila Gharani.

]]> Speed Up Your Excel Files https://www.xelplus.com/speed-up-your-excel-files/ Fri, 18 Mar 2016 07:48:00 +0000 https://www.xelplus.com/?p=13589 Download the cheat sheet with practical tips to improve the performance and speed of your workbooks.

The post Speed Up Your Excel Files appeared first on Xelplus - Leila Gharani.

]]>