{"product_id":"python-for-excel-users-isbn-9781718503984","title":"Python for Excel Users","description":"\u003cb\u003eWhen Excel isn’t enough, it’s time to learn Python.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003eIf you’re comfortable in Excel, but you’ve hit a wall—slow files, broken formulas, hours spent on repetitive tasks—this book offers a way forward. It shows you how to take the work you already do in spreadsheets and make it faster, smarter, and more powerful with Python.\u003cbr\u003e\u003cbr\u003eYou’ll start by setting up your environment and getting comfortable with Python through short, Excel-inspired exercises. From there, you’ll gradually move into writing scripts that automate manual work, structure your data, and generate consistent results—no prior programming knowledge required.\u003cbr\u003e\u003cbr\u003eYou’ll use your preexisting Excel skills to learn how to:\u003cbr\u003e\u003cul\u003e\n\u003cli\u003eTranslate spreadsheet logic into Python code\u003c\/li\u003e\n\u003cli\u003eUse pandas to clean, reshape, and filter data\u003c\/li\u003e\n\u003cli\u003eAutomate reports you’d normally build by hand\u003c\/li\u003e\n\u003cli\u003eRead and write Excel files directly from Python\u003c\/li\u003e\n\u003cli\u003eConnect to databases and APIs\u003c\/li\u003e\n\u003cli\u003eCreate professional visualizations with Plotly and Dash\u003c\/li\u003e\n\u003cli\u003eOrganize code into sharable modules and write simple tests \u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003eThroughout the book, you’ll find practical examples that show why and how to move your work out of spreadsheets and into scripts, and how to resolve issues along the way.\u003cbr\u003e\u003cbr\u003eAuthor Tracy Stephens has extensive practical experience with both Excel and Python. Her approach is grounded in real workflows, and she introduces each concept through tasks you’ve likely handled in Excel.\u003cbr\u003e\u003cbr\u003eThis book won’t ask you to replace everything you do in spreadsheets, but it will help you use Python to work faster, more reliably, and with greater flexibility than you ever could with Excel.Introduction\u003cbr\u003e\u003cbr\u003ePART I: FROM SPREADSHEETS TO CODE\u003cbr\u003eChapter 1: Python Setup Essentials to Get You Started\u003cbr\u003eChapter 2: Python Concepts Explained Through Excel\u003cbr\u003eChapter 3: Creating Automations with Python Scripts\u003cbr\u003eChapter 4: Keeping Track of Code with Version Control\u003cbr\u003e\u003cbr\u003ePART II: DATA ANALYSIS DONE RIGHT\u003cbr\u003eChapter 5: Interactive Coding for Data Analysis\u003cbr\u003eChapter 6: Data Manipulation Made Easy\u003cbr\u003eChapter 7: Storing and Accessing Data with a Database\u003cbr\u003eChapter 8: Retrieving External Data with APIs\u003cbr\u003eChapter 9: Visualizing Data with Charts\u003cbr\u003eChapter 10: Sharing Data with Interactive Reports\u003cbr\u003e\u003cbr\u003ePART III: CRAFTING GOOD CODE\u003cbr\u003eChapter 11: Writing Simple, Scalable Code with Classes\u003cbr\u003eChapter 12: Debugging and Testing Your Code\u003cbr\u003eChapter 13: Three Habits for Effective Coding\u003cbr\u003e\u003cbr\u003eAfterword\u003cb\u003eTracy Stephens\u003c\/b\u003e 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.","brand":"No Starch Press","offers":[{"title":"Default Title","offer_id":48233496903909,"sku":"NP9781718503984","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781718503984.jpg?v=1767735248","url":"https:\/\/k12savings.com\/es\/products\/python-for-excel-users-isbn-9781718503984","provider":"K12savings","version":"1.0","type":"link"}