Python in Excel Step-by-Step

Nyhet

Häftad, Engelska, 2025

539 kr

Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.

An 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.A hands-on guide to the foundational Python in Excel skills you’ll need to understand and use this powerful analytics tool, Python in Excel Step-by-Step 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.The 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: Targeted coverage of the Python fundamentals required for analytics – learn just what you need fastHow to use the powerful pandas and plotnine libraries to facilitate data manipulation and visualization using Python in ExcelA DIY data science roadmap for you to build the skills you need to unleash the power of your data to have more impact at workPerfect for professionals use Microsoft Excel for data analysis, like marketing managers, financial analysts, and supply chain manager, Python in Excel Step-by-Step is an invaluable new resource for all business professionals who use Excel and want to build skills for Excel’s AI-powered future.

Produktinformation

Utgivningsdatum2025-12-29
Mått185 x 231 x 23 mm
Vikt544 g
FormatHäftad
SpråkEngelska
Antal sidor272
FörlagJohn Wiley & Sons Inc
ISBN9781394340767

Tillhör följande kategorier

ACKNOWLEDGMENTS XIIIABOUT THE AUTHOR XVABOUT THE TECHNICAL EDITORS XVIIINTRODUCTION XIXCHAPTER 1: INTRODUCING PYTHON IN EXCEL 11.1 Introducing Python in Excel 11.2 How Python in Excel Works 21.3 Why Python in Excel? 51.4 Continue Your Learning 11CHAPTER 2: DATA TYPES 132.1 Integers 152.2 Floats 172.3 Strings 192.4 Booleans 262.5 Continue Your Learning 31CHAPTER 3: DATA STRUCTURES 333.1 Lists 333.2 Dictionaries 413.3 Tuples 493.4 Sets 513.5 Slicing Data 553.6 Continue Your Learning 59CHAPTER 4: CONTROL FLOW AND LOOPS 614.1 if/else Statements 614.2 for Loops 694.3 while Loops 734.4 Comprehensions 764.5 Continue Your Learning 83CHAPTER 5: FUNCTIONS 855.1 Introducing Functions 855.2 Lambdas 965.3 Continue Your Learning 99CHAPTER 6: DATA TABLE FUNDAMENTALS 1016.1 Introducing Pandas 1016.2 Loading Data 1046.3 Exploring Dataframes 1096.4 The Workbook So Far 1196.5 Continue Your Learning 120CHAPTER 7: WORKING WITH COLUMNS 1217.1 Exploring Columns 1217.2 Numeric Columns 1287.3 String Columns 1387.4 Datetime Columns 1517.5 The Workbook So Far 1587.6 Continue Your Learning 160CHAPTER 8: WORKING WITH DATA TABLES 1618.1 AdventureWorks Data Analysis 1618.2 Changing Dataframes 1618.3 Filtering Dataframes 1748.4 Combining Dataframes 1848.5 Pivoting Dataframes 1938.6 The Workbook So Far 2058.7 Continue Your Learning 207CHAPTER 9: DATA VISUALIZATION 2099.1 Introducing Plotnine 2099.2 Categorical Visualizations 2119.3 Time Series Visualizations 2359.4 The Workbook 2439.5 Continue Your Learning 243CHAPTER 10: YOUR DIY DATA SCIENCE ROADMAP 24510.1 You've Got This 24510.2 The Roadmap 24610.3 AI with Copilot in Excel 25410.4 Continue Your Learning 260INDEX 261