Group Archives - Xelplus - Leila Gharani

How to Properly Handle Dates in Excel Pivot Tables

Leila Gharani — Thu, 19 May 2022 08:00:00 +0000

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

The post How to Properly Handle Dates in Excel Pivot Tables appeared first on 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.

Excel Advanced Pivot Table Techniques for Serious Data Analysts

Leila Gharani — Thu, 08 Apr 2021 08:00:00 +0000

These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

The post Excel Advanced Pivot Table Techniques for Serious Data Analysts appeared first on Xelplus - Leila Gharani.

Google Sheets QUERY Function Explained

Leila Gharani — Tue, 29 Dec 2020 18:42:00 +0000

The Query function in Google sheets is one of the most powerful Google Sheets functions. It's easy to learn if you follow the rules laid out in this tutorial. You'll be ready to solve any data analysis problem in Google Sheets.

The post Google Sheets QUERY Function Explained appeared first on Xelplus - Leila Gharani.