What if you could turn Excel into a powerhouse for advanced data analysis and automation in just a few clicks? Imagine effortlessly cleaning messy datasets, running complex calculations, or generating ...

A surprisingly powerful partnership ...

Unlock deeper analytical capabilities by integrating BQL, Bloomberg’s most advanced data API,  with Python via the BQL Object ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?

This article is adapted from an edition of our Off the Charts newsletter originally published in October 2021. Off the Charts is a weekly, subscriber-only guide to The Economist’s award-winning data ...