Python for Excel Users

Published by Chapman and Hall/CRC, the 1st Edition of Python for Excel Users: A Beginner's Guide is a 360-page textbook crafted for business students and business professionals who have existing Excel proficiency and want to learn Python. Authors Chi-Chun Chou and David Wang focus on translating routine spreadsheet workflows into executable Python code for business analytics.

The text covers essential technical topics, including data exploration, data cleaning routines, and basic numerical computation. Readers practice aggregating data through group-by tools and pivot tables, producing data visualizations, and establishing data rankings. Subsequent sections address conditional functions, what-if analysis, record lookup operations, data segmentation, text manipulation, date processing, and table joining or merging.

By incorporating parallel exercises throughout the modules, the textbook guides learners through step-by-step conversions of spreadsheet actions into Python scripts. This practical focus makes the book suitable for introductory business analytics courses and self-directed professional training.