Tips Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/tips/ Bestselling Excel and Power BI Courses Thu, 16 Mar 2023 23:47:37 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Tips Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/tips/ 32 32 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.

]]> 5 PowerPoint Tips You Wish You Knew Sooner https://www.xelplus.com/5-powerpoint-tips/ Thu, 19 Nov 2020 10:00:00 +0000 https://www.xelplus.com/?p=10442 In this post I share 5 PowerPoint tips and tricks you wished you knew sooner (At least I did!). These apply for PowerPoint business presentations as well as for students and teachers.

The post 5 PowerPoint Tips You Wish You Knew Sooner appeared first on Xelplus - Leila Gharani.

]]> Windows 10 Top Tips & Tricks https://www.xelplus.com/windows-10-top-tips-tricks/ Thu, 02 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11402 Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!

The post Windows 10 Top Tips & Tricks appeared first on Xelplus - Leila Gharani.

]]> Use This Excel Hidden Shortcut to Select Column with Blank Cells https://www.xelplus.com/excel-shortcut-select-column-with-blanks/ Thu, 12 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11432 Find out a secret workaround that takes care of the problem of blank cells in the middle of your data range when you're trying to quickly navigate to the end of the range with the help of shortcuts. It can get really frustrating, especially in a long range with lots of blanks. But there is a way - several, in fact. Next time you come across this issue, you will be fully equipped.

The post Use This Excel Hidden Shortcut to Select Column with Blank Cells appeared first on Xelplus - Leila Gharani.

]]> 3 Handy Excel Chart Tips You Might Have Missed https://www.xelplus.com/excel-chart-tips/ Tue, 12 Feb 2019 19:44:00 +0000 https://www.xelplus.com/?p=12870 Would you like to hide the data but keep your chart? Add text boxes to the chart to make it easier to read? What's the best way of doing this? These Excel chart tips will help you.

The post 3 Handy Excel Chart Tips You Might Have Missed appeared first on Xelplus - Leila Gharani.

]]> Copy Excel Formulas Without Changing Cell References https://www.xelplus.com/copy-excel-formulas-without-changing-cell-references/ Mon, 26 Feb 2018 19:31:00 +0000 https://www.xelplus.com/?p=11059 Would you like to copy your Excel formulas from one place to another without the cell references changing? In this step by step tutorial I show you a very simple trick that does that.

The post Copy Excel Formulas Without Changing Cell References appeared first on Xelplus - Leila Gharani.

]]> Optimized Excel Line Charts: Prevent Drop to Zero https://www.xelplus.com/excel-line-charts-prevent-drop-to-zero-dynamic-legend/ Fri, 01 Dec 2017 06:50:00 +0000 https://www.xelplus.com/?p=11245 Learn how to create dynamic line charts and avoid common problems, such as line series dropping to zero and positioning the legend at the end of the line series.

The post Optimized Excel Line Charts: Prevent Drop to Zero appeared first on Xelplus - Leila Gharani.

]]>