Python for Excel : A Modern Environment for Automation and Data Analysis

Python for Excel : A Modern Environment for Automation and Data Analysis

Description

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 for automating 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 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

Similar Books

ISBN 10: 1593279280
ISBN 13: 9781593279288

09 May 2019
Eric Matthes

ISBN 10: 0134173279
ISBN 13: 9780134173276

22 Sep 2021
David Beazley

ISBN 10: 0137314914
ISBN 13: 9780137314911

19 Jan 2022
David Farley

ISBN 10: 0262525674
ISBN 13: 9780262525671

10 May 2016
Donald A. Norman

ISBN 10: 149209434X
ISBN 13: 9781492094340

11 May 2021
George Mount

ISBN 10: 1423241886
ISBN 13: 9781423241881

01 May 2019
Berajah Jayne

ISBN 10: 1593279922
ISBN 13: 9781593279929

12 Oct 2020
Al Sweigart

ISBN 10: 1491957662
ISBN 13: 9781491957660

01 Nov 2017
Wes McKinney

ISBN 10: 1449361323
ISBN 13: 9781449361327

01 Aug 2015
Foster Provost

ISBN 10: 1593278969
ISBN 13: 9781593278960

17 Jan 2019
Eric Matthes

ISBN 10: 1119514924
ISBN 13: 9781119514923

14 Jun 2019
Michael Alexander

ISBN 10: 1718500742
ISBN 13: 9781718500747

09 Mar 2021
Ron Kneusel