Unlock Excel'S Potential: Harness Python Via The Py Function

PY Function in Excel|| Pandas|| Matplotlib|| Seaborn and more

What you'll learn

Data analysts

Excel or Python users

University students and professionals

General public who wants to learn how to apply python in excel

Requirements

There are no technical prerequisites to follow the course, it will be explained from the most basic, but having knowledge of python and excel will help.

To date, python is only available in Microsoft 365, so an account with a plan will be required.

Description

Welcome to our comprehensive course focusing on leveraging the PY function in Excel! This learning journey is tailored for individuals seeking to unlock the potential of Python within Microsoft Excel, utilizing the PY function to streamline complex tasks and automate processes with precision.What You'll LearnIntroduction to Python and Excel:Recognize the significance of Python's integration into Excel.Acquire familiarity with Python's ecosystem within Excel.The PY Function:Detailed exploration of the PY function and its application in Excel.Master running and managing Python scripts directly from your spreadsheets.Python Libraries in Excel:Practical implementation of diverse Python libraries like NumPy and Pandas to efficiently handle Excel data.Crafting custom charts and conducting advanced data analyses.Practical Applications:Real-world scenarios demonstrating the synergy between Python and Excel.Prerequisites: While a basic understanding of Excel and Python is beneficial, it's not mandatory as we cover foundational aspects within the course.What's Included:Engaging video lessons and comprehensive tutorials.Access to downloadable resources, including sample spreadsheets.Engaging projects and exercises to reinforce your learning.Ongoing support from our vibrant community and instructor guidance.A certification of accomplishment upon finishing the course.Join Us! Embark on a transformative journey where Python seamlessly integrates with Excel, elevating your analytical prowess, streamlining automation, and enhancing decision-making capabilities. If you're eager to grasp the full potential of the PY function in Excel and wield indispensable tools for professional triumph, this course is tailor-made for you!Enroll today and kickstart your path toward mastering Excel empowered by Python. Our classroom awaits your arrival!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Course Materials

Lecture 2 Course Materials

Section 3: Microsoft Insider

Lecture 3 Insider Program

Section 4: Basics

Lecture 4 How to use PY Function

Lecture 5 The Python Output

Lecture 6 Diagnostics

Lecture 7 Initialization

Lecture 8 Rules to refer the code

Section 5: Python Review, but in Excel!

Lecture 9 String

Lecture 10 Numbers

Lecture 11 List

Lecture 12 Tuples

Lecture 13 Dictionaries

Lecture 14 Sets

Lecture 15 Range and NoneType

Lecture 16 Conditions

Lecture 17 For Loop

Lecture 18 Functions

Section 6: Use of Python Libraries in Excel

Lecture 19 Overview of Python Libraries in Excel

Section 7: Pandas

Lecture 20 Dataframe: Basic Analysis

Lecture 21 Loc v.s iloc

Lecture 22 Loc

Lecture 23 Iloc

Lecture 24 Direct Selection

Lecture 25 Queries

Lecture 26 Duplicates

Lecture 27 Concat and Merge

Lecture 28 Reshape: from long to wide

Lecture 29 Reshape: from wide to long

Lecture 30 Missing Values

Section 8: Visualization: matplotlib and seaborn

Lecture 31 Matplotlib: A line plot

Lecture 32 Matplotlib: Scatter

Lecture 33 Seaborn

Lecture 34 More Graphs

Section 9: Statsmodels

Lecture 35 Creating the Model

Lecture 36 Prediction

Excel or Python users who want to combine the power of both tools