Discover how to replace traditional Excel chart objects with clean, customizable in-cell visualizations using a single ...

Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This ...

I didn't realize how much time I spent on cleanups until regex let me stop.

DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular ...

With a renewed mandate to focus on consumer prices and affordability, the Virginia General Assembly is curiously advancing a proposal it just can’t seem to shake: legalizing convenience store slot ...

Today is Microsoft's August 2025 Patch Tuesday, which includes security updates for 107 flaws, including one publicly disclosed zero-day vulnerability in Windows Kerberos. This Patch Tuesday also ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions.

Microsoft plans to add a feature to Office Excel that will make it harder for cyberattackers to exploit the spreadsheet application's "add-ins" function to run malicious code on a victim's computer.

An Excel macro is an abbreviation for macroinstruction—a sequence of commands (or directives) that tell a computer program or a programming language (such as Visual Basic, C, Assembler, PHP, etc.) to ...