Python für Excel

Free yourself from the chaos of massive spreadsheets, thousands of formulas, and ugly VBA hacks.

The US bestseller now available in German translation: "Python for Excel" provides the much-needed bridge between two worlds of data analysis. For advanced Excel users looking to simplify their work with Python tools, the basics of Python as well as the tools NumPy and Pandas are explained in an easily understandable way.

Excel remains ubiquitous in the business world. However, requests to integrate Python as a scripting language in Excel are piling up in Microsoft’s feedback forums. What makes this combination so attractive? Felix Zumstein, creator of xlwings, a popular open-source package for automating Excel with Python, demonstrates in this practical guide how experienced Excel users can efficiently merge both worlds.

In recent years, Excel has gained many new features, but the automation language VBA has not evolved in parallel. As a result, many Excel power users are already using Python to automate routine tasks. This book shows you how to use Python for Excel without extensive programming knowledge and how to work with modern tools like Jupyter Notebooks and Visual Studio Code. You will learn, for example, how to collect, clean, and analyze data with Pandas, automate recurring tasks, build interactive Excel tools with xlwings, or replace VBA, Power Query, and Power Pivot with Python as a universal tool.