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
Once enrolled, our friendly support team is here to help with any course-related inquiries.
Summary
- Skill level: Beginner
- Lessons: 40
- Pre-requisites: Excel – Basic
- Estimated study time: 20h for all materials
- Certificate: Yes (Excel Certification)
- Accredited by: CPD
- Video duration: 3h 09m
Features
Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content
Accreditations & Approvals
All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable.
Instructors
All courses are taught by reputed trainers with relevant accreditations and industry experience.
Modules
Introduction
We’ll spend a few minutes discussing what we’ll learn throughout the course.
Download and Install Python
In this lesson, we’ll download and install the Python programming language.
Download and Install Sublime Text
We’re going to use the Sublime Text Editor to write our code in this course. So in this lesson, we’ll download and install Sublime Text.
Download and Install Git Bash
To run the Python programs that we write, we need a terminal. We’ll be using the git bash terminal in this course, so let’s show how to download and install Git Bash.
Virtual Environment
To use Python properly, we create a virtual environment. In this lesson, we’ll explain how to set one up.
Pip Install openpyxl and import
openpyxl is the Python library that we’ll use to connect our Python code to Excel.
Creating Workbooks and Worksheets
To work with workbooks and worksheets in excel, we need to import some things from openpyxl.
Load Existing Excel File and Grab One Cell
To load data from an existing Excel spreadsheet, we need to import load_workbook from openpyxl.
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.
Using Excel Formulas
Using Excel formulas in our Python code is easy!
Existing Excel – Cell Range
In this lesson, we’ll discuss how to grab a whole range of cells.
Existing Excel – Column and Column Range
We can grab an entire column of data from an Excel spreadsheet.
Existing Excel – Row Range
Use this method when you want to grab an entire row – or a range of rows – from an Excel spreadsheet.
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.
Existing Excel – Iterate Thru Columns
Just like iterating through rows, we can also iterate through columns.
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!
Merge Cells and Unmerge Cells
In this lesson, we’ll cover how to merge and unmerge cells.
Cell Font Properties
We can change the font color and sizing by using the font property.
Cell Alignment
In this lesson, we’ll discuss methods to change the alignment of text in a cell.
Cell Fill (Pattern Fill)
Pattern Fill allows you to change the color and pattern of a cell.
Cell Fill (Gradient Fill)
We can easily change the gradient color of a cell in a spreadsheet.
Borders and Sides
In this lesson, we’ll discuss how to change the border style and thickness of a spreadsheet cell.
Intro To Charts And Graphs – Pie Charts
In this lesson, we’ll learn how to add Pie Charts to a spreadsheet.
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.
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.
Area Charts – 2D and 3D
In this lesson, we’ll discuss how to add 2D and 3D Area Charts to your spreadsheet.
Radar Charts
Let’s show how to add Radar Charts to your spreadsheet.
Doughnut Charts
In this lesson, we’ll look at how to add Doughnut Charts.
Surface Charts
We’ll discuss how to add Surface Charts to your spreadsheet.
Bubble Chart
Use these steps to add a Bubble Chart to your spreadsheet.
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.
Tables – Part 1
Tables are good for sorting data manually in your spreadsheet, and for drilling down and re-imagining your data.
Tables – Part 2
In this lesson, we’ll build a Table.
Adding Images
We’ll cover how to add images to your spreadsheet.
Target Audience
- Graduates exploring placement in the entry-level Data Analyst positions across industries
- Professionals needing upskilling to be future-ready or become more productive in their current roles
- Experienced individuals exploring Python with Excel roles to join the workforce
How do I Access The Program
- Buy the course online
- Save your payment transaction receipt for any future reference
- Our team will share the credentials to enable you access your course online within 2 business days of payment transfer
Bulk Orders
Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.
Reviews
There are no reviews yet.