Gemini can use Python to build data visualization graphics in Sheets You can also interact with it by asking questions about your data However charts won’t auto-update from live data sets ...

It is a handy tool for keeping a record of data explorations, creating charts, styling text and sharing the results of that work. For data analysis, the cornerstone package in Python is “Pandas”.

“You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel’s formulas, charts and PivotTables to further refine your insights,” Kinnestrand wrote.

"Python in Excel combines Python's powerful data analysis and visualization libraries with Excel's features you know and love," Microsoft said. "You can manipulate and explore data in Excel using ...

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.

Microsoft today announced the public preview of Python in Excel, which will allow advanced spreadsheet users to combine scripts in the popular Python language and their usual Excel formulas in the ...