Excel might be the world's most widely used programming language; Microsoft is on a journey to turn it into a better and more powerful programming language, without losing what makes it Excel.

Some tasks, such as exploratory data analysis, are best handled through Python or R programming. Python is designed for real-time calculations and Excel is better for advanced data calculations ...