Excel Table Archives - Xelplus - Leila Gharani

7 Things You’re Doing Wrong (or perhaps not the best way) in Excel

Leila Gharani — Thu, 27 Jan 2022 08:22:00 +0000

Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.

The post 7 Things You’re Doing Wrong (or perhaps not the best way) in Excel appeared first on Xelplus - Leila Gharani.

How to Repeat Table Values x Times Using Power Query

Leila Gharani — Thu, 07 Oct 2021 08:00:00 +0000

With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

The post How to Repeat Table Values x Times Using Power Query appeared first on Xelplus - Leila Gharani.

When to Use the Hash Sign (#) in Excel Formulas

Leila Gharani — Thu, 21 Jan 2021 10:00:00 +0000

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.

Excel Stock Data Type to Get Real-Time Stock Metrics

Leila Gharani — Thu, 31 Dec 2020 10:38:00 +0000

Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

The post Excel Stock Data Type to Get Real-Time Stock Metrics appeared first on Xelplus - Leila Gharani.

How to Create a Pivot Table Based on Multiple Sheets and Tables

Leila Gharani — Thu, 29 Oct 2020 17:18:00 +0000

This is a simple but advanced Pivot Table technique in Excel. If you'd like to create a Pivot Table based on multiple sheets or tables, you can easily do that by defining the relationship between the tables from the data tab. It just takes one click.

The post How to Create a Pivot Table Based on Multiple Sheets and Tables appeared first on Xelplus - Leila Gharani.

Excel vs. Google Sheets – Is Excel Better?

Leila Gharani — Thu, 01 Oct 2020 09:00:00 +0000

These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

How to Create Excel Interactive Charts with Dynamic Arrays

Leila Gharani — Thu, 19 Mar 2020 10:00:00 +0000

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

The post How to Create Excel Interactive Charts with Dynamic Arrays appeared first on Xelplus - Leila Gharani.

Use This Excel Hidden Shortcut to Select Column with Blank Cells

Leila Gharani — Thu, 12 Mar 2020 10:00:00 +0000

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.

Excel shortcut keys you SHOULD know!

Leila Gharani — Sat, 13 Apr 2019 00:02:00 +0000

Are you using all of these 20 Excel keyboard shortcuts in your daily work? They range from data navigation to auto sum, inserting the date and time and even moving rows of data and dropping them between other rows.

The post Excel shortcut keys you SHOULD know! appeared first on Xelplus - Leila Gharani.

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)

Leila Gharani — Fri, 25 Jan 2019 16:16:00 +0000

This is the easiest searchable drop-down list you'll be creating in Excel. It uses the new Excel FILTER function and dynamic array functionality. Download the workbook to practice along.

The post Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) appeared first on Xelplus - Leila Gharani.