Python for Excel
Python for Excel
Welcome! This course is here to help you automate Excel tasks to gain significant time.
Programming is certainly a word you may have heard when working in Excel. It is often associated with VBA. Python is however an open source programming language that offers way more flexibility and simpler to get started with. Rest assured, I've been working with Python for a few years now and I wanted to offer you the quickest past to automate tasks in your Excel files. No need to know anything about programming, I'll show you how to get started from scratch.
This course does not aim to teach you everything about Python but rather to guide you on your quickest path to success.
Concretely, here's what we'll learn:
How to install Python
The basics of programming
What libraries to use
How to read and write to Excel
How to perform Excel functions in Pythons: VLOOKUP, SUMIF, filters, remove duplicates, etc.
How to use Pandas, OpenPyXl
Some programmer tips and tricks to go beyond and automate further
This course is full of opportunities to apply your knowledge:
There are many hands-on lectures in every section
There are quizzes scattered in most sections
Some practical examples that you can reuse for your own projects
And a proper environment to program and go beyond just Python for Excel
Save time and automate your Excel tasks with Python
Url: View Details
What you will learn
- Automate Excel repetitive tasks with Python
- Work with large Excel documents
- Save time by automating Excel tasks
Rating: 4.15
Level: Beginner Level
Duration: 3.5 hours
Instructor: Nicolas Narbais
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap