Teaching analytics with modern Excel
Working with Python code becomes significantly more manageable when objects are assigned clear, sensible names, and Excel is no different. This blog post covers how to create named ranges and tables …
Continue Reading about How to create named ranges and tables in Excel with openpyxl →
Among the numerous exciting features that Copilot is set to introduce for Excel, one significant requirement is that Excel data must be organized in tables. This is crucial because Copilot will not …
Continue Reading about Copilot for Excel: How to format data →
PERCENTOF() functionOne of the more recent additions to Excel which I haven't seen receive much coverage is the PERCENTOF() function. This function calculates the percentage that a subset represents of a given dataset. …
Continue Reading about How to calculate proportions in Excel with the PERCENTOF() function →
Excel tables offer several benefits for data storage and manipulation, one of the most significant being the ability to use structured references to programmatically select different elements of a …
Continue Reading about How to select two noncontiguous columns in an Excel table →
If you're familiar with using tables in Excel, you might know that table headers are structurally different from the data rows. These headers require distinct code for manipulation, setting them apart …
Continue Reading about How to understand data headers in Python in Excel →
Copilot for Excel is now live, bringing a suite of AI-powered features directly into your Excel experience. It's time to embrace the future of data analysis and ensure you're fully prepared to utilize …
