English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 51 lectures (4h 28m) | 2.04 GB
The ultimate guide to using the new Python In Excel feature
Unlock the full potential of Excel by using Python in Excel into your workflow. In this comprehensive course, we will take a deep dive into the revolutionary Python in Excel feature, transforming you from a beginner to an expert in leveraging Python’s capabilities within Excel.
Here’s what you will learn:
Foundation of Python: Kickstart your journey with an introduction to Python basics, understanding data types like lists, tuples, sets, and dictionaries, all while operating within the familiar environment of Excel.
Function Crafting: Step-by-step tutorials on crafting Python functions will empower you to perform complex operations with ease.
Package Utilization: Discover the richness of Python packages available and learn how to integrate them in Excel to enhance its functionalities.
Control Flow Mastery: Get hands-on experience with Python control structures including ‘if’, ‘for’, and ‘while’ statements, to bring logic and flexibility to your Excel sheets.
Project-Based Learning: Undertake a real-world project analyzing sales orders to hone your skills and learn practical applications of Python in Excel.
Bonuses you’ll walk away with:
Comprehensive Package Guide: Receive an exhaustive write-up detailing all the packages available in Python for Excel, serving as a ready reference for your future projects.
Exclusive Bonus Spreadsheet: Gain access to a specially crafted spreadsheet that assists in determining the functionalities available for Python in Excel, a tool designed to facilitate smoother operations.
Embark on this learning journey to merge the analytical power of Python with the simplicity of Excel, opening doors to unparalleled efficiency and opportunities in data analysis and reporting.
What you’ll learn
- Introduction to Python in Excel: Master the seamless integration of Python within Excel and unlock the potential of dynamic spreadsheet programming.
- Foundations of Python Data Types in Excel: Dive deep into handling integers, strings, lists, tuples, and dictionaries right inside your spreadsheets.
- Crafting Python Functions in Excel: Learn how to create, call, and optimize Python functions to automate and enhance your Excel tasks.
- Date and Time Mastery with Python in Excel: Understand and manipulate dates and times like never before, leveraging Python’s datetime module.
- Dataframes in Excel with Python: Integrate the power of Pandas dataframes in Excel, streamlining data analysis and transformations.
- Control Flow in Excel using Python: Implement ‘if’, ‘for’, and ‘while’ statements to add advanced logical operations and loops to your Excel processes.
- Harnessing Power Query with Python in Excel: Elevate your data extraction and transformation skills by combining the capabilities of Power Query with Python.
Table of Contents
Introduction
1 Introduction
2 Disclaimer
3 Calculation Options
4 Installing BetaChannel If Required
Basic Python Data Types
5 Excel Workbook Used For Data Types
6 Hello World
7 Python Numbers
8 Python Bool True and False
9 Python Comparisons
10 Python Strings
Python Lists
11 Excel Workbook Used For Lists
12 Python Lists
13 Indexing
14 Nested Lists
15 Type Function
16 Float and List Type
17 Slicing
18 Lists Challenge
Python Tuples Sets and Dictionaries
19 Excel Workbook For This Tuples Sets and Dictionaries
20 Python Tuples
21 Python Sets
22 Python Dictionaries
Python Functions
23 Excel Workbook For Functions
24 Functions Basics
25 Sum Function
26 If Function
27 More Functions
28 Args and Kwargs
Python Pandas DataFrames
29 Excel Workbooks For Dataframes
30 Dataframes Lesson 1
31 Dataframes Lesson 2
32 Selecting Data With loc and iloc
33 Datetime Basics
34 Timedelta
35 Time In Pandas
36 Date Formats
37 Back To Continued
Python If For While
38 Excel Workbook If For While
39 Python Code Blocks
40 Python If Statements
41 Python For Statements
42 Python While Statements
Sales Orders Project
43 Excel Workbook and CSV File For Sales Order Project
44 Sales Order Project Lesson 1
45 Sales Order Project Lesson 2
46 Sales Order Project Lesson 3
47 Sales Order Project Lesson 4
48 Sales Order Project Lesson 5
Additional Material
49 Excel Workbook For Discovering Python Packages
50 Explanation of Python Packages handystuffxlsx WorkBook
51 Brief Descriptions of Each Python Package Available
Resolve the captcha to access the links!