Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software Python

Python Programming for Excel Users - NumPy, Pandas and More!

Learn to Automate Excel with the Power of Python Programming
Rating: 4.6 out of 54.6 (346 ratings)
6,973 students
Created by Derrick Sherrill
Last updated 10/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Python Programming
  • NumPy
  • Pandas
  • Matplotlib

Requirements

  • None

Description

Wanting to learning Python for Excel Use cases? I'll show you the basics here. We'll cover the fundamentals of python, numpy, pandas, and matplotlib, to get you to a functional level of using python with your excel workbooks.


We'll start with a python bootcamp that will get  complete beginner to a python user who can execute scripts and create functions.


Once we complete the bootcamp, we'll go through tools of the trade lessons where you'll learn all the things that can help make you a better python developer.


After completing that, we'll introduce NumPy, and go through practice exercises to get you functional with our first python library, NumPy.


We'll iterate over some more tools of the trade sections for software that will make you a stronger developer.


Then we'll get into the fun part and look at how we can begin using pandas to do our data manipulation tasks.


Throughout the course, the main emphasis is to provide you project use cases that I hope will resemble your own use cases. I want to be coding on your own data ASAP and the goal of the projects is to provide you the tools to do so.

Who this course is for:

  • Excel Users interested in Python

Featured review

Daniel Dobrenz
Daniel Dobrenz
4 courses
3 reviews
Rating: 5.0 out of 5a month ago
I found Derricks videos on YouTube and found them extremely helpful. I'm also taking the Data Science Bootcamp from 365Careers. Once I found out that Python can be used in conjunction with Excel I found that by learning more about preprocessing data and being more comfortable with Excel/Python I'll be able to be more prepared for my first job the Data Science.

Course content

15 sections • 70 lectures • 3h 43m total length

  • Preview02:21

  • Getting Ready to Use Python
    00:15
  • Download Python - Mac OS
    01:38
  • Preview01:21

  • Preview04:43
  • Optional: Atom Setup
    02:11
  • What are Documentations?
    01:16

  • Introduction to Boot Camp I
    00:15
  • Quick Note about Python Script Execution
    00:26
  • Preview05:27
  • Math Operators
    03:57
  • Operators Quiz
    4 questions
  • Data Types & Composite Data Types
    05:58
  • Python Control Flow
    04:47
  • Functions
    03:07

  • Project Description - Make a Search Function
    01:49
  • Project Solution - Make a Search Function
    04:08

  • Methods & Attributes
    03:40
  • Core Python vs. Included Libraries
    02:44
  • What is a Package Manager?
    01:35
  • What are Jupyter Notebooks?
    02:56

  • NumPy - Install
    00:59
  • NumPy Arrays
    05:39
  • (Optional) - Array Practice
    03:50
  • Indexing & Reshaping
    04:25
  • (Optional) Reshaping & Indexing Practice
    04:28
  • Array Math
    04:59
  • (Optional) Array Math Practice
    05:00

  • What is Pandas?
    02:15
  • Pandas DataFrame
    03:25
  • What is Kaggle?
    01:08
  • Preview04:57
  • Data Selection Tools
    06:23
  • Important Methods
    03:11

  • Code Along Intro
    01:15
  • Project - Joining Worksheets
    04:48
  • Project - Performing Calculations
    02:30
  • Preview02:16
  • Project - Viewing Results
    01:49
  • Project - Creating Function
    04:30

  • What is Stack Overflow?
    01:08
  • What is GitHub?
    01:40

Instructor

Derrick Sherrill
Coffee Powered Coder
Derrick Sherrill
  • 4.5 Instructor Rating
  • 2,756 Reviews
  • 44,788 Students
  • 4 Courses

Experience across various industries and roles. I'm a passionate programmer and have a love of python, finance, and anything tech.

My online presence is to help other learn and I really enjoy making content that others enjoy - let me know what I can do to help you on your journey and I'll be happy to help you. Happy coding!

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.