Have you ever found yourself wrestling with Excel formulas, wishing for a more powerful tool to handle your data? Or maybe you’ve heard the buzz about Python in Excel and wondered if it’s truly the ...

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, ...

Microsoft added built-in Python into Excel, starting with Microsoft 365 Insiders. This link allows users to use Python tools to improve the way Excel displays and analyses data. Now just for desktop ...

I've written a lot about data analysis with Python recently. I wanted to explain why it's been a language of choice. Here are some of the reasons I find Python so easy to use, yet powerful. Python ...

You may have heard about NumPy and wondered why it seems so essential to data analysis in Python. What makes NumPy seemingly end up everywhere in statistical calculations with Python? Here are some ...

An intuitive guide for professionals wanting to prepare for the future of Microsoft Excel by building Python in Excel skills ...

Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot component that works with the Shiny web framework and is compatible with R and ...

In recent years, high inflation and global conflict busted economist predictions. How well are your funds or portfolios prepared to weather market surprises? Scenario analysis can help portfolio ...

In my last article, we analyzed our backlinks using data from Ahrefs. This time around, we’re including the competitor backlinks in our analysis using the same Ahrefs data source for comparison. Like ...