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

Create an Excel Calendar with Holidays and Appointments

Leila Gharani — Mon, 30 Dec 2019 14:10:00 +0000

Download this free Monthly Excel Calendar with holidays and appointments. It automatically adds standard holidays like Easter and New Year's - you can also use it to keep track of your appointments.

The post Create an Excel Calendar with Holidays and Appointments appeared first on Xelplus - Leila Gharani.

Data Validation in Excel

Leila Gharani — Thu, 10 May 2018 16:46:00 +0000

Learn how to properly set up data validation in Excel. It's especially useful when you're preparing a data input form, where you require the entered data to meet certain criteria.

The post Data Validation in Excel appeared first on Xelplus - Leila Gharani.

Excel Reset Week Number Every Month (start from Week # 1 every new month)

Leila Gharani — Fri, 15 Dec 2017 09:07:00 +0000

Find out how you can use the WEEKDAY and WEEKNUM functions in Excel to be able to reset the Week Number at the beginning of every month.

The post Excel Reset Week Number Every Month (start from Week # 1 every new month) appeared first on Xelplus - Leila Gharani.