Whileremains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include as an scripting language-in fact, it’s the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein- creator of , a popular open source package that allows the automation of Excel with -shows experienced Excel users how to integrate these two worlds efficiently.
Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adoptedfor their daily automation tasks. This guide gets you started.
- Use Python without extensive programming knowledge
- Get started with modern tools, including Jupyter notebooks and Visual Studio Code
- Use to acquire, clean, and analyze data and replace typical Excel calculations
- Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports
- Use to build interactive Excel tools that use Python as a calculation engine
- Connect Excel to databases and CSV files and fetch data from the internet using Python code
- Use Python as a single tool to replace VBA, Power Query and Power Pivot
Author: Felix Zumstein
Length: 315 pages
Publisher: O'Reilly Media
Publication Date: 2021-08-17