Cell Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/cell-reference/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 12:06:20 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Cell Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/cell-reference/ 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.

]]> When to Use the Hash Sign (#) in Excel Formulas https://www.xelplus.com/excel-hash-sign-formulas/ Thu, 21 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10332 What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel Conditional Formatting with Formulas https://www.xelplus.com/excel-conditional-formatting-rows/ Thu, 03 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=10404 Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

The post How to Use Excel Conditional Formatting with Formulas appeared first on Xelplus - Leila Gharani.

]]> How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? https://www.xelplus.com/excel-cell-references/ Sat, 01 Feb 2020 14:35:00 +0000 https://www.xelplus.com/?p=11502 Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

The post How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? appeared first on Xelplus - Leila Gharani.

]]> Top 5 Excel Interview Questions https://www.xelplus.com/top-5-excel-interview-questions/ Thu, 10 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12068 Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you're applying for data analyst jobs.

The post Top 5 Excel Interview Questions appeared first on Xelplus - Leila Gharani.

]]> Excel Hack to Change Horizontal Data to Vertical https://www.xelplus.com/excel-horizontal-data-to-vertical/ Sat, 11 May 2019 20:40:00 +0000 https://www.xelplus.com/?p=12358 Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.

The post Excel Hack to Change Horizontal Data to Vertical appeared first on Xelplus - Leila Gharani.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> 3 Ways to Transpose Excel Data https://www.xelplus.com/transpose-excel-data/ Fri, 09 Nov 2018 12:02:00 +0000 https://www.xelplus.com/?p=9884 2 of the methods shown to transpose data in Excel are dynamic. Number 3 will surprise you. It will show you a simple way to switch your data from rows to columns or vice versa.

The post 3 Ways to Transpose Excel Data appeared first on Xelplus - Leila Gharani.

]]> VBA Writing To Ranges https://www.xelplus.com/vba-writing-to-ranges/ Thu, 12 Apr 2018 16:08:00 +0000 https://www.xelplus.com/?p=10956 Learn how to use ranges, cells property, offset, named ranges, difference between activecell and selection, and how to reference entire rows or entire columns and also how to use autofit in Excel VBA.

The post VBA Writing To Ranges 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.

]]>