Tricks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/tricks/ 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 Tricks Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/tricks/ 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.

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

]]> 3 Methods to Unhide All Sheets in Excel (& how to hide) https://www.xelplus.com/3-methods-to-unhide-all-sheets-in-excel/ Thu, 07 Mar 2019 12:17:00 +0000 https://www.xelplus.com/?p=12816 Learn how to quickly hide and unhide all worksheets in at once. Hiding sheets in Excel is easy, but unhiding all sheets is not as simple. I show you 3 methods to unhide Excel tabs. Pick the one you like most.

The post 3 Methods to Unhide All Sheets in Excel (& how to hide) 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.

]]>