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 This tutorial will demonstrate how to use the Excel SUM formula. We have some recommended prerequisites but you can dive straight into the content wherever you feel comfortable. Prerequisites Make sure you have Microsoft Excel installed. Installation will depend on your specific operating system. Open Excel and create a new worksheet. Once you've opened […]

Introduction You may not even realize it, but the numbers you see in your Excel spreadsheet might be text representations of numbers, not numeric values. How do you know if this is the case? It's fairly easy to spot text representations of numbers-- if you try to use these values in formulas and get errors […]

Introduction In Microsoft Excel, a named range refers to a range of cells to which a user has assigned a particular name. The ability to name a range is a handy feature of Excel that is often overlooked. Named ranges can simplify a complex spreadsheet or macro and make your formulas easier to understand. In […]

Introduction If you need to organize and arrange column in a spreadsheet, Microsoft Excel makes it easy to get the job done. Whether you added data to a column by mistake or simply wish to move a column of data to a different location, there are a number of ways you can shift columns in […]

Introduction Excel provides a variety of financial functions that make it easy to generate the reports you need. The Excel PMT function can be used to calculate the periodic payment needed to pay off a loan. This function allows you to determine the amount of the monthly or other periodic payment as long as the […]

Introduction Pie charts offer a simple way to visualize proportions and percentages in your data, with each "pie slice" representing one of those percentages. Microsoft Excel makes it easy to generate pie charts from your spreadsheet data. In this article, we'll walk you through the process of creating an Excel pie chart and saving that […]

Introduction Microsoft Excel provides a variety of functions that can be used to work with dates. Each function performs a simple operation; if you combine multiple functions within one formula, you can tackle more complex tasks. In this article, we'll talk about how to use functions in Excel for date formulas and provide some examples […]

Introduction If you use Excel frequently, you know how much time keyboard shortcuts can save. While these shortcuts make many tasks easier, it can take time to learn and master them all. That's where a handy "cheat sheet" can be a game changer. In this article, we'll review the most useful Mac Excel shortcuts, organized […]

Introduction When you work with Excel spreadsheets, you're likely to encounter duplicates in your data at some point. There are many potential causes of duplicates-- for example, you might have exported data from different sources or consolidated multiple spreadsheets. Regardless of the cause, it's time-consuming to find and remove duplicates manually. In this article, we'll […]

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