Introduction Comparing values for equality is a common functionality when dealing with worksheets. In this tutorial we're going to review the basic usage of VBA Excel not equal. The VBA Excel Not Equal This is an operator in VBA which is also called the negation operator. The operator looks like this (). If the two […]

Introduction IsNumber is a function in VBA that let us know if the text on a cell or range is a number or not. In this article we'll go over how to use it with some easy to grasp code examples. Excel VBA IsNumber IsNumber is a function in VBA that lets us know if […]

Introduction In this article we'll discussing how to use VBA to get today's date. Getting the current date is a functionality that is often needed in your worksheet and we'll show you how to do it. We will be using the Date function for us to get the current date. Date Function Although there is […]

Introduction In this second part of the article we will discuss further the total net income excel budget template we created in the first part. We'll be building upon it so make sure you've read part 1. You can find part 1 of the article here. Prerequisites Make sure that you have read the first […]

Introduction We can't emphasize enough the importance of creating a budget and Excel is the perfect tool to do it in. In this article we'll talk about how you can budget your monthly income and expenses by creating a personal budget in Excel. Let's jump in and create an Excel budget from our template. How […]

Introduction Excel Data Validation is an excel feature that allows us to control the data being entered into our spreadsheet. For example we can make sure our data is in the format we expect. We can also do things like: Creating a drop-down list of the allowed values Restricting inputs to whole numbers only or […]

Introduction In Excel you can use page breaks as dividers to split up a worksheet into separate print pages. The article will demonstrate how to use Excel's page break, such as editing, removing, and moving. Excel page breaks Microsoft Excel applies automatic page breaks depending on the size of the sheet, the margin, the parameters, […]

Introduction In this article we'll discuss and go over an example of what the Excel Index function does, when to use it, and the syntax. This is a very commonly used function in Excel and therefore is good to know this function by heart. The Excel index function returns the value of a cell given […]

Introduction Often in Excel you'll need to do comparison of numbers to compute some sort of result. One of those common comparisons is to check if a number is Greater Than or Equal to another value. In this article we'll discuss this operator along with a few others and show some typical examples of their […]

Introduction This article tutorial will discuss on how to turn on the autosave function in Excel. If you're constantly worried about your changes not being saved this is something you'll want to do to assure you that you never lose any work. Let's jump right in to see how to get Excel to AutoSave. Prerequisites […]