Snakes in a Grid: Python in Excel

Microsoft Developer · Beginner ·📊 Data Analytics & Business Intelligence ·9mo ago
Spreadsheets are one of the most common ways to share data, and thankfully Python has lots of tools to help! In this tutorial, we will cover some helpful packages like openpyxl and pandas that make working with spreadsheets in Python a breeze. We will also approach the task from the other direction and explore how you can use Python directly in a spreadsheet in Excel to analyze and visualize your data. The session will include practical exercises where attendees will learn how to load, manipulate, and export spreadsheet data using Python. By the end of this tutorial, participants will be equip…
Watch on YouTube ↗ (saves to browser)

Chapters (16)

Intro: Python in Excel Overview
0:14 Why Use Python Instead of VBA
1:15 Security Benefits of Cloud Execution
2:00 How Python Runs in Excel via Anaconda
3:23 Excel Module and Jupyter Kernel Explained
4:27 Data Type Handling in Python Cells
5:02 Speaker Intro: Dr. Sarah Kaiser
5:49 Collaboration Benefits for Data Sharing
6:31 Copilot and Advanced Analysis Mode
6:49 Demo: Getting Started with Python in Excel
7:42 Writing and Running Python Cells
8:57 Switching Between Python and Excel Outputs
10:07 Python and Excel Formula Interoperability
11:01 Output Type: Python Object vs Excel Value
11:59 Using the Formulas Tab for Python Tools
12:27 Restarting Kern

Playlist

Uploads from Microsoft Developer · Microsoft Developer · 0 of 60

← Previous Next →
1 What you need to know about LLMs [Pt 1]
What you need to know about LLMs [Pt 1]
Microsoft Developer
 2 Get started with AI for free using Phi-3 [Pt 6]
Get started with AI for free using Phi-3 [Pt 6]
Microsoft Developer
 3 Azure tools & services for hosting and storing AI apps [Pt 9]
Azure tools & services for hosting and storing AI apps [Pt 9]
Microsoft Developer
 4 Run AI models on your local machine with Ollama [Pt 5]
Run AI models on your local machine with Ollama [Pt 5]
Microsoft Developer
 5 Streaming Generative AI output with the AI Chat Protocol [Pt 10]
Streaming Generative AI output with the AI Chat Protocol [Pt 10]
Microsoft Developer
 6 Essential prompt engineering techniques [Pt 2]
Essential prompt engineering techniques [Pt 2]
Microsoft Developer
 7 Generative AI with JavaScript - Introduction
Generative AI with JavaScript - Introduction
Microsoft Developer
 8 Improve AI accuracy and reliability with RAG [Pt 3]
Improve AI accuracy and reliability with RAG [Pt 3]
Microsoft Developer
 9 Data As a Corporate Asset—the GenAI-era Take (Part 2)
Data As a Corporate Asset—the GenAI-era Take (Part 2)
Microsoft Developer
 10 Boost your local development with Dev Container templates for Azure SQL
Boost your local development with Dev Container templates for Azure SQL
Microsoft Developer
 11 Boost your local development with Dev Container templates for Azure SQL
Boost your local development with Dev Container templates for Azure SQL
Microsoft Developer
 12 What's your favorite use case for Copilot?
What's your favorite use case for Copilot?
Microsoft Developer
 13 What's your favorite use case for Copilot?
What's your favorite use case for Copilot?
Microsoft Developer
 14 How can Copilot help me make my software more accessible?
How can Copilot help me make my software more accessible?
Microsoft Developer
 15 How can Copilot help me make my software more accessible?
How can Copilot help me make my software more accessible?
Microsoft Developer
 16 Database performance and scalability with Azure SQL Database Hyperscale elastic pools | Data Exposed
Database performance and scalability with Azure SQL Database Hyperscale elastic pools | Data Exposed
Microsoft Developer
 17 What languages are supported by Copilot?
What languages are supported by Copilot?
Microsoft Developer
 18 What languages are supported by Copilot?
What languages are supported by Copilot?
Microsoft Developer
 19 Azure Essentials: Improve the reliability, security, and performance of cloud and AI investments
Azure Essentials: Improve the reliability, security, and performance of cloud and AI investments
Microsoft Developer
 20 Use Copilots To Put Esoteric Tools to Work
Use Copilots To Put Esoteric Tools to Work
Microsoft Developer
 21 Data Engineering in Fabric using Copilot | Data Exposed: MVP Edition
Data Engineering in Fabric using Copilot | Data Exposed: MVP Edition
Microsoft Developer
 22 Mr. Maeda's Cozy AI Kitchen - AI Coaching the Coach, with Pat Cavanaugh
Mr. Maeda's Cozy AI Kitchen - AI Coaching the Coach, with Pat Cavanaugh
Microsoft Developer
 23 GitHub Copilot for Azure: Discovering Azure services and AI templates
GitHub Copilot for Azure: Discovering Azure services and AI templates
Microsoft Developer
 24 GitHub Copilot for Azure: Deploying to Azure Kubernetes Service (AKS)
GitHub Copilot for Azure: Deploying to Azure Kubernetes Service (AKS)
Microsoft Developer
 25 GitHub Copilot for Azure: Exploring your Azure resources
GitHub Copilot for Azure: Exploring your Azure resources
Microsoft Developer
 26 GitHub Copilot for Azure: Deploying to Azure with context
GitHub Copilot for Azure: Deploying to Azure with context
Microsoft Developer
 27 GitHub Copilot for Azure: Understanding and managing your models in Azure AI
GitHub Copilot for Azure: Understanding and managing your models in Azure AI
Microsoft Developer
 28 GitHub Copilot for Azure: Planning a migration to Azure
GitHub Copilot for Azure: Planning a migration to Azure
Microsoft Developer
 29 “How does Copilot for Azure SQL work?” and more of your questions answered! | Data Exposed
“How does Copilot for Azure SQL work?” and more of your questions answered! | Data Exposed
Microsoft Developer
 30 How did you get started writing books for Windows and .NET?
How did you get started writing books for Windows and .NET?
Microsoft Developer
 31 Streamline agreement workflows with Docusign
Streamline agreement workflows with Docusign
Microsoft Developer
 32 Deploy OpenAI Services at Scale Using Provision Throughput Units
Deploy OpenAI Services at Scale Using Provision Throughput Units
Microsoft Developer
 33 Automated Deployment from AKS VsCode Extension
Automated Deployment from AKS VsCode Extension
Microsoft Developer
 34 What’s New in SQL Server & Azure SQL | Data Exposed Live @ PASS Summit 2024
What’s New in SQL Server & Azure SQL | Data Exposed Live @ PASS Summit 2024
Microsoft Developer
 35 Microsoft 365 Copilot: Developer Camp
Microsoft 365 Copilot: Developer Camp
Microsoft Developer
 36 Introducing Custom Engine Agents
Introducing Custom Engine Agents
Microsoft Developer
 37 Unlock the Power of Custom Engine Agents
Unlock the Power of Custom Engine Agents
Microsoft Developer
 38 Introducing Declarative Agents
Introducing Declarative Agents
Microsoft Developer
 39 The Future of Declarative Agents
The Future of Declarative Agents
Microsoft Developer
 40 Extending Declarative Agents
Extending Declarative Agents
Microsoft Developer
 41 Developer's Guide to Building Copilot Agents
Developer's Guide to Building Copilot Agents
Microsoft Developer
 42 A Conversation with the Leaders Behind the Developer Tools
A Conversation with the Leaders Behind the Developer Tools
Microsoft Developer
 43 Azure SQL Revealed 2nd Edition Book | Data Exposed
Azure SQL Revealed 2nd Edition Book | Data Exposed
Microsoft Developer
 44 What’s the origins of .NET generics?
What’s the origins of .NET generics?
Microsoft Developer
 45 Essential Azure Skilling and Guidance
Essential Azure Skilling and Guidance
Microsoft Developer
 46 Unlocking Multilingual Accessibility with Co-op Translator: A Case Study on Phi-3 Cookbook
Unlocking Multilingual Accessibility with Co-op Translator: A Case Study on Phi-3 Cookbook
Microsoft Developer
 47 Master Azure Resiliency, Performance, and Security
Master Azure Resiliency, Performance, and Security
Microsoft Developer
 48 Mr. Maeda's Cozy AI Kitchen - Composite AI, with Hiromichi Kobashi
Mr. Maeda's Cozy AI Kitchen - Composite AI, with Hiromichi Kobashi
Microsoft Developer
 49 Build Intelligent Apps on Azure
Build Intelligent Apps on Azure
Microsoft Developer
 50 Tell us a story from the era when you got your 5 (and 3!?!) year service award
Tell us a story from the era when you got your 5 (and 3!?!) year service award
Microsoft Developer
 51 Next Gen Data Analytics with Microsoft Fabric
Next Gen Data Analytics with Microsoft Fabric
Microsoft Developer
 52 Tell us a story from the era when you got your 10-year service award
Tell us a story from the era when you got your 10-year service award
Microsoft Developer
 53 Building the ultimate chatbot on your own data with Azure SQL and Semantic | Data Exposed
Building the ultimate chatbot on your own data with Azure SQL and Semantic | Data Exposed
Microsoft Developer
 54 Trustworthy AI: From Principles to Practice
Trustworthy AI: From Principles to Practice
Microsoft Developer
 55 Tell us a story from the era when you got your 15-year service award
Tell us a story from the era when you got your 15-year service award
Microsoft Developer
 56 Tell us a story from the era when you got your 20-year service award
Tell us a story from the era when you got your 20-year service award
Microsoft Developer
 57 Tell us a story from the era when you got your 25-year service award
Tell us a story from the era when you got your 25-year service award
Microsoft Developer
 58 Tell us a story from the era when you got your 30-year service award
Tell us a story from the era when you got your 30-year service award
Microsoft Developer
 59 Tell us a story from the era when you got your 35-year service award
Tell us a story from the era when you got your 35-year service award
Microsoft Developer
 60 Tell us a story from the era when you got your 40-year service award
Tell us a story from the era when you got your 40-year service award
Microsoft Developer
Excel… is a programming language!?
Next Up
Excel… is a programming language!?
Coding with Lewis