Python for Excel : A Modern Environment for Automation and Data Analysis - Felix Zumstein

Python for Excel

A Modern Environment for Automation and Data Analysis

By: Felix Zumstein

Paperback | 16 March 2021

At a Glance

Paperback


RRP $125.50

$55.25

56%OFF

or 4 interest-free payments of $13.81 with

 or 
In Stock and Aims to ship in 1-2 business days

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel 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 xlwings, a popular open source package that allows the automation of Excel with Python--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 adopted Python for 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 pandas 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 xlwings 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

More in Web Programming

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$50.35

33%
OFF
Starting Out with Python : 5th Global Edition - Tony Gaddis

RRP $138.95

$112.25

19%
OFF
The Art of SEO : Mastering Search Engine Optimization - Eric Enge
Head First Java, 3rd Edition : A Brain-Friendly Guide - Bert Bates
Java How to Program, Early Objects : 11th Global Edition - Paul Deitel
Modern PHP : New Features and Good Practices - Josh Lockhart

RRP $57.00

$28.25

50%
OFF
The Practice of Computing Using Python, Global Edition : 3rd Edition - Richard Enbody
Learning Go : An Idiomatic Approach to Real-World Go Programming - Jon Bodner