{"product_id":"python-in-excel-step-by-step-paperback-softback-9781394340767","title":"Python in Excel Step-by-Step (Paperback \/ softback) 9781394340767","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003ePython in Excel Step-by-Step\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eDavid Langer (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781394340767, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 29 December 2025\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e272 pages\u003cbr\u003e23.1 x 18.5 x 2.3 cm, 0.544 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eAn intuitive guide for professionals wanting to prepare for the future of Microsoft Excel by building Python in Excel skills and unleashing the power of their data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA hands-on guide to the foundational Python in Excel skills you’ll need to understand and use this powerful analytics tool, \u003ci\u003ePython in Excel Step-by-Step\u003c\/i\u003e is for current Excel users interested in expanding their data analysis skillset with Python. Analytics educator and Microsoft Excel MVP David Langer demonstrates how to use Python in Excel, to unlock new analytics capabilities in Excel, and build your foundation for the future of Excel: do-it-yourself (DIY) data science.\u003c\/p\u003e \u003cp\u003eThe book leverages your existing Excel knowledge to learn the Python foundation you can apply right away. This is the same approach David has used to successfully teach more than 1,000 professionals Python – even if you’ve never written code before. David also includes:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTargeted coverage of the Python fundamentals required for analytics – learn just what you need fast\u003c\/li\u003e \u003cli\u003eHow to use the powerful pandas and plotnine libraries to facilitate data manipulation and visualization using Python in Excel\u003c\/li\u003e \u003cli\u003eA DIY data science roadmap for you to build the skills you need to unleash the power of your data to have more impact at work\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003ePerfect for professionals use Microsoft Excel for data analysis, like marketing managers, financial analysts, and supply chain manager, \u003ci\u003ePython in Excel Step-by-Step\u003c\/i\u003e is an invaluable new resource for all business professionals who use Excel and want to build skills for Excel’s AI-powered future.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eACKNOWLEDGMENTS XIII\u003cbr\u003eABOUT THE AUTHOR XV\u003cbr\u003eABOUT THE TECHNICAL EDITORS XVII\u003cbr\u003eINTRODUCTION XIX\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 1: INTRODUCING PYTHON IN EXCEL 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Introducing Python in Excel 1\u003cbr\u003e1.2 How Python in Excel Works 2\u003cbr\u003e1.3 Why Python in Excel? 5\u003cbr\u003e1.4 Continue Your Learning 11\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 2: DATA TYPES 13\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Integers 15\u003cbr\u003e2.2 Floats 17\u003cbr\u003e2.3 Strings 19\u003cbr\u003e2.4 Booleans 26\u003cbr\u003e2.5 Continue Your Learning 31\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 3: DATA STRUCTURES 33\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Lists 33\u003cbr\u003e3.2 Dictionaries 41\u003cbr\u003e3.3 Tuples 49\u003cbr\u003e3.4 Sets 51\u003cbr\u003e3.5 Slicing Data 55\u003cbr\u003e3.6 Continue Your Learning 59\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 4: CONTROL FLOW AND LOOPS 61\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 if\/else Statements 61\u003cbr\u003e4.2 for Loops 69\u003cbr\u003e4.3 while Loops 73\u003cbr\u003e4.4 Comprehensions 76\u003cbr\u003e4.5 Continue Your Learning 83\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 5: FUNCTIONS 85\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Introducing Functions 85\u003cbr\u003e5.2 Lambdas 96\u003cbr\u003e5.3 Continue Your Learning 99\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 6: DATA TABLE FUNDAMENTALS 101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Introducing Pandas 101\u003cbr\u003e6.2 Loading Data 104\u003cbr\u003e6.3 Exploring Dataframes 109\u003cbr\u003e6.4 The Workbook So Far 119\u003cbr\u003e6.5 Continue Your Learning 120\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 7: WORKING WITH COLUMNS 121\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Exploring Columns 121\u003cbr\u003e7.2 Numeric Columns 128\u003cbr\u003e7.3 String Columns 138\u003cbr\u003e7.4 Datetime Columns 151\u003cbr\u003e7.5 The Workbook So Far 158\u003cbr\u003e7.6 Continue Your Learning 160\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 8: WORKING WITH DATA TABLES 161\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 AdventureWorks Data Analysis 161\u003cbr\u003e8.2 Changing Dataframes 161\u003cbr\u003e8.3 Filtering Dataframes 174\u003cbr\u003e8.4 Combining Dataframes 184\u003cbr\u003e8.5 Pivoting Dataframes 193\u003cbr\u003e8.6 The Workbook So Far 205\u003cbr\u003e8.7 Continue Your Learning 207\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 9: DATA VISUALIZATION 209\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 Introducing Plotnine 209\u003cbr\u003e9.2 Categorical Visualizations 211\u003cbr\u003e9.3 Time Series Visualizations 235\u003cbr\u003e9.4 The Workbook 243\u003cbr\u003e9.5 Continue Your Learning 243\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 10: YOUR DIY DATA SCIENCE ROADMAP 245\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 You've Got This 245\u003cbr\u003e10.2 The Roadmap 246\u003cbr\u003e10.3 AI with Copilot in Excel 254\u003cbr\u003e10.4 Continue Your Learning 260\u003c\/p\u003e \u003cp\u003eINDEX 261\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business applications [\u003ca title=\"See our other books on Business applications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20applications%20%5BUF%5D%22\"\u003eUF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52453381669144,"sku":"9781394340767","price":28.35,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781394340767.jpg?v=1785283651","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/python-in-excel-step-by-step-paperback-softback-9781394340767","provider":"Freshly Printed Books","version":"1.0","type":"link"}