MOD function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mod-function/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 08:28:25 +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 Yearly Calendar with ONE Excel Formula (Use in Google Sheets too) 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 Yearly Calendar with ONE Excel Formula (Use in Google Sheets too) appeared first on Xelplus - Leila Gharani.

]]> How to Read and Create Barcodes 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 Read and Create Barcodes 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.

]]>