Recent Posts

How to Calculate Working Days Passed in Current Month

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) that have passed in...

An object in VBA is an Excel component such as a workbook, worksheet, or range, that you can interact with and manipulate. These are...

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version...

Many businesses receive monthly sales reports in separate Excel files. Manually combining these files into a single master file each...

Contents: 1. Download 2. How to Use Download To download this workbook containing printable scorecards and automatic score keeping, click...

Excel formulas and functions are powerful tools for performing calculations and data analysis. Formulas are custom calculations you...

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) in a month, from a...

The BIN2OCT function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number 2.2. What...

The OCT2BIN function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2. What...

The OCT2DEC function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2....

The DEC2OCT function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....

The HEX2DEC function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...

The DEC2HEX function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number...

The HEX2BIN function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...

The BIN2HEX function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number...