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

Introduction The Microsoft Excel ROUND function allows you to round a numeric values making the number simpler but having its value close to what it was originally. This function is categorized under Math/Trig Function in Excel. In this article, you will learn how to use Excel Round function. The Round Formula in Excel Parameters and […]

Introduction This article is a tutorial that will discuss how to use the Excel rank function to organize the list of data. We'll quickly go over some basic prerequisites and then jump into exactly what the rank function does. Let's jump in! Prerequisites You need Microsoft Excel installed on your device. A basic knowledge in […]

Introduction In this article we will show you how to use the Excel TEXT function which will help you convert numerical values into text. We'll explain what it does and go over some examples step by step. Prerequisites For beginners, understanding Excel could be a difficult start. You must have basic knowledge of the Excel […]

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