I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth.
Best Python Excel Course - Python with Excel Tutorial | GoSkills
Python with Excel
Combine the power of Python with Excel to analyze data and automate tasks.
- 4.5 49 reviews
- 5h 11m study time
- 3h 9m video
- Get an accredited certificate
- 14-day money-back guarantee
About this course
In this beginner-friendly course, you will learn how to use Python with Excel in tandem to drastically improve your data crunching and analysis skills.
In 40 short lessons, you will combine the power of Python and Excel using openpxyl to create, manipulate, and present data.
By the end of the course, you will be able to create spreadsheets, crunch data, and present information as charts and graphs solely using Python commands.
Using Python for Excel is ideal for those who work closely with databases or large spreadsheets, or who are interested in learning more about data analytics.
The course only requires a basic understanding of Excel and doesn’t require any previous Python or coding experience.
In this course, you will learn how to:
- Download and install Python, Sublime Text, Git Bash, and Python openpxyl
- Create your first python program
- Use variables, print (), lists, tuples, and loops
- Create workbooks and worksheets using Python
- Read and open Excel files in Python
- Use Excel formulas in the Python terminal
- Manipulate data and spreadsheets using Python
- Format and style spreadsheets using Python
- Create basic and advanced charts and graphs
- Create and manipulate tables
- Add images to Excel spreadsheets using Python
Want to learn more Python skills? Check out the Intro to Python and Python for Data Analysis courses.
Syllabus
7 sections · 40 lessons · 3h 9m total
Introduction To Python Programming
- 1. Your First Python Program In this lesson, we'll create our first Python program, called hello.py. 4m View lesson
- 2. Python Variables and Print() In this lesson, we'll discuss how to store data within your program using variables and how to display them using the Print() command. 5m View lesson
- 3. Python Lists Python lists are used to keep track of a list of items. They can be text, numbers, variables, other lists and more. 5m View lesson
- 4. Python Tuples Tuples are just like lists, but they can't be changed once created. Let's discuss how to create and reference them. 4m View lesson
- 5. Python For Loops For loops are used to loop through things like lists or groups of data. 5m View lesson
- 6. Random Numbers In this lesson, we'll show how to generate random numbers. 5m View lesson
Introduction to OpenPYXL
- 1. Pip Install openpyxl and import openpyxl is the Python library that we'll use to connect our Python code to Excel. 5m View lesson
- 2. Creating Workbooks and Worksheets To work with workbooks and worksheets in excel, we need to import some things from openpyxl. 5m View lesson
- 3. Load Existing Excel File and Grab One Cell To load data from an existing Excel spreadsheet, we need to import load_workbook from openpyxl. 5m View lesson
- 4. Change Existing Cells - Method 2 There's more than one way to change data in a spreadsheet cell. This method is handy to use when looping using For Loops. 2m View lesson
- 5. Using Excel Formulas Using Excel formulas in our Python code is easy! 3m View lesson
- 6. Existing Excel - Cell Range In this lesson, we'll discuss how to grab a whole range of cells. 5m View lesson
- 7. Existing Excel - Column and Column Range We can grab an entire column of data from an Excel spreadsheet. 4m View lesson
- 8. Existing Excel - Row Range Use this method when you want to grab an entire row - or a range of rows - from an Excel spreadsheet. 4m View lesson
- 9. Existing Excel - Iterate Thru Rows Let's discuss another method to iterate through rows in an Excel spreadsheet when you need a little more control. 3m View lesson
- 10. Existing Excel - Iterate Thru Columns Just like iterating through rows, we can also iterate through columns. 3m View lesson
Hands on Exercise
- 1. Create Excel Spreadsheet Using Python and Random Numbers Let's take what we've learned so far and put it to use with an exercise! 6m View lesson
Formatting And Styling Spreadsheets With Python
- 1. Merge Cells and Unmerge Cells In this lesson, we'll cover how to merge and unmerge cells. 4m View lesson
- 2. Cell Font Properties We can change the font color and sizing by using the font property. 5m View lesson
- 3. Cell Alignment In this lesson, we'll discuss methods to change the alignment of text in a cell. 4m View lesson
- 4. Cell Fill (Pattern Fill) Pattern Fill allows you to change the color and pattern of a cell. 4m View lesson
- 5. Cell Fill (Gradient Fill) We can easily change the gradient color of a cell in a spreadsheet. 3m View lesson
- 6. Borders and Sides In this lesson, we'll discuss how to change the border style and thickness of a spreadsheet cell. 5m View lesson
Working With Charts And Graphs
- 1. Intro To Charts And Graphs - Pie Charts In this lesson, we'll learn how to add Pie Charts to a spreadsheet. 6m View lesson
- 2. Intro To Charts and Graphs - Bar Charts, Line Charts, Area Charts, ScatterCharts There are many other basic charts you can use with openpyxl, such as bar charts, line charts, area charts, and scatter charts. 5m View lesson
- 3. Bar Charts - Vertical, Horizontal, Stacked, and 3D In this lesson, we'll look at Bar Charts - Vertical, Horizontal, Stacked, and 3D - in a little more detail. 5m View lesson
- 4. Area Charts - 2D and 3D In this lesson, we'll discuss how to add 2D and 3D Area Charts to your spreadsheet. 4m View lesson
- 5. Radar Charts Let's show how to add Radar Charts to your spreadsheet. 4m View lesson
- 6. Doughnut Charts In this lesson, we'll look at how to add Doughnut Charts. 5m View lesson
- 7. Surface Charts We'll discuss how to add Surface Charts to your spreadsheet. 3m View lesson
- 8. Bubble Chart Use these steps to add a Bubble Chart to your spreadsheet. 5m View lesson
- 9. Projected Pie Charts In this lesson, we'll look at Projected Pie charts, which are pie charts with some chunks pulled out and projected to the side. 3m View lesson
Creating Excel Tables
- 1. Tables - Part 1 Tables are good for sorting data manually in your spreadsheet, and for drilling down and re-imagining your data. 2m View lesson
- 2. Tables - Part 2 In this lesson, we'll build a Table. 5m View lesson
- 3. Adding Images We'll cover how to add images to your spreadsheet. 4m View lesson
Time to humblebrag
Complete the course and pass the final test to get a verifiable CPD-accredited certificate
Share on LinkedIn
Add your certificate to your profile in one click, and let recruiters and managers see your new skills.
- CPD accredited
- Verifiable online
Taught by John Elder
John founded one of the Internet's earliest advertising networks (bannerclicks.com) and sold it at the height of the first dot com boom. John went on to develop the award-winning Submission-Spider search engine submission software that's been used by over 3 million individuals, businesses, and governments in over 42 countries.
John has over 20 years experience in web development, building professional websites across all platforms. John's passion for learning new technologies led him to master both front end and back end work, making him a sought after full-stack developer.
The reviews are in
See what other learners think of our courses
Your questions, answered
Frequently asked questions
We’ve compiled the most important information to help you get the most out of your experience. Can’t find what you’re looking for? Contact us.
How do I track my progress?
Your dashboard shows which lessons you’ve completed and how far you are through each course, so you always know where to pick up next.
Can I use GoSkills for team training?
Yep! With a business account, you can access the full course library along with the GoSkills LMS where you can assign courses, track team progress and report on results from one dashboard. Learn more about GoSkills for teams here.
What if I need help?
Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!