Recent Posts

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