When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …
How to understand the TEXTBEFORE() and TEXTAFTER() functions in Excel
The TEXTBEFORE() and TEXTAFTER() functions in Excel represent a significant enhancement to the traditional Text To Columns feature, offering a higher degree of customization and auditability. These …
Continue Reading about How to understand the TEXTBEFORE() and TEXTAFTER() functions in Excel →
How to understand the TEXTSPLIT() function in Excel
When working with text data in Excel, it's common to need to split strings by various delimiters such as commas, semicolons, and so forth. Although the legacy Text to Columns feature has its uses, …
Continue Reading about How to understand the TEXTSPLIT() function in Excel →
How to create a dynamic dropdown list in Excel
Creating a dynamic dropdown list that expands or contracts with your source data is a fantastic way to enhance user experience in an Excel workbook! In this post, we'll explore how to set up a dynamic …
Continue Reading about How to create a dynamic dropdown list in Excel →
How to create a wafflechart in Excel
Waffle charts are a great way to visualize data as a grid of squares where each square represents a portion of the whole. Unlike pie charts, which can be hard to interpret with many categories, waffle …
Continue Reading about How to create a wafflechart in Excel →
How to create interactive visualizations in Excel using dynamic arrays
Among all of the amazing enhancements in Excel, one that really resonates with the core of Excel is dynamic arrays. Spreadsheets became popular primarily because of their tactile ability to visually …
Continue Reading about How to create interactive visualizations in Excel using dynamic arrays →