Python for Excel Users: A Beginner’s Guide

Introduction: Elevate Your Analytics with Python

In today’s data-driven world, the ability to efficiently analyze and interpret information is more crucial than ever, especially in the business sector. Python for Excel Users: A Beginner’s Guide is tailored for business students and professionals who are proficient in Microsoft Excel but are ready to embark on their Python journey. As a powerful and versatile programming language, Python has become indispensable in data analysis. This book bridges the gap between Excel and Python by providing parallel exercises that demonstrate how Python can amplify business analytics tasks with unmatched efficiency and flexibility.

Through its side-by-side comparisons, interactive Python exercises, and a ＂teachable moment＂ approach, this guide offers a unique and intuitive learning experience. By translating familiar Excel tasks into Python’s dynamic and versatile ecosystem, you’ll not only enhance your data analysis skills but also gain confidence in programming.

Why Python?

Did you know that Python powers cutting-edge technologies like ChatGPT? Indeed, Python forms the foundation of many machine learning algorithms, including large language models (LLMs). Python is more than a programming language; it’s a tool for understanding and shaping the digital world. Despite its advanced capabilities, Python’s simple, readable syntax makes it accessible to everyone - from professional software developers to citizen developers like you. Dubbed the ＂language of the people,＂ Python is revolutionizing how we approach problem-solving and automation in the modern world.

Becoming Tomorrow’s Tech- Savvy Leaders

The leaders of tomorrow are not just visionaries - they are innovators who harness the power of technology to drive change and inspire others. This book guides you through different scenarios to help you understand the connections between business questions and analytics steps we are taking.

As business students embracing Python, you’re positioning yourselves as future-ready leaders equipped to navigate and excel in the complexities of modern business.

Welcome to a journey that will elevate your analytics, expand your technological fluency, and transform you into a tech-savvy leader of the future.

Dr. Chi-Chun Chou is a Professor of Accounting at the College of Business, California State University, Monterey Bay. His academic background encompasses both computer science and accounting, enabling him to broaden the scope of Accounting Information Systems (AIS), including Deep Learning, Large Language Models, Machine Learning, Data Analytics, Robotic Process Automation, and Blockchain. He has contributed scholarly articles incorporating various technologies to esteemed publications such as the Computers and Industrial Engineering, Journal of Information Systems, International Journal of Accounting Information Systems, and Journal of Emerging Technologies in Accounting and also serves as a Domain Editor for the Journal of Emerging Technologies in Accounting and is an Editorial Member for the Journal of Information Systems.

Tawei (David) Wang is a KPMG/Neil F. Casson Endowed Professor at DePaul University. He is currently an Associate Editor of Information and Management and the Co-Senior Editor of the Journal of Information Systems. His research interests are information security management and IT management, and his papers have appeared in several leading journals, including Accounting Horizons, Auditing: A Journal of Practice and Theory, Decision Support Systems, European Journal of Information Systems, Information and Management, Information Systems Journal, Information Systems Research, International Journal of Accounting Information Systems, Journal of Accounting and Public Policy, Journal of Banking and Finance, Journal of Information Systems, among others. He mainly teaches audit data analytics and has been invited by universities and conferences to discuss analytics teaching strategies. He was a Fulbright Specialist focusing on data analytics curriculum design in accounting programs.