Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation Sound Therapy CBT Cognitive Behavioral Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

BusinessBusiness Analytics & IntelligenceExcel Charts

Control Excel with Python & OpenPyXL

Become an Excel Power User with Python & OpenPyXL
Rating: 4.0 out of 54.0 (498 ratings)
3,373 students
Created by Conny Söderholm
Last updated 1/2021
English
English

What you'll learn

  • Controlling Excel with Python
  • Automate Excel with Python
  • How to use OpenPyXL

Requirements

  • Basic Python Knowledge
  • Some kind of .xlsx viewer, like Excel or OpenOffice

Description

Requirements

  • Basic Python knowledge - Don't worry, we will cover each code snippet

  • You will need a computer with Python 3 installed, then we will cover how to install OpenPyXL

  • Some form of spreadsheet program. I use Excel, but you can also use OpenOffice or similar applications

Description

Become an Excel Power User - Learn how to control & automate Excel with Python and OpenPyXL

Do you have a bunch of Excel files that you need to format or put some value in a cell on each page? Do you need to create Charts on your spreadsheets or insert formulas? Maybe you just want to show off at the office! Whatever your needs, you can expect a comprehensive guide going through the nuts and bolts of how automating Excel works. The course dives straight into OpenPyXL, so you will be up and running creating and manipulating spreadsheets in no-time.

I have had so much use of OpenPyXL when dealing with spreadsheets. You can create advanced sorts and filters, insert and delete rows, copy cells, set custom formatting and much more. I even got a job based on my OpenPyXL knowledge. I am sure you will benefit from learning OpenPyXL if you have even the slightest interest in making your everyday life easier.


After taking this course you will:

  • Know how to create and manipulate Workbooks and Sheets

  • Read cell data with absolute and relative references

  • Iterate over cells and perform actions on each cell

  • Know how to delete rows and columns

  • Insert formulas and tables

  • Format your spreadsheets with fonts, colors and cell types

  • Understand how you could apply this knowledge to your own work

  • Create files and folders

  • Interact with open and save file dialogs

Whether it's gaming, business, engineering, or data you're passionate about, this course will give you everything you need for working on spreadsheets with Python. Take this course today, and begin your journey to having a full-fledged career as an Excel Power User!

Who this course is for:

  • Anyone interested in controlling and automating Excel with Python - with or without coding experience. People who want to get rid of manually editing hundreds of spreadsheets by hand

  • Especially suitable for those who would like to extract or add data on multiple spreadsheets or automate the creation of spreadsheets from input data

  • People who would like to know more about solving Excel problems with Python

  • People who would like to start consulting services by automating Excel tasks

Who this course is for:

  • Beginner and Intermediate Python users who want to automate Excel
  • Users who want to become an Excel Power User

Instructor

Conny Söderholm
Engineer with a passion for Excel and Python
Conny Söderholm
  • 4.0 Instructor Rating
  • 515 Reviews
  • 3,496 Students
  • 2 Courses

Welcome, glad that you could make it!

Do you enjoy tinkering with Excel? Would you like to become the most advanced Excel Super User around the office? Maybe you have a lot of Excel spreadsheets that you need to manipulate?

If you fire up Excel whenever you need to do something, you have come to the right place! Join me and find out how to manipulate Excel with Python, and discover the possibilities of using Python as a scripting language.

Excel can produce a lot of PDF material also. That is why I created another course about using PyPDF2 to manipulate your PDF documents as well with Python.

About Conny:

I am a certified European Engineer (EUR-ING) with a passion for programming. I studied programming as one of my minors at Aalto University, from where I got my Master's degree in Mechanical Engineering.





Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.