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

top of page

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

Understanding Objects in VBA

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

GitHub Style Habit Tracker & Calendar Heat Map in Excel

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

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

Printable Dice Miner Scorecard Template in Excel

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

Basic Excel Formulas and Functions

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

How to Calculate Working Days in a Month

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

How to Use the BIN2OCT Function

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

How to Use the OCT2BIN Function

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

How to Use the OCT2DEC Function

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

How to Use the DEC2OCT Function

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

How to use the HEX2DEC Function

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

How to Use the DEC2HEX Function

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

How to Use the HEX2BIN Function

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

How to Use the BIN2HEX Function

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

bottom of page