Featured Archives - Xelplus - Leila Gharani

You Won’t Believe These Excel PIVOT TABLE Hacks!

Leila Gharani — Thu, 24 Aug 2023 15:21:37 +0000

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.

You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query

Leila Gharani — Thu, 24 Aug 2023 15:17:55 +0000

Learn 10 of the most productivity increasing "hidden" features of Power Query to take your skills to the next level.

The post You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query appeared first on Xelplus - Leila Gharani.

How To Use Excel FILTER Function With Multiple Criteria

Leila Gharani — Thu, 24 Aug 2023 15:02:59 +0000

Learn to use Excel's FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

The post How To Use Excel FILTER Function With Multiple Criteria appeared first on Xelplus - Leila Gharani.

What is Power BI?

Leila Gharani — Thu, 10 Nov 2022 10:00:00 +0000

What is Power BI? What is Power BI used for? You see, there is a reason why companies are investing more and more in Power BI projects. Actually, there are 4 reasons why Power BI is preferred to the competition. This tutorial explains it all in plain English.

The post What is Power BI? appeared first on Xelplus - Leila Gharani.

4 Excel Settings to Review to be More Productive

Leila Gharani — Thu, 25 Aug 2022 09:00:00 +0000

Excel comes with default settings and options. You can change these to support your workflow and be more productive. This post covers my list of options to review.

The post 4 Excel Settings to Review to be More Productive appeared first on Xelplus - Leila Gharani.

Excel VSTACK Function – The One Excel Formula to Append Them All

Leila Gharani — Thu, 26 May 2022 23:55:00 +0000

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

How to Learn Financial Analysis

Leila Gharani — Thu, 05 May 2022 05:29:00 +0000

The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.

The post How to Learn Financial Analysis appeared first on Xelplus - Leila Gharani.

Avoid these 7 Common Errors in Microsoft Excel (and how to fix them)

Leila Gharani — Thu, 17 Feb 2022 10:00:00 +0000

How do you fix broken Excel formulas? What do you do when the formulas return errors? Find out what the most common Excel formula errors are and how you can fix them. It's easy! You just need the right approach. This post covers it all!

The post Avoid these 7 Common Errors in Microsoft Excel (and how to fix them) appeared first on Xelplus - Leila Gharani.

Top Excel Functions for Engineers

Leila Gharani — Thu, 23 Dec 2021 10:00:00 +0000

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

What is Power Query and Why Should You Use It?

Leila Gharani — Mon, 29 Jun 2020 17:50:00 +0000

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

The post What is Power Query and Why Should You Use It? appeared first on Xelplus - Leila Gharani.