This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- Working with Excel using Python
Course Overview
Pre-requisites
- Basic Python
Target Audience
- Data Analysts: Those seeking to enhance their data manipulation and visualization skills within Excel using Python to streamline workflows and perform advanced data analysis.
- Python Programmers: Professionals proficient in Python looking to expand their expertise to include Excel manipulation and data handling for diverse projects.
- Business Professionals: Managers, executives, or professionals in finance, marketing, or operations aiming to optimize data processing, visualization, and reporting in Excel through Python automation.
- Students and Researchers: Those pursuing studies in data science, statistics, or any field requiring data analysis, seeking to leverage Python's capabilities in conjunction with Excel for data management and visualization.
- IT Professionals: Individuals in IT roles interested in integrating Python functionalities with Excel for tasks like automated reporting, data extraction, or customizing Excel operations.
- Entrepreneurs and Startups: Individuals managing or launching startups who need to efficiently handle and visualize data within Excel, seeking automation through Python for better decision-making processes.
- Anyone Seeking Automation in Excel: Individuals looking to automate repetitive Excel tasks, create dynamic reports, or visualize data in a more sophisticated manner using Python.
Curriculum 63 Lectures
-
Section 1 : Chapter 01
- Lecture 2 :
- Introduction to Excel
- Lecture 3 :
- Libraries used for Excel with Python
- Lecture 4 :
- Installation for OpenPyXl for Excel with Python
- Lecture 5 :
- Example 01
- Lecture 6 :
- Example 02
-
Section 2 : Chapter 02
- Lecture 1 :
- Chapter 02 Excel with Python
- Lecture 2 :
- Creating a Workbook
- Lecture 3 :
- Creating a worksheet
- Lecture 4 :
- Inserting data into cell Ex1
- Lecture 5 :
- Inserting data into cell Ex2 and Ex3
- Lecture 6 :
- Accessing cell data Ex1
- Lecture 7 :
- Accessing cell data Ex2
- Lecture 8 :
- Accessing cell data Ex3
- Lecture 9 :
- Accessing cell data Ex4
- Lecture 10 :
- Accessing cell data Ex5
- Lecture 11 :
- Loading a File
- Lecture 12 :
- Comments in Excel with openpyxl
- Lecture 13 :
- Saving a file in openpyxl
-
Section 3 : Chapter 03
- Lecture 1 :
- Chapter 03 Excel with Python
- Lecture 2 :
- Inserting Images in Excel
- Lecture 3 :
- Merging and Unmerging in Excel
- Lecture 4 :
- Formatting Text in Excel with Python
- Lecture 5 :
- Alignment in Excel with Python
- Lecture 6 :
- Border in Excel with Python
- Lecture 7 :
- Background color in Excel with Python
-
Section 4 : Chapter 04
- Lecture 1 :
- Outline Chapter 04 Openpyxl Excel
- Lecture 2 :
- Read Only Mode with Openpyxl
- Lecture 3 :
- Write Only Mode with Openpyxl
- Lecture 4 :
- Openpyxl with Pandas Example
- Lecture 5 :
- Openpyxl with Numpy Example
-
Section 5 : Chapter 05
- Lecture 1 :
- Outline Chapter 05 Openpyxl Excel
- Lecture 2 :
- Creating Column chart in Excel with Python
- Lecture 3 :
- Bar Chart in Excel with Python
- Lecture 4 :
- Create Line Chart in Excel with Python
- Lecture 5 :
- Area Chart in Excel with Python
- Lecture 6 :
- Bubble Chart in Excel with Python
-
Section 6 : Chapter 06
- Lecture 1 :
- Excel with OpenPyXl Chapter 06 Outline
- Lecture 2 :
- Conditional Formatting with Greater Value highlight
- Lecture 3 :
- Conditional Formatting with Less Value highlight
- Lecture 4 :
- Conditional Formatting with Equal Value highlight
- Lecture 5 :
- Conditional Formatting with Between Value highlight
- Lecture 6 :
- Conditional Formatting with First records highlight
- Lecture 7 :
- Conditional Formatting with Last records highlight
- Lecture 8 :
- Tasks 1 and Solution
- Lecture 9 :
- Tasks 2 and Solution
- Lecture 10 :
- Tasks 3 and Solution
-
Section 7 : Chapter 07
- Lecture 1 :
- Excel with OpenPyXl Chapter 07 Outline
- Lecture 2 :
- Sorting in Excel with Openpyxl
- Lecture 3 :
- Filter in Excel with OpenPyXl
- Lecture 4 :
- Print Setting with Openpyxl
-
Section 8 : Chapter 08
- Lecture 1 :
- Excel with OpenPyXl Chapter 08 Outline
- Lecture 2 :
- Table Creating in openpyxl
- Lecture 3 :
- Inserting row and data in table
- Lecture 4 :
- Inserting Column with Openpyxl
- Lecture 5 :
- ROW background color with openpyxl
- Lecture 6 :
- Column background color with openpyxl
-
Section 9 : Chapter 09
- Lecture 1 :
- Excel with OpenPyXl Chapter 09 Outline
- Lecture 2 :
- How to set Furmula in Excel with Openpyxl
- Lecture 3 :
- Excel Forumulas with Openpyxl
- Lecture 4 :
- More Excel formulas with Openpyxl
- Lecture 5 :
- Protect Workbook and Sheet with Openpyxl
- Lecture 6 :
- Data Validation with Openpyxl
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion. -
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
505853 Course Views
29 Courses