Recent Posts

How to Automatically Combine Multiple Files into One

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

There are lots of ways to convert decimal numbers into binary. Excel has a built in function for small numbers, but you'll need a custom...

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

There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...