Python in Excel: Unlocking powerful data analysis and automation solutions - Couverture souple

Bastick, Liam; Newitt, Kathryn

 
9780135437971: Python in Excel: Unlocking powerful data analysis and automation solutions
Couverture souple
ISBN 10 : 0135437970 ISBN 13 : 9780135437971
Editeur : Microsoft Press, 2025

Synopsis

Seasoned Experts Liam Bastick and Kathryn Newitt unveil a groundbreaking guide to mastering data analysis and automation with Python in Excel

Python in Excel: Unlocking powerful data analysis and automation solutions is a hands-on, practical guide that leverages the authors’ decades of expertise to teach you how to harness the newly integrated Python capabilities within Microsoft Excel, mapping familiar Excel concepts to Python foundations. Covering essential topics such as Python syntax, data structures, data analysis with pandas, visualization, and the use of complementary tools such as Power Query and Copilot (AI), this book empowers you to elevate your data analysis and automation skills. Readers will gain the ability to perform advanced forecasting, build predictive models, and streamline workflows, making you more efficient and competitive in today’s data-driven workplace.

By reading this book, you will:

  • Understand the fundamentals of Python programming directly within Excel
  • Map your existing Excel skills to Python concepts for easier learning
  • Automate repetitive tasks and workflows
  • Analyze and visualize data with powerful Python libraries like pandas
  • Build advanced forecasting and predictive models without leaving Excel
  • Explore and manipulate data efficiently using Python’s concise syntax
  • Integrate AI tools such as Copilot to assist with coding and analysis
  • Connect Excel with external data sources using Python and Power Query
  • Develop custom solutions for business modeling and data science
  • Prepare for further study and mastery of Python in Excel

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Éditeur
Microsoft Press
Date d'édition
2025
Langue
anglais
ISBN 10 
0135437970
ISBN 13 
9780135437971
Reliure
Broché
Numéro d'édition
1
Nombre de pages
368
Coordonnées du fabricant
Pearson Benelux BV
productsafety@pearson.com

Kabelweg 37
Amsterdam
1014 BA
Pays-Bas