Python In Excel: Zero To Hero

Focused View

Jared Self

3:54:59

58 View

1 - Introduction

1 - Introduction.mp4

01:39

2 - Disclaimer.mp4

03:06

3 - Calculation Options.mp4

02:18

4 - Installing BetaChannel If Required.mp4

02:57

2 - Basic Python Data Types

5 - 01-Python-In-Excel-Intro.xlsx

5 - 01-hello-world.xlsx

5 - 02-BasicDataTypes.xlsx

5 - Excel Workbook Used For Data Types.html

6 - Hello World.mp4

04:23

7 - Python Numbers.mp4

07:25

8 - Python Bool True and False.mp4

02:01

9 - Python Comparisons.mp4

01:16

10 - Python Strings.mp4

05:09

3 - Python Lists

11 - Excel Workbook Used For Lists.html

11 - Just-Lists.xlsx

12 - Python Lists.mp4

02:45

13 - Indexing.mp4

02:45

14 - Nested Lists.mp4

06:13

15 - Type Function.mp4

02:09

16 - Float and List Type.mp4

01:01

17 - Slicing.mp4

04:09

18 - Lists Challenge.mp4

10:58

4 - Python Tuples Sets and Dictionaries

19 - Excel Workbook For This Tuples Sets and Dictionaries.html

19 - Tuples-Sets-Dictionaries.xlsx

20 - Python Tuples.mp4

05:01

21 - Python Sets.mp4

03:54

22 - Python Dictionaries.mp4

08:48

5 - Python Functions

23 - 04-functions.xlsx

23 - Excel Workbook For Functions.html

24 - Functions Basics.mp4

03:11

25 - Sum Function.mp4

01:23

26 - If Function.mp4

03:29

27 - More Functions.mp4

06:12

28 - Args and Kwargs.mp4

07:18

6 - Python Pandas DataFrames

29 - 05-dataframes.xlsx

29 - 06-datetime.xlsx

29 - 07-dataframes-continued.xlsx

29 - Excel Workbooks For Dataframes.html

30 - Dataframes Lesson 1.mp4

21:07

31 - Dataframes Lesson 2.mp4

02:18

32 - Selecting Data With loc and iloc.mp4

03:34

33 - Datetime Basics.mp4

05:04

34 - Timedelta.mp4

03:50

35 - Time In Pandas.mp4

02:17

36 - Date Formats.mp4

04:29

37 - Back To Continued.mp4

07:45

7 - Python If For While

38 - 08-if-for-while.xlsx

38 - Excel Workbook If For While.html

39 - Python Code Blocks.mp4

01:12

40 - Python If Statements.mp4

11:51

41 - Python For Statements.mp4

06:53

42 - Python While Statements.mp4

03:58

8 - Sales Orders Project

43 - 09-with-power-query.xlsx

43 - Excel Workbook and CSV File For Sales Order Project.html

43 - Sales-Orders.csv

44 - Sales Order Project Lesson 1.mp4

11:18

45 - Sales Order Project Lesson 2.mp4

08:27

46 - Sales Order Project Lesson 3.mp4

11:12

47 - Sales Order Project Lesson 4.mp4

13:36

48 - Sales Order Project Lesson 5.mp4

12:16

9 - Additional Material

49 - Excel Workbook For Discovering Python Packages.html

49 - handy-stuff.xlsx

50 - Explanation of Python Packages handystuffxlsx WorkBook.mp4

04:22

51 - Brief Descriptions of Each Python Package Available.html

Description

The ultimate guide to using the new Python In Excel feature

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.

Who is this for?

Excel Enthusiasts: Individuals looking to supercharge their Excel capabilities by using Python in Excel for more dynamic spreadsheet tasks.

Data Analysts and Professionals: Those aiming to elevate their data manipulation, transformation, and analysis skills within Excel using Python's powerful libraries.

Beginners in Programming: Anyone new to programming but familiar with Excel, seeking a hands-on approach to learning Python in a familiar environment.

Business Professionals: Individuals in accounting, finance, marketing, sales, HR, and other sectors who regularly use Excel and want to automate and enhance their workflows.

Students: Academics looking to leverage Python in Excel for research, data analysis, or project work.

Excel Trainers and Consultants: Professionals seeking to update their skill set and offer training or consulting services on the latest Excel features, including Python integration.

What You Need to Know?

Basic Excel Proficiency: Familiarity with Excel's interface and fundamental features such as worksheets, rows, columns, and basic formulas.

Willingness to Learn Python: No prior Python knowledge required! We'll guide you through the basics and get you scripting in no time.

Access to the Latest Version of Excel (Possibly BetaChannel): Ensure you have the latest version of Excel that supports the Python integration feature. If not I'll teach you how to turn on Beta Channel.

A Computer with Excel Installed: Whether you're on Windows or Mac, ensure you have a device capable of running Excel.

An Open Mind: Be ready to embrace the blend of traditional spreadsheet tasks with the dynamism of Python scripting.

Active Internet Connection: Required for downloading resources, accessing course updates, and seeking online help or additional Python in Excel examples during the course.

More details

Description
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.
Who this course is for:
Excel Enthusiasts: Individuals looking to supercharge their Excel capabilities by using Python in Excel for more dynamic spreadsheet tasks.
Data Analysts and Professionals: Those aiming to elevate their data manipulation, transformation, and analysis skills within Excel using Python's powerful libraries.
Beginners in Programming: Anyone new to programming but familiar with Excel, seeking a hands-on approach to learning Python in a familiar environment.
Business Professionals: Individuals in accounting, finance, marketing, sales, HR, and other sectors who regularly use Excel and want to automate and enhance their workflows.
Students: Academics looking to leverage Python in Excel for research, data analysis, or project work.
Excel Trainers and Consultants: Professionals seeking to update their skill set and offer training or consulting services on the latest Excel features, including Python integration.

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Excel

Jared Self

Instructor's Courses

Hello, my name is Jared. I’m an accountant, not necessarily a programmer. However, when I first started doing audits I discovered VBA. To me, it was like finding a secret treasure chest that was going to save me from doing everything manually. So I dabbled for a few years, automated some cool things, and learned what I could. As I began to get heavier into the language, I incorporated Power Pivot, MS Access, API calls, etc.. I stumbled through frustration after frustration before I finally came to the realization that VBA just wasn’t going to cutting it.So back to square one with a new language. I did bootcamps, tutorials, learned some C#, JavaScript, SQL, etc. but still didn’t find something I thought was good for accounting. What I didn’t realize was I was looking for a language that was easy to learn, familiar if I knew excel, could be automated, was well documented, had a good community, worked with Quickbooks, and worked well with data.Then I was introduced to Python. I took a couple of courses online and instantly fell in love with the language. It could do it all! Only problem was there wasn’t really any tutorials out there for Accountants. I waded through a bunch of website building and data science tutorials and pieced together little tricks here and there, but it was really slow going. Then I hired a professional developer to tutor me and help me solve a bunch of problems that didn’t have any solutions at the time. The thing was, I didn’t want to build websites or become a data scientist, I wanted to do Accounting. But with a lack material out there for accountants, I had to filter out hundreds of hours of lectures to get the hidden gems. Even after I did that I still had to come up with most things myself. After doing it for a while I realized other accountants were having the same problems I came across.So here you are. This course is dedicated to teaching you how to leverage the power of Python for your accounting job. As you learn I’m sure you’ll fall in love with the language as I did.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.