My guest today is a force of nature in the speaking, consulting, training, healing, educating, and all around good person worlds. If there’s a useful therapeutic modality out there, I bet she knows its inner workings. And… she was my office mate in grad school where we both clawed a PhD out of the Univ […]

Introduction In this article we'll be discussing the Excel VBA variable types. If you're familiar with any other programming language the same basic variables types will be available in VBA. The Excel VBA Variable Types Variables are also known as the storage of different kinds of data types and constants for your worksheets. We suggest […]

Introduction In this article we will learn how in Excel and VBA to delete a row. This is an extremely common task and if you're using VBA you'll want to know how to tackle it correctly. Excel VBA Delete Row In an ordinary Excel worksheet we can delete a row by pressing CTRL plus signs […]

keyword: vba excel Whileloop Introduction This article will analyze the use of the VBA Excel Whileloop. Looping is a super important concept in any type of programming including VBA and understanding the while loop is a good intro to looping as well as a very practically used function. The VBA Excel while loop With the […]

Introduction In this article, we will be discussing Excel VBA count if Prerequisites A computer or a laptop containing Microsoft Excel. The VBA Count If Count If function in excel is one of the most important functions in Visual Basics for Application. The functions which are criteria based, they are also known as the rulers […]

Introduction In this article we'll be covering the Excel VBA CountA function, usage, and some basic examples. The Excel VBA CountA Sometimes you have an array of cells where some cells contain data and some don't. In a scenario like this to count the number of cells that contain data you use the CountA function. […]

Introduction In this article we'll discuss the Microsoft Excel histogram chart functionality that will graphically return the summarization of distribution on numerical data. A good graph can help you grasp data quicker and easier and so turning your Excel data into a histogram might be something you consider. The Excel Histogram Chart This tutorial will […]

Introduction In this article we'll discuss how to customize the excel number format so your data looks exactly as you intent. Maybe you want to only show two decimals because it's a monetary value, or maybe you want to only show whole numbers, we'll discuss how to achieve this type of functionality in your worksheets. […]

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 […]

I'm thrilled to announce that I've been selected as a speaker at Pubcon 2025 in Austin! This is an incredible opportunity to share insights and engage with industry experts in the vibrant tech hub of Texas. With over 20 years of experience in SEO, PPC, CRO, and software development, I am eager to delve into […]