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
Recent Posts
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