Recent Posts

How to Structure VBA Code and Macros in Excel - VBA Tutorial

When creating macros and writing VBA, it is important to logically structure your code to maximize readability and ensure your code is as...

Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...

For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...

The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...

The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...

A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...

Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...

Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...

The FLOOR.MATH function will round any number down to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The CEILING.MATH function will round any number up to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The MROUND function will round any number up or down to the nearest given multiple. Contents: Syntax Explanation Different Methods of...