MOD function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mod-function/ Bestselling Excel and Power BI Courses Sat, 22 Jun 2024 12:57:00 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png MOD function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mod-function/ 32 32 How to Create a Calendar in Excel https://www.xelplus.com/calendar-excel-formula/ Thu, 12 Nov 2020 10:00:00 +0000 https://www.xelplus.com/?p=10532 Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

The post How to Create a Calendar in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Create a Barcode in Excel https://www.xelplus.com/generate-barcodes-excel/ Thu, 06 Feb 2020 10:00:00 +0000 https://www.xelplus.com/?p=11492 Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

The post How to Create a Barcode in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel MOD Function https://www.xelplus.com/excel-mod-function/ Mon, 02 Jan 2017 13:57:00 +0000 https://www.xelplus.com/?p=13063 This tutorial explains the MOD function in simple terms and shows you three different practical cases. Use MOD to decide the ideal size of groupings, prepare data for quarterly reporting, and control the occurrences of data labels in charts.

The post Excel MOD Function appeared first on Xelplus - Leila Gharani.

]]>