Python for Excel Users

Know Excel? You Can Learn Python

Tracy Stephens (Autor)

Buch | Softcover

200 Seiten

2025
No Starch Press,US (Verlag)
978-1-7185-0398-4 (ISBN)

Artikel merken

Excel is a mainstay of the modern workplace, but it isn't up to every task. Python for Excel Users offers a better way, showing how relatively simple programming can greatly boost productivity by streamlining workflows and adding new tools to the reader's toolbox - no programming experience required. Uses include: Generating beautiful data visualizations, Creating interactive reports and dashboards, Tracking collaborative projects. This book leverages what readers already know about Excel to introduce useful coding applications. Practical examples illustrate how programming skills can be immediately applied to the reader's day-to-day work.

Tracy Stephens is a quantitative developer based in New York City. Her experience includes building systematic trading strategies at some of the world’s top financial institutions. A long-time Python evangelist, she focuses on designing quantitative infrastructure that’s flexible, explainable, and efficient---when she can successfully keep her one-eyed tuxedo cat off her keyboard.

Introduction

PART I: FROM SPREADSHEETS TO CODE
Chapter 1: Python Setup Essentials to Get You Started
Chapter 2: Python Concepts Explained Through Excel
Chapter 3: Creating Automations with Python Scripts
Chapter 4: Keeping Track of Code with Version Control

PART II: DATA ANALYSIS DONE RIGHT
Chapter 5: Interactive Coding for Data Analysis
Chapter 6: Data Manipulation Made Easy
Chapter 7: Storing and Accessing Data with a Database
Chapter 8: Retrieving External Data with APIs
Chapter 9: Visualizing Data with Charts
Chapter 10: Sharing Data with Interactive Reports

PART III: CRAFTING GOOD CODE
Chapter 11: Writing Simple, Scalable Code with Classes
Chapter 12: Debugging and Testing Your Code
Chapter 13: Three Habits for Effective Coding

Afterword

Erscheinungsdatum	12.09.2025
Verlagsort	San Francisco
Sprache	englisch
Maße	177 x 234 mm
Themenwelt	Informatik ► Datenbanken ► Data Warehouse / Data Mining
	Informatik ► Office Programme ► Excel
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
ISBN-10	1-7185-0398-9 / 1718503989
ISBN-13	978-1-7185-0398-4 / 9781718503984
Zustand	Neuware