Back in late 2023, Microsoft announced Python integration in Excel. Like many, I was skeptical at first and continued to rely on VBA and built-in Excel formulas for data analyses and visualization.

Excel automations cover auto-updating charts, deadline flags, and smart links; Ctrl+T table charts expand as new rows appear.

AI tools are frequently used in data visualization — this article describes how they can make data preparation more efficient ...

It's time to join the Pythonistas.

They’re easy to learn, and they’ll make you a lot more productive. by Adam Lacey and Deborah Ashby The past 10 years have seen a wave of innovative big data software designed to analyze, manipulate, ...

The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The output of the above function will be 5, ...

What if the tools you already use could do more than you ever imagined? Picture this: you’re working on a massive dataset in Excel, trying to make sense of endless rows and columns. It’s slow, ...

Asset tracking is crucial for businesses of all sizes to know what they own and where to find it. But not every business needs a premium solution. Starting with an asset tracking Excel template or a ...

Microsoft's integration of Python into Excel, slated for release in Q3 2024, is a major advance for financial data professionals using Excel as their core analysis tool. This powerful combination ...